- Microsoft Analysis Services Tutorial
- Starting the Analysis Manager in Analysis Services
- Create Database for Analysis Services
- Create ODBC DSN for Analysis Services
- Create Data Source for Analysis Services
- Create a Data Cube in Microsoft Analysis Services
- Select Fact Table and Choose Measures in Analysis Services
- Select Dimensions in Microsoft Analysis Services
- Create Time Dimension in Microsoft Analysis Services
- Create Time Dimension in Microsoft Analysis Services – Continued
- Create Product Dimension in Microsoft Analysis Services
- Create Customer Dimension in Analysis Services
- Create Store Dimension in Microsoft Analysis Services
- Finish Building the Cube – Microsoft Analysis Services
- Cube Editor – Microsoft Analysis Services
- Design Storage and Process the Cube in Microsoft Analysis Services
- Browse the Cube Data in Microsoft Analysis Services
- Browse Cube Data – Change the Dimensions in the Grid
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