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
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
From the main
menu, select Report ->
as depicted in Illustration 9.
Illustration 9: Select
Report -> Report Parameters...
Parameters dialog opens, and we see a single Report Parameter
the ProductCategory Parameter is selected.
Click the Remove
button, as shown in Illustration 10.
Removing the Residual Report Parameter ...
to accept our modifications, and to dismiss the (now empty) Report
will make preparatory modifications to the Dataset next. First, we will
eliminate an unneeded data field.
Within the Data
pane, click the Sales Reason column heading, to select it.
Drag the Sales
Reason column heading into the Metadata pane, to remove it from the Data
pane, as depicted in Illustration 11.
Removing the Sales Reason Data Field from the Data Pane
Reason column disappears, as desired. We will now add data fields that
will be useful within our practice report.
Within the Metadata
pane, expand the Date dimension, by clicking the + sign to
its immediate left.
Expand the Calendar
folder that appears within the Date dimension.
Expand the Calendar
hierarchy within the Calendar folder.
Year into the Data pane, dropping it to the left of the Sales
Territory Group column, as shown in Illustration 12.
Illustration 12: Adding Calendar
Year to the Dataset
new Calendar Year column appears, as desired.
manner, drag Calendar Quarter into the Data pane, dropping it between
the Calendar Year and Sales Territory Group columns.
Month into the Data pane, dropping it between the Calendar Quarter
and Sales Territory Group columns.
Drag Date into
the Data pane, dropping it between the Month and Sales
Territory Group columns.
newly added columns in the Data pane appear as partially depicted in Illustration
Illustration 13: The New
Columns in the Data Pane (Partial View)
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.
Click the Layout
tab, as shown in Illustration 14.
Illustration 14: Click
the Layout Tab
Layout tab, within the Matrix data region, select the value
appearing underneath the Internet Total column heading.
the value in the text box (the value appears as =Sum(Fields!Internet_Total_Product_Cost.Value)
from the context menu that appears, as depicted in Illustration 15.
15: Delete the Value for Internet Total Product Cost
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.
Select Properties from
the context menu, as shown in Illustration
16: Select Properties from the Context Menu ...
The Matrix Properties dialog appears, defaulted to the
Click the Groups tab.
In the Rows
section of the Groups tab (in the upper half of the tab), select the
sole group, named matrix1_Sales_Reason.
Edit button, as depicted in Illustration 17.
Illustration 17: Editing
the Matrix1_Sales_Reason Row Group ...
and Sorting Properties dialog appears, defaulted to its General tab.
Atop the General
tab, change the existing Name to the following:
Click the row
containing the Expression value (currently the expression is Fields!Sales_Reason.Value),
within the Group on list, to enable the selector.
within the selector, as shown in Illustration 18.
Replacing the Existing Group Expression ...
to accept our modifications, and to close the Grouping and Sorting Properties dialog.
MS SQL Archives