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');