-
In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
-
Display the Source System Parameters tab.
-
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)
-
$$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'.
-
Using a text editor, edit the values in file_mcal_config_g.csv.
-
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.
OBIEE,OBIA,INFORMATICA,DAC TRAINING FOR DETAILS CALL 09959531832 Email Id:obieetraining03@gmail.com
Set Up a 4-4-5 Calendar
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment