1. User Guide
  2. Dimension Loading Process

4 Dimension Loading Process

The hierarchy data is natively stored in a parent-child structure within the Dimension Management component of OFSAAI. Dimension population involves the movement of dimension data from processing dimension tables (maintained by dimension management component of OFSAAI) to the reporting dimension tables used in Business Intelligence (BI) applications.

This data movement process is applicable only when OFS EFPA is installed along with the OFS PFT application. Dimension loading process has the following two components:

  • Hierarchy Transformation
  • Dimension Tables Population

The Dimension loading process for the different hierarchies is discussed in the following sections:

  • General Ledger: The members of this hierarchy are stored within the infrastructure metadata tables for OFS EFPA. Hence the hierarchy needs to be maintained separately for OFS PFT and OFS EFPA. This hierarchy need not be included as part of the hierarchy transformation process but should be part of the SCD process to move General Ledger (GL) dimension members from OFS PFT to OFS EFPA.
  • Financial Element: The members of this hierarchy are seeded through RDBMS insert scripts by the OFS EFPA application installer. This hierarchy has to be maintained separately for OFS PFT and OFS EFPA.
  • Organization Unit: This hierarchy in OFS PFT first gets flattened by the Hierarchy Transformation and is then moved to the hierarchy table for Organization Unit (DIM_ORG_UNIT) by the Dimension table population component (as explained in chapter Dimension Tables Population). The OFS PFT and OFS EFPA hierarchies can be kept in sync using the above two components.
  • Product: This hierarchy in OFS PFT first gets flattened through Hierarchy Transformation and is then moved to the hierarchy table for Product (DIM_PRODUCT) by the Dimension table population component (as explained in chapter Dimension Tables Population). The OFS PFT and OFS EFPA hierarchies can be kept in sync by using the above two components.
  • Time: The hierarchy table (DIM_DATES) for this hierarchy is loaded by the Time dimension population process (for more details, see Time Dimension Population.
  • Consolidation and Currency: The hierarchy data for these hierarchies are seeded through RDBMS insert scripts by the OFS EFPA application installer. These hierarchies have to be maintained separately for OFS PFT and OFS EFPA.
  • Legal Entity: The hierarchy data of Legal Entity is loaded through insert scripts based on the user-defined hierarchy. The above components in detail and the execution methods are explained in the following sections.