4.1 Reverse Population

Reverse population procedure populates dimension members, attributes and hierarchies from new dimension tables to OFSA legacy set of dimension tables. ALM, TP and PFT engines refer to OFSA legacy tables for retrieving dimension member information.

Topics:

Note:

From PFT 8.0.4.0.14 release, the following entry will be seeded into SETUP_PARAMETERS_MATER table:

PARAM_SEQ PARAM_APP_ID PARAM_NAME PARAM_VALUE <SEQ NO> ALL FAIL_ON_HIERARCHY_MAX_DEPTH_ALL NO

Allowed values are YES or NO.

Default value for PARAM_VALUE is NO.

Reverse population hierarchy loader looks for a record in SETUP_PARAMETERS_MASTER table with PARAM_NAME = FAIL_ON_HIERARCHY_MAX_DEPTH_ALL

If FAIL_ON_HIERARCHY_MAX_DEPTH_ALL parameter value is found in the SETUP_PARAMETERS_MASTER table and PARAM_VALUE is set to NO, then continue with current behavior.

If FAIL_ON_HIERARCHY_MAX_DEPTH_ALL parameter value is found in the SETUP_PARAMETERS_MASTER table and PARAM_VALUE is set to YES, abort the loader and batch execution fails.

If FAIL_ON_HIERARCHY_MAX_DEPTH_ALL parameter is not found in SETUP_PARAMETERS_MASTER table then continue with existing behavior.

While saving a hierarchy from AMHM screen with more than 15 levels, even if the parameter FAIL_ON_HIERARCHY_MAX_DEPTH_ALL is set to YES, hierarchy gets saved and reverse population does not perform (which is the existing behavior).

On running the reverse population batch (DIMENSION_HIERARCHY_LOAD) for a hierarchy with more than 15 levels, the batch and task execution fails when the parameter FAIL_ON_HIERARCHY_MAX_DEPTH_ALL is set to YES. Also, an error is logged in FSI_MESSAGE_LOG table.

If the parameter is set to NO (or if the parameter is not available at all), then the reverse population batch will be successful, and only a warning message will be logged in FSI_MESSAGE_LOG which indicates the hierarchy has more than 15 levels.