Specify Additional Calendars (Cube Wizard)

  • Article

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

Cube Wizard F1 Help (SSAS)

Other Resources

Cubes (Analysis Services)
Defining and Configuring Cubes and Cube Properties
Defining and Configuring Dimensions, Attributes, and Hierarchies

Help and Information

Getting SQL Server 2005 Assistance