1.5.8 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 No
• User Ref No
• 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 are made available at the field as in any other Customer field in Oracle Lending.

To capture the details of cube entity

Specify the User ID and Password, and login to Homepage.

From the Homepage, navigate to User Defined Fields Maintenance screen.

1. From the User Defined Fields Maintenance screen, click Cube Entity.
   The Cube Entity screen is displayed.

   Note:

   The fields which are marked in asterisk red are mandatory fields.

   Figure 1-5 Cube Entity

   
   

   
   Description of "Figure 1-5 Cube Entity"

   
   
2. In the Cube Entity screen, you need to specify the method by which the values have to be populated. The options available are:
   • Static: If you choose this option, system retrieves the values from a Oracle Lending table. After specifying the cube entity, specify the table name, column name and where clause based on which the data is 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 automatically displays 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 are populated based on the query written by the user

     Note:

     At the time of installation, the implementer writes 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 1-3 Cube Entity

   Field	Description
   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 is 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 is 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 is picked up. The query has to be written if the option Dynamic is selected.