- 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
Select Dimensions in Microsoft Analysis Services
In this section will choose create few Dimension Tables. We will first create Time dimension then we will create Customer, Store and Product Dimensions.
Click on Next button on the Create Cube Wizard from the previous section
In the following dialog box, click on New Dimension
- You will see the Dimension Wizard Main Screen
- Click On Next and you will see ‘Choose How you want to create the Dimension’ screen
- You will create the Product Dimension Table in the next section