10.2.1.1.1 Change of Product Dimension through Batch Execution
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.