Set Up a 4-4-5 Calendar

  1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
  2. Display the Source System Parameters tab.
  3. Set the value of $$GBL_CALENDAR_ID and $$GBL_DATSOURCE_NUM_ID as follows:
    • $$GBL_CALENDAR_ID: Should be the CALENDAR_ID of the Generated Calendar (4-4-5 or 13 period type of Calendars). By default the 4-4-5 calendar has a CALENDAR_ID of '10000' and the 13-period calendar has a CALENDAR_ID of '10001'.
    • $$GBL_DATASOURCE_NUM_ID: If Global Calendar is Generated Calendar: Should be the DATASOURCE_NUM_ID value of the OLAP (Data warehouse)
  4. Using a text editor, edit the values in file_mcal_config_g.csv.
  5. In DAC, set the value of 445P_CALENDAR_ID to 10000.
    Note: The task SIL_TimeDimension_McalWeek445 will run as part of the Execution Plan for your Subject Area. There are no separate Subject Areas for common dimensions; they are included in the core Subject Areas.

No comments:

Post a Comment