10.2.1.1.4 Change of Product Dimension through Batch SQLPLUS

The details are as follows:

• Function Name: FN_ALM_BI_SET_USER_DEF_DIM
• Parameters: BATCH_RUN_ID, MIS_DATE, DIMTABLENAME, SOURCECOLNAME,and MEMBERCOLNAME
• Sample Parameter Values: 'Batch1' , '20130310' , ' DIM_COMMON_COA', 'N_COMMON_COA_ID', 'COMMON_COA_ID', and 'N_COMMON_COA_SKEY'
• Manual Change of Product Dimension
  • Execute the following query and it will return three rows as seen in the following screen shot.

    update fsi_bi_setup_table set JOIN_REQUIRED='Y' where

    target_table_name='FCT_TABLE' and

    SOURCE_DIM_TABLE_NAME='DIM_COMMON_COA';

    update fsi_bi_setup_table set JOIN_REQUIRED='N' where

    target_table_name='FCT_TABLE' and

    SOURCE_DIM_TABLE_NAME='DIM_PRODUCT';

    By default, the JOIN_REQUIRED column will have 'Y' for the row where SOURCE_DIM_TABLE_NAME='DIM_PRODUCT'.

  • Execute the following statements to change the value of the JOIN_REQUIRED column for DIM_COMMON_COA.
  • Commit the transaction.

    It appears as seen in the following figure.