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."

Illustration 13: The Store Sales Measure in the Data Section (PivotTable Field List Docked)

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.

Illustration 14: The Store Dimension in the Row Axis

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).

Illustration 15: The Time Dimension in the Column Axis

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.

Illustration 16: The Store Type Dimension in the Page Axis

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.

Illustration 17: Selecting the Table Options Dialog

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.

Illustration 18: The PivotTable Options Dialog

7.      Click OK.

Compare the results set to that shown below.

Illustration 19: Format Changes Appear in the PivotTable Report

We see that the labels are now centered.

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers