On Accessing Data From An OLAP Server Using MS Excel - Assembling Report Items
(Page 5 of 6 )
When you click Finish, you will be presented with place holder regions of the data starting from the third row; a Pivot Table menu bar; and a pivot table field list. You may click on the icons, MyCustomer, MyOrder, and so forth, and drag and drop them onto the place holder regions. The Pivot Filed List has all the items from MyFirstCube: the Dimensions and the Measures.
MyOrder and MyProducts items have been dropped onto the "Page Fields," while MyCustomers is dropped onto the Row fields. Only two of the four Measures, namely, Unit Price and Quantity, have been dropped into the "Data" place holder region, as shown in this picture. The picture shows a highly consolidated view of the data, for all products, all orders, and all customers.
Customizing Reporting Parameters From the consolidated view shown above, it is possible to view data for specific values of the products, the orders, and so forth. In the next picture, from all products, only the "1" is chosen. You may click on the + sign to expand the items and - sign to collapse.
In this picture from all orders only those that start with the letter "A" are chosen.
The data for these parameters will change, as shown in this picture.
Next: Formatting a Report and Creating a Chart >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
