On the Select Calendar Hierarchy page, you select one of the following calendar types:
Then, on the page, the wizard creates a hierarchy for the selected type and, thus, enables you to define the hierarchy structure and the member naming rules.
Depending on the calendar type that is selected, the page displays various sections.
Time Depth Rules (All Calendar Types)
To include a level within the hierarchy, select the check box next to the level. Not all levels can be used with all calendar types, and not all levels can be used in combination with other levels. For example, Semester and Trimester are mutually exclusive.
Time-depth selections define the members that are created in the date-time dimension and determine which semantic-rule sections are available to define year, month, or period characteristics.
When you select a check box, its associated level is expanded. Then, you can select an underlined labeling rule to open the Define Labeling Rules dialog box, wherein you can select the naming patterns to be applied to the date-time members of the selected level. Be sure that naming patterns are meaningful, and, for non-duplicate member outlines, do not use duplicate names.
Year Rules (Fiscal and Manufacturing Types)
You define a year by when the year starts or ends. Most start and end options require you to specify details, such as month, week, or day.
First, you select one of the following options. Then, you specify the required information. For example, if you select “Year starts on a specific date,” you specify a month and day.
Starting week number in month
Ending week number in month
Year starts on a week that includes a specific date
Year starts on the week on or immediately following a specific date
Year starts on a specific date
If you select the “Year starts on a specific date” option, you can select the “Enforce 53 weeks” option and then the Enforce 52 weeks” option or only the “Enforce 53 weeks” option. For both options, you can specify whether extra days are attached to the first week, extra days are attached to the last week, or the extra week is determined by the location of the fewest unattached days (Auto-merge).
Depending upon which option is selected, the following lists are available:
Month
Week
Day
Month semantic rules (Fiscal and Retail Types)
For fiscal and retail types, you select one of the following options, each of which is based on the selected year option:
Starting week number specified—Use the week that is specified in the “Starting week number in month” option.
Month always starts on a week that includes a specific date (dd)—Use the day number that is specified in the “Year starts on a week that includes a specific date” option.
Month starts on the week on or immediately following a specific date (dd)—Use the day number that is specified in the “Year starts on the week on or immediately following a specific date” option.
Month always starts on a specific day number (dd)—Use the day number that is specified in the “Year starts on a specific date” option.
Month always starts on a specific day number (dd)—Use the day number that is specified in the following Year option: “Year starts on a specific date.”
For retail types, you select the “By Qtr-Month pattern,” and define which months within a quarter contain 4 weeks, which months within a quarter contain 5 weeks, and which month within a year contains 6 weeks.
Period Rules (Manufacturing Type)
Manufacturing calendars use 13 periods, instead of 12 months. For each of the following options, you select a value:
Quarter having 4 periods—All other periods have 3 periods.
Period having 5 weeks—All other periods have 4 weeks.
When you click the Add Linked Attributes button, the Create Date-Time Dimension Wizard—Select Linked Attributes Page opens. Herein, you create attribute dimensions that you link to the date-time dimension.