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