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.