On Accessing Data From An OLAP Server Using MS Excel - The Data in the Cube
(Page 3 of 6 )
This picture shows the "global picture" of the data, encompassing all Orders, all Products and all customers.
Right clicking on the Contact title allows you to drill down to the Region-based breakdown for the Contact title, as shown in the next two pictures.
You can drill down further by right clicking on the region to show measures based on Country as shown in the next picture, and so on. If you want to drill up, right click on the level you are in and pick drill up. If you see a + sign, it means you can drill down, and if it is a - sign you can drill up to a higher level.
Next: Accessing Data from MS Excel Pivot Table and Pivot Chart Wizard >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
