Analysis Services
Create Time Dimension Levels (Dimension Wizard)
This step appears only if you are creating a time dimension. In this step, you select the levels for your time dimension. You can also specify a start date for your year.
Options
Select time levels
Click the date levels you want in your time dimension. These levels are created from the date-formatted column you selected in the previous step of the wizard.
Dimension structure
Preview the level structure of the dimension you are creating.
Year starts on
Set the start date for your year.
- Day
Select the day of the month on which the dimension's year starts.
- Month
Select the first month in your dimension's year.