Fact Account Profitability

Fact Account Profitability entity stores fact data for reporting line items of revenue, costs, and expense related to each customer account. The data into this table is populated from other fact tables like:

·       FCT_COMMON_ACCOUNT_SUMMARY

·       FCT_PFT_ACCOUNT_SUMMARY

·       FCT_FTP_ACCOUNT_SUMMARY

·       FCT_REG_CAP_ACCOUNT_SUMMARY

·       FCT_ECO_CAP_ACCOUNT_SUMMARY

The following table lists the seeded Post Load Transformation Definition with related Source Table and Destination tables:

Table 42: Seeded Post Load Transformation Definition with Source and Destination Tables

See the Oracle Financial Services Analytical Applications Data Model Data Dictionary or the Erwin Data Model to view the detailed structure of the tables.

Information from account summary fact tables is populated to Fact Account Profitability through a mapping process. The reporting line dimension is mapped to measures present in the account summary. A PL/SQL procedure then populates the fact by reading the mapping definition.

The reporting line dimension is created/maintained from the Attribute Member Hierarchy Maintenance (AMHM) component of OFSAAI. A Reporting line item represents revenue, costs, or expenses. Rollup signage is set as an attribute for a reporting line. To know more about AMHM, see the Oracle Financial Services Analytical Applications Infrastructure User Guide.

The Account summary tables contain the revenue, costs, or expenses measures about an Account. Map Maintenance component of OFSAAI is used to map the measures of account summary tables (represented in a measure hierarchy) to reporting line hierarchy. A pre-defined mapping "Reporting Line Mapping" is seeded along with the application installer. Reporting Line Hierarchy and Reporting Line Measure Hierarchy are the two hierarchies which are used for the mapping. Reporting Line Hierarchy is a parent-child hierarchy that is based on the Reporting Line Dimension entity.

Figure 44: Reporting Line Hierarchy

Reporting Line Measure hierarchy is a Non Business Intelligence Enabled Hierarchy which is based on measures from the Account Summary tables.

Figure 45: Reporting Line Hierarchy

A seeded map is configured between the Reporting Line Hierarchy and Reporting Line Measure Hierarchy from Map Maintenance of OFSAAI.

Figure 46: Mapper Definition

Figure 47: Mapper Definition - Reporting Line Hierarchy

For more information on defining/maintaining Mapper, see the Oracle Financial Services Analytical Applications Infrastructure User Guide.