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.

Dimension Wizard

  • Click next and you will see the ‘Create Time Dimension levels’ screen

Dimension Wizard

  • 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.

Dimension Wizard

  • You will create the Product¬† Dimension Table in the next section
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .