Microsoft Analysis Services Tutorial
Create Time Dimension in Microsoft Analysis Services - Continued
Choose Time Dimension in the following Select Dimension Type screen also
in the Date Column, select the_date as your Date Column.
- Click next and you will see the 'Create Time Dimension levels' screen
- Notice that the wizard processes the Time table and pre-determines that
your table contains Year, Quarter, Month, Day, Week, Day, Hour and Minute in
that order. Choose 'Year, Quarter, Month, Day' as your time levels and hit
next.
- In the following screen make sure 'Changing Dimension' is unchecked and
click Next
- In the final 'Finish the Dimension Wizard' screen type the Time for
Dimension Name.
- Make sure 'Share this Dimension with other Cubes' is checked. This will
enable your newly created Time dimension shareable across your cubes.
- You will create the Product Dimension Table in the next section
Next>>
Create Product Dimension
|
