10.2.4.5 Manual Change of Product Dimension

Execute the following queries:

update fsi_bi_setup_table set JOIN_REQUIRED='N' where

target_table_name='FCT_TABLE' and SOURCE_DIM_TABLE_NAME='DIM_PRODUCT';

INSERT INTO FSI_BI_SETUP_TABLE

(target_table_name,target_col_name,member_col_name,source_dim_table_name,

source_column_name,skey_column_name,join_required) VALUES

('FCT_TABLE','N_PRODUCT_SKEY','TM_COA_ID','DIM_TM_COA_ID','N_TM_COA_ID',

'N_TM_COA_SKEY','Y');