- 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
Cube Editor – Microsoft Analysis Services
In this section we will learn how to make changes to the Cube that we just designed using the Cube editor.
- Click on Insert menu and choose Tables
- In the Select Table screen, choose Promotion table and Add the click Close
- On the cube editor, double click on promotion_name and in the next Map The Column dialog box, select Dimension and click OK
- You will see a new node called Promotion Name in the left panel under Dimensions.
- Rename this node to Promotions
- Close the Cube editor and save changes. Choose No when prompted to design the storage.
- You will see how to design the storage in the next section