Business data commonly represents information as of a point in time (for example, a balance as of a point in time) or as of a particular time (for example, income for March month). The rollup of a particular balance depending on their nature could be a simple additive rollup wherein the child member balances are added up to arrive at the parent node balance (for example, Ending Balance) or non-additive rollups wherein a node formula are used to specify how to rollup the child member balances (for example, three months rolling average).
The database components, used by the transformations are:
· Database function FN_DIM_DATES
· Database procedure PROC_DIM_DATES_POPULATION that is called by the function FN_DIM_DATES mentioned earlier.
|
NOTE |
OFS EFPA does not use D_FISCAL_YEAR_START_DATE, D_FISCAL_YEAR_END_DATE, or N_DAY_OF_WEEK columns. |
Topics:
· Tables used by the Time Dimension Population Transformation