18.1 Overview of the Account Summary Tables

Account Summary tables are loaded from the staging product processor tables using the Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework.

Customer account level data from the Oracle Financial Services Analytical Applications (OFSAA) staging product processor tables must be consolidated into a standardized relational Business Intelligence (BI) data model. This consolidation is done to have all the staging product processor table data in a single Fact table. The Account Summary table data can be used for building cubes which allow rollup of data for a dimension or a combination of dimensions. This relational BI model consists of the following vertically partitioned Account Summary tables that are organized by application subject area.

· FCT_CRM_ACCOUNT_SUMMARY

· FCT_PFT_ACCOUNT_SUMMARY

· FCT_FTP_ACCOUNT_SUMMARY

· FCT_REG_CAP_ACCOUNT_SUMMARY

· FCT_ECO_CAPITAL_ACCOUNT_SUMMARY

The preceding Account Summary tables are part of data model but there are no seeded T2T definitions available to populate these tables. T2T processes must be custom configured to populate these tables to use measures defined on these tables for reporting.