- 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 Customer Dimension in Analysis Services
In this section we will create the Customer dimension
Click Create Dimension button again
Unlike our product dimension, all the customer data is present in a single table called customer. So we will choose Star Schema and click Next
You will see ‘Select the dimension table’ screen. select the Customer table
Choose ‘Standard Dimension’ in the next ‘Select Dimension Type’ screen
In the Select The Levels screen choose Country, State_Province and Lname fields in that order
- Click Next and and you will see ‘member key columns’ screen. Simply click next here.
- In the next ‘Advanced Options’ screen click Next
- In the next screen, choose a name ‘Customer‘ for our newly created Dimension. Make sure we share this product dimension across other cubes by checking the ‘Share the dimension’ box.
- You will create the Store Dimension Table in the next section