1. User Guide
  2. Fact Management Reporting Population from FSI_D_MANAGEMENT_LEDGER Table
  3. Tables Used by the Fact Management Reporting Transformation

9.2 Tables Used by the Fact Management Reporting Transformation

The Fact Management Reporting Transformation uses the following tables:

  • FSI_FISCAL_YEAR_INFO: This table has the FISCAL year info. The entries required in this table are mentioned in the Prerequisites section.
  • FSI_BI_SETUP_TABLE: This table has the setup information used by the Fact Management Reporting Transformation. They are:
    • TARGET_TABLE_NAME: This is the destination table name for transformation.
    • TARGET_COLUMN_NAME: This is the Destination column name in the FCT_MGMT_REPORTING table.
    • MEMBER_COL_NAME: This is the column Name in source tables.
    • SOURCE_DIM_TABLE_NAME: This is the table to which the Ledger data has to be joined to get the surrogate key value.
    • SOURCE_COLUMN_NAME: This is the column in the dimension table
    • SKEY_COLUMN_NAME: This is the column in the dimension table which has the surrogate key value.
    • JOIN_REQUIRED: This provides the information, whether the column to be moved to the FCT_MGMT_REPORTING table is directly available in the FSI_D_MANAGEMENT_LEDGER table or a join has to be taken with the dimension table to get the skey.
    • GROUP_BY_REQUIRED: The group by is used to find the unique records of fsi_d_management_ledger for which the key column should exist as part of the target table's primary key.
    • FSI_D_MANAGEMENT_LEDGER: This table is the source for the transformation.
    • DIM_<dimension Name>: The flattened dimension tables used in Business Intelligence (BI) reporting are accessed to obtain the surrogate key to be populated to FCT_MGMT_REPORTING dimension columns. For example, DIM_ORG_UNIT, DIM_PRODUCT, and so on.
    • FCT_MGMT_REPORTING: This is the output table for the transformation

For more details on viewing the structure of these tables, see Oracle Financial Services Analytical Applications Data Model Data Dictionary or the OFS EFPA Erwin Data Model.