10.2.4.3 Executing the Change of Product Dimension

You can execute the function from the Operations Framework module of OFSAAI. Define a new Batch and an underlying Task definition from the Batch Maintenance window of OFSAAI. For more information on defining a new Batch, see the How to Define a Batch section.

To define a new task for a Batch Definition:

1. Select the check box adjacent to the newly created Batch Name in the Batch Maintenance window.
2. Click Add (+) button from the Task Details grid. The Task Definition window is displayed.
3. Enter the Task ID and Description.
4. Select the Transform Data component from the Transform Data drop-down list.
5. Select the following from the Dynamic Parameters list:
   • Datastore Type: Select the appropriate datastore type from the list.
   • Datastore Name: Select the appropriate datastore name from the list.
   • IP Address: Select the IP address from the list.
   • Rule Name: Select FN_ALM_BI_SET_USER_DEF_DIM from the drop-down list.

     (This is a seeded Data Transformation procedure installed as part of the ALMBI Application. If you don't see this procedure in the list, contact Oracle Support).

   • Parameter List: These are comma-separated values of Source Dimension Table Name, Source Column Name, Member Column Name, and Skey Column Name.

     For example: 'DIM_COMMON_COA', 'N_COMMON_COA_ID', 'COMMON_COA_ID', and 'N_COMMON_COA_SKEY'.

6. Click Save. The Task definition is saved for the selected Batch.
7. Execute the Batch. You can execute a Batch definition from the Batch Execution window of the OFSAAI Operations module.

   Note:

   This process can also be run using the Simplified Batch user interface. In the optional parameters field within the Simplified Batch window, specify the parameters mentioned above. For more details, see the Simplified Batch Execution window.