1. User Guide
  2. Utilities
  3. Reverse Population
  4. Tables As Part Of Reverse Population

4.1.1 Tables As Part Of Reverse Population

Dimension data is stored in the following set of tables:

  • DIM_<DIMENSION>_B: Stores leaf and node member codes within the dimension.
  • DIM_<DIMENSION>_TL: Stores names of leaf and node and their translations.
  • DIM_<DIMENSION>_ATTR: Stores attribute values for the attributes of the dimension.
  • DIM_<DIMENSION>_HIER: Stores parent-child relationship of members and nodes that are part of hierarchies.

Data present in the above set of dimension tables are transformed into the following set of OFSA Legacy tables.

The reverse population routine synchronizes the dimension data between the new dimension tables and the OFSA Legacy tables. Reverse population occurs automatically if enabled in the AMHMConfig.properties file. In the AMHMConfig.properties file, set the Parameter value to Y for a specific Dimension Id. The setting in the AMHMConfig.properties only impacts dimension values entered through the interface. Reverse population must be executed as a batch for bulk loading.

Reverse population will automatically occur with object migration for key dimension members on the Target instance if AMHMConfig.properties has a property with Key=HIERARCHY_REVERSE_POP-<Infodom in Upper Case>-<Dimension ID> Value=Y.

For more information on how to define the reverse populate parameters in the AMHMConfig.properties file, see Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) User Guide.

  • OFSA_LEAF_DESC: Stores the description of leaf members that are part of the dimension.
  • OFSA_NODE_DESC: Stores the description of nodes that are used within the hierarchy.
  • OFSA_DETAIL_LEAVES: Stores the attributes of Common COA dimension.
  • OFSA_DETAIL_OTHER_COA: Stores the attributes of GL or Product or any other key dimension.
  • OFSA_DETAIL_ELEM_B/OFSA_DETAIL_ELEM_MLS: Stores the attributes of Financial Elements dimension.
  • OFSA_IDT_ROLLUP: Stores the hierarchy as level-based.
  • OFSA_LEVEL_DESC: Stores the hierarchy levels.

Reverse population is done for all key dimensions that are configured within the OFSAAI framework.