- 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
Browse the Cube Data in Microsoft Analysis Services
In this section, you will learn how to browse and slice and dice the data in your cube.
Using Cube Browser, you can see data in different ways, you can filter the amount of dimension data that is visible, you can drill down to see greater detail, and you can drill up to see less detail.
In the Analysis Manager tree pane, right-click the MySalesCube cube, and then click Browse Data.
Cube Browser appears, displaying a grid made up of one dimension and the measures of your cube. The additional four dimensions appear at the top of the browser.
In the next section you will learn how to replace the dimensions in the above grid