Reporting Options for Analysis Services Cubes: MS Excel 2002 - Page 6
April 7, 2003
Let's begin a basic Browse process to illustrate the steps involved:
1. Drag the Store Sales item (a measure) from the PivotTable Field List to the Data section (the portion of the PivotTable area with "Drop Data Items Here" appearing in gray). A tiny icon appears in the image of the four-part map of the PivotTable area. The "data" section of the icon image is blue, indicating that the item we are dragging is a measure.
2. Drop the Store Sales item in the "Drop Data Items Here" (the "Data") section of the PivotTable "map."
Most of the section highlights disappear, as shown above, and the PivotTable report displays the Total of Store Sales.
3. Drag the Store dimension to the row axis of the PivotTable report, where "Total" appears at present for Store Sales (the icon that appears as we drag will indicate the only allowed drop points, as the icon indicates when the dimension is in "drop territory.").
The PivotTable report now appears as shown below. We see Store Country has become the row header label.
4. Next, drag the Time dimension to the column axis of the PivotTable report, where the empty cell appears to the right of "Store Sales" and above "Total," as shown in Illustration 15. (Once again, the icon indicates when we are in the correct position for dropping).
5. Drag the Store Type dimension to the page axis of the PivotTable report (the blue outlined area at the top left corner of the worksheet, which probably still indicates "Drop Page Fields Here"), as shown in Illustration 16.
Let's center the column headings to enhance the appearance of the new report.
6. Select and click Table Options from the PivotTable menu on the PivotTable toolbar, as shown below.
The PivotTable Options dialog appears (as shown in Illustration 18). Many formatting and other global setpoints appear here. We will click the Merge labels checkbox.
For information regarding the purposes of the other setpoints, see the online Help and other documentation.
7. Click OK.
Compare the results set to that shown below.
We see that the labels are now centered.