Set Up a 13 Period 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 13P_CALENDAR_ID to 10001.
    Note: The task SIL_TimeDImension_McalWeek13Period 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