3.1 Data Flow: OFS PFT Processing Area to OFS EFPA Reporting Area

The OFS PFT processing area holds dimension data and fact data. Fact data is held primarily in the management ledger table (referred to as Ledger Stat in this document). The seeded data flow processes outlined in this section are for the management ledger table. Similarly, the seeded dimension data movement process definitions are for the standard processing dimensions which come with the OFS PFT Attributes Members Hierarchies Module (AMHM).

For more details on:

  • Dimension data movement, see Dimension Loading Process and Time Dimension Population
  • Ledger Stat transformation, see Fact Ledger Population

Similar data movement process definitions can be created for any additional user-defined dimensions or custom tables. These extensions are also described in this document.

The data movements from the OFS PFT processing area to the OFS EFPA reporting area utilize the data transfer component of OFSAAI. Data transformation and loading is done with the Data Integrator module and is metadata-driven. For more information on the Usage of the Data Integrator Component, see OFS Analytical Applications Infrastructure User Guide.