Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 801

In this section, you learn how to analyze multiple measures within a Pivot
table.
Drill up to the fiscal year level on the fiscal hierarchy from the last example.
Assume you want to see the quantity ordered along with the sales amount in
your Pivot table. Drag and drop the measure Internet Order Count from the
Pivot table field list into the data area. The pivot table now creates a new hier-
archy called "Data" on the row axes, and adds the two measures Sales
Amount and Order Count as members in this hierarchy. Corresponding values
in the data area show the values for these measures. This is shown in Figure
15-23 . You can select or deselect the members within the Data hierarchy. The
Pivot table creates two Total rows along the row axes corresponding to the
two measures Sales Amount and Order Count.
Figure 15-23
Custom Grouping within a Pivot Table
If any word in the English language is overused, it is the word "cool" — but
custom groupings are cool and must be described as such! When you ana-
lyze the results within Pivot table you might want to group certain members
and analyze the data for those specific members. For example, if you have
sales data for all the countries you might want to analyze the sales based on
continents. If continent is not a level in the hierarchy then you might have to
modify the cube design and add this information. Instead Pivot table helps
you to group members and provide a name. It is important to know that
Grouping functionality in Pivot Table is supported in SQL Server 2005 Service
Pack 1 and beyond. Follow the steps below to create custom groups within
pivot tables.
1. Create a Pivot Table by connecting to the Direct Sales cube in Ad-
venture Works DW database.