Specify Additional Calendars (Cube Wizard)
Use the Specify Additional 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 Build the cube without using a data source on the Select Build Method page and specified a time dimension on the Define New Dimensions 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 starts.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 starts.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 starts.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
Reference
Other Resources
Cubes (Analysis Services)
Defining and Configuring Cubes and Cube Properties
Defining and Configuring Dimensions, Attributes, and Hierarchies