8 Fact Ledger Population
Fact Ledger population involves populating the
FCT_LEDGER_STAT table from the FSI_D_MANAGEMENT_LEDGER
table. The FSI_D_MANAGEMENT_LEDGER table is optimized for processing
purposes but is not a convenient structure for reporting purposes. In generating
FACT_LEDGER_STAT, time from LEDGER_STAT is transformed
into an explicit dimension in FACT_LEDGER_STAT.
Fact Ledger Population transformation is used to populate the
FCT_LEDGER_STAT table from the Profitability
FSI_D_MANAGEMENT_LEDGER table. The horizontally structured
MONTH and YTD columns in the Management Ledger
table are transposed to a vertical structure. The twelve Month Columns in
FSI_D_MANAGEMENT_LEDGER are replaced by a single
N_AS_OF_DATE_SKEY column in FCT_LEDGER_STAT with
each month value stored in N_VALUE column.
Similarly, the YTD column value is stored in N_VALUE_YTD. This is done
to make reporting easier, considering Time is a dimension in most of the reports.
The database components, used by the Fact Ledger Population transformations are:
- Database function
FSI_LEDGER_STAT_TRM - Database function
LEDGER_STAT_TRMwhich is called by the functionFSI_LEDGER_STAT_TRMas mentioned earlier.