1. User Guide
  2. Dimension Population
  3. Time Dimension Population
  4. Overview of Time Dimension Population

4.5.1 Overview of Time Dimension Population

The Time Dimension is treated as a Calendar Dimension in OBIEE, which contains all dates for a specified period. The data is used on a day to day basis to populate the Account Summary Tables and many of the ALM BI result tables. The Time Dimension Population Process is used to populate the DIM_DATES table with values (between two dates) specified by the user.

The database components used by this process are:

  • Database Function: FN_DIM_DATES
  • Database Procedure: PROC_DIM_DATES_POPULATION, which is invoked by the function FN_DIM_DATES.