10.2.4.2 Executing the Change of Product Dimension

The database component used to change the product dimension or any other user-defined Product Dimension is FN_ALM_BI_SET_USER_DEF_DIM - Oracle Database function.

Table used by the Change of Product Dimension Process is FSI_BI_SETUP_TABLE. This table stores the Source Dimension Table Name, Source Column Name, Member Column Name, and Surrogate Key Column Name with the Join required flag. The flag JOIN_REQUIRED = 'Y' represents the active dimension to be considered for ALMBI Transformation.

Users must create a Batch Process for changing the product dimension. This process is explained in Executing the Change of Product Dimension.

The procedure takes Source Dimension Table Name, Source Column Name, Member Column Name, and Skey Column Name as additional parameters. Source Dimension Table Name is mandatory whereas Source Column Name, Member Column Name, and Skey Column Name are optional if a record with Source Dimension table Name already exists in FSI_BI_SETUP_TABLE. This process can also be run using the Simplified Batch window.