Select Calendars (Dimension Wizard)
Use the Select Calendars page to create additional hierarchies representing fiscal, reporting, manufacturing, or International Standards Organization (ISO) 8601 calendars for the time dimension.
Note
This page will appear only if you have selected Server time dimension on the Select the Dimension Type page, or if you selected Build the dimension without using a data source on the Dimension Definition page and selected Time dimension on the Select the Dimension Type page.
Options
Fiscal calendar
Select to create a time hierarchy based on a fiscal calendar.
Start day and month
Select the day and month on which the fiscal calendar begins.
Note
This option is available only when Fiscal calendar is selected.
Fiscal calendar naming convention
Select the naming convention used by the fiscal calendar. Select either Calendar year name or Calendar year name +1.
Note
This option is available only when Fiscal calendar is selected.
Reporting (or marketing) calendar
Select to create a time hierarchy based on a reporting calendar.
Start week and month
Select the week and month on which the reporting calendar begins.
Note
This option is available when Reporting (or marketing) calendar is selected.
Week by month pattern
Select the week by month pattern used by the reporting calendar.
Note
This option is available when Reporting (or marketing) calendar is selected.
The following table lists the options available for the week by month pattern.
| Value | Description |
|---|---|
| Week 445 | The first month in the quarter has 4 weeks, the second month in the quarter has 4 weeks, and the third month in the quarter has 5 weeks. |
| Week 454 | The first month in the quarter has 4 weeks, the second month in the quarter has 5 weeks, and the third month in the quarter has 4 weeks. |
| Week 544 | The first month in the quarter has 5 weeks, the second month in the quarter has 4 weeks, and the third month in the quarter has 4 weeks. |
Manufacturing calendar
Select to create a time hierarchy based on a manufacturing calendar.
Start week and month
Select the week and month on which the manufacturing calendar begins.
Note
This option is available when Manufacturing calendar is selected.
Quarter with extra periods
Select or type the quarter that will contain the extra periods.
Note
This option is available when Manufacturing calendar is selected.
ISO 8601 calendar
Select to create a hierarchy based on the ISO 8601 calendar.
See Also
Dimension Wizard F1 Help
Dimensions (Analysis Services - Multidimensional Data)
Dimensions in Multidimensional Models