Reporting Options for Analysis Services Cubes: MS FrontPage 2002 - Page 4
May 5, 2003
Our PivotTable List is now connected to the HR Analysis Services cube. We can begin at this point to further the design of the PivotTable List in various ways, and to build reports. The "map sections" in the new PivotTable List appear, as shown in Figure 11, indicating drop points for filter, column, row, and totals / details fields in the PivotTable List. (Several differences exist in the appearance of the drop areas we see and those we saw in the Excel PivotTable Report in Lesson Ten.)
25. Click the PivotTable Field List button in the PivotTable List Toolbar, shown in Illustration 11.
The PivotTable Field List appears, as shown in Illustration 12. It is from this field list that we obtain the items that we drag and drop into our PivotTable List.
26. From the PivotTable Field List:
27. Right-click the CEO label.
28. Select Expand from the context menu that appears.
The Senior Management level appears to the right of the CEO level.
29. Right-click the Senior Management label.
30. Select Expand Items from the context menu that appears.
The Level level (the naming convention in the cube is a bit confusing here) appears to the right of the Senior Management level.
31. Right-click each label in the Employee hierarchy in turn, and click Expand Items, until we reach the Level 4 level.
32. Click, highlight, and drag the CEO level off the Pivot Table List, dragging it left until a red "X" -like (the Delete) icon appears.
33. Drop the CEO level to delete it, while leaving the remaining columns in place.
34. Right-click Level 04 and select Remove Field from the context menu (an alternate means of removing a label).
The PivotTable List appears as shown in Illustration 14.
35. From the PivotTable field List:
The Store Type, Store, and Department labels now appear side by side in the Filter Fields section, as shown in Illustration 15.
36. Choose File --> Save As from the top menu.
37. Name the file Headcount_Report.htm.
38. Use the Change button to modify the Page Title to Headcount - Report Design 1, as depicted in Illustration 16.
39. Save the file, leaving it open for the next section.
Next we'll perform a few remaining tasks to finish the PivotTable List example, both to explore the design environment, and to review a few concepts we encountered with the Excel PivotTable Report.