5 Time Dimension Population

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.