1.5.8 Cube Entity

This topic describes how to define cube entity.

If the field that you are creating is of the type Cube Entity, indicate the entity that is applicable to the field. You can select a Cube Entity from the option list positioned next to this field. This contains the following Cube Entities:

• Currency
• GL
• Branch
• Customer
• Account
• Contract Ref Number
• User Ref Number
• Liability ID

For instance, you need to capture details of an additional customer for a transaction. You can choose the Cube Entity field type and select the Customer field. The list of customers maintained for your bank will be made available at the field as in any other Customer field in Oracle Banking Treasury Management.

1.5.8 Method for Populating the Cube Entity Values

1. If the field type is ‘Cube Entity’, the values of a field can be selected from Oracle Banking Treasury Management tables. If you select the field type as ‘Cube Entity.’
   The Cube Entity screen displays.

   Figure 1-6 Cube Entity

   
   Description of "Figure 1-6 Cube Entity"
2. On Cube Entity screen, specify the fields.

   you need to specify the method by which the values have to be populated. The options available are:

   For more information on fields, refer to the field description table.

   Table 1-5 Cube Entity - Field Description

   Field	Description
   Static/Dynamic	Static – If you choose this option, system will retrieve the values from a Oracle FLEXCUBE table. After specifying the cube entity, specify the table name, column name and where clause based on which the data will be retrieved from the table. If you have defined a cube entity once, you can reuse it. The adjoining option list displays all the cube entities, which you had used earlier displays. Select the appropriate cube entity. On selection of the reused cube entity, system will automatically display the table name, column name and where clause (if specified for the selected cube entity). You can however modify the condition in the where clause but not the table name and column name. Dynamic - If you choose this option, the values on the UDF will be populated based on the query written by the user Note: At the time of installation, the implementer will write the PL/SQL code for the derivation rule, validation rule and also the query for fetching a cube entity according to the requirements of the bank.
   Table	Depending on your selection in the ‘Cube Entity’ field, system displays the table name in which the selected cube entity is located. The value of the column (which is specified in the previous field) from this table will be picked up to populate the values of the new field.
   Description	After you enter the cube entity, you may enter a brief description of the cube entity. This description will be used for information retrieval.
   Where Clause	Enter the condition based on which the values from the specified column and table, the values of the new field should be picked up. Enter the condition in this field if you have indicated ‘Static’ method for populating the values of the cube entity.
   Query	This is the code, based on which the values of the new field will be picked up. The query has to be written if the option ‘Dynamic’ is selected.

3. Click the Ok button to close the screen.