10.2.3.1 Execution

Changes required in the Database Layer:

Changes to the Database Layer can be achieved in two ways:

• Batch Execution

  Follow the steps mentioned in section Case 1 of 'Change of Product Dimension through Batch Execution'.

• Manual Execution
  1. Execute the following query and it will return three rows. By default, the JOIN_REQUIRED column will have 'Y' for the row where SOURCE_DIM_TABLE_NAME='DIM_COMMON_COA'.
  2. Execute the following statements to change the value of JOIN_REQUIRED column for DIM_GL_ACCOUNT.

     update fsi_bi_setup_table set JOIN_REQUIRED='N' where target_table_name='FCT_TABLE' and

     SOURCE_DIM_TABLE_NAME='DIM_COMMON_COA';

     update fsi_bi_setup_table set JOIN_REQUIRED='Y' where

     target_table_name='FCT_TABLE' and

     SOURCE_DIM_TABLE_NAME='DIM_GL_ACCOUNT';

  3. Commit the transaction.