Reports of OFS IPA application can be configured to work on a Relational database or Essbase cubes. The Source of data for the reports is determined by the priority set for each Logical Table Source (LTS) in OBIEE RPD. Multi-dimensional databases store aggregated data for better performance and provide mechanisms for performing non-additive rollup within a hierarchy and defining complex derived measures using cross-dimensional operations. OFSAA Infrastructure is used for defining metadata about the cube and for building the cubes. Cubes are an optional source of data for Institutional Performance application.
OFS IPA application has the following seeded cubes:
· Cube for Financial Reporting - ADPAFNRE
§ Purpose: The purpose of this cube is to store data for reports belonging to Financial Reporting Dashboard.
§ Dataset: DSPAFR
This cube is based on the FCT_LEDGER_STAT fact table.
· Cube for Management Reporting - ADPAMNRE
§ Purpose: The purpose of this cube is to store data for reports belonging to Management Reporting Dashboard.
§ Dataset: DSPAMR
This cube is based on the FCT_MGMT_REPORTING fact table.
Topics:
· List of Cubes in IPA and RPA Applications