Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II - Page 3
January 16, 2007
We next need to remove the single Report Parameter that was associated with the parameterized Product Category filter that we have removed from the Filter pane. This Product Category Filter pane entry had been established with the Parameter checkbox selected, a common way to create a parameterized filter, as we saw in Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I, and as we shall see later in the practice session within this article. Because parameterization was selected for the Product Category filter, it follows that a Report Parameter might well have been created at the time the entry was made. We will now remove the remaining Report Parameter.
14. From the main menu, select Report -> Report Parameters..., as depicted in Illustration 9.
The Report Parameters dialog opens, and we see a single Report Parameter listed.
15. Ensure that the ProductCategory Parameter is selected.
16. Click the Remove button, as shown in Illustration 10.
17. Click OK to accept our modifications, and to dismiss the (now empty) Report Parameters dialog.
We will make preparatory modifications to the Dataset next. First, we will eliminate an unneeded data field.
18. Within the Data pane, click the Sales Reason column heading, to select it.
19. Drag the Sales Reason column heading into the Metadata pane, to remove it from the Data pane, as depicted in Illustration 11.
The Sales Reason column disappears, as desired. We will now add data fields that will be useful within our practice report.
20. Within the Metadata pane, expand the Date dimension, by clicking the + sign to its immediate left.
21. Expand the Calendar folder that appears within the Date dimension.
22. Expand the Calendar hierarchy within the Calendar folder.
23. Drag Calendar Year into the Data pane, dropping it to the left of the Sales Territory Group column, as shown in Illustration 12.
The new Calendar Year column appears, as desired.
24. In like manner, drag Calendar Quarter into the Data pane, dropping it between the Calendar Year and Sales Territory Group columns.
25. Similarly, drag Month into the Data pane, dropping it between the Calendar Quarter and Sales Territory Group columns.
26. Drag Date into the Data pane, dropping it between the Month and Sales Territory Group columns.
The newly added columns in the Data pane appear as partially depicted in Illustration 13.
Having made these changes on the Data tab, we are ready to move to the Layout tab, where we will perform further modifications to the report file.
27. Click the Layout tab, as shown in Illustration 14.
28. On the Layout tab, within the Matrix data region, select the value appearing underneath the Internet Total column heading.
29. Right-click the value in the text box (the value appears as =Sum(Fields!Internet_Total_Product_Cost.Value) ).
30. Select Delete from the context menu that appears, as depicted in Illustration 15.
31. Right-click the upper left-hand corner of the Matrix Data Region (the gray square).
The gray column and row bars (the handles) disappear, as a light, patterned outline forms around the Matrix data region, and the context menu appears.
32. Select Properties from the context menu, as shown in Illustration 16.
The Matrix Properties dialog appears, defaulted to the General tab.
33. Click the Groups tab.
34. In the Rows section of the Groups tab (in the upper half of the tab), select the sole group, named matrix1_Sales_Reason.
35. Click the Edit button, as depicted in Illustration 17.
The Grouping and Sorting Properties dialog appears, defaulted to its General tab.
36. Atop the General tab, change the existing Name to the following:
37. Click the row containing the Expression value (currently the expression is Fields!Sales_Reason.Value), within the Group on list, to enable the selector.
38. Select =Fields!Calendar_Year.Value within the selector, as shown in Illustration 18.