• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Leveraging the Power of OLAP... > Working with an OLAP Pivot Table

Working with an OLAP Pivot Table

You now have a blank pivot table, just as if your data was on another worksheet in Excel. As soon as you start dragging and dropping dimensions and measures, you'll have an eyeful of meaningful data. Let's start slicing the cube.

Arranging the Data

As with regular Excel pivot tables, there is a PivotTable toolbar and a PivotTable Field List. You will notice in Figure 10.10 that each field in the field list has an icon next to it. The fields Store Cost, Store Sales, and Unit Sales have an icon with two rows of ones and zeroes. This icon denotes that these fields are numeric measures. The other fields have an icon with a blue and grey hierarchy. These fields are the dimension fields. If your DBA correctly followed the Analysis Services tutorial, you'll see five dimensions: Customer, Product, Promotion, Store, and Time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint