Populating the Time Dimension for Analytics

Analytics workbooks use time elements such as Year, Month, and Week. The workbooks will not return any data unless you populate the Discoverer End User Layer time dimension folders with time elements by using the Update Gregorian Hierarchy in the Time Dimension concurrent program.

The Update Gregorian Hierarchy in the Time Dimension concurrent program populates the Time dimension folders in the Developer HRMSi - Administration - Analytic Dimensions business area with time information. So, for example, it populates the Time Year - (Dimension Level) folder with a list of years, and the Time Month - (Dimension Level) folder with a list of months.

Use the Submit Requests window.

arrow icon   To populate the Time Dimension folders:

  1. Select Single Request in the Submit a New Request window.

  2. In the Name field, select Update Gregorian Hierarchy in the Time Dimension.

  3. At implementation, use the following parameter values:

    Parameter Value at Implementation
    Date From The earliest date you need to see in your reports
    Date To The latest date you need to see in your reports
  4. Submit your request.

What's Next

Run this program when required to collect dates further in the future. For full information on this concurrent program, see: Update Gregorian Hierarchy in the Time Dimension

Restrictions

Do not use an unnecessarily wide date range, as this will impede performance.