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
as we shall see later in the practice session within this article. Because
parameterization was selected for the Mastering
OLAP Reports: Parameters for Analysis Services Reporting, Pt. I 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
Report - >
as depicted in Illustration 9.
Illustration 9: Select
Report -> Report Parameters...
Parameters dialog opens, and we see a single Report Parameter
ProductCategory Parameter is selected.
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.
pane, click the Sales Reason column heading, to select it.
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.
pane, expand the Date dimension, by clicking the + sign to
its immediate left.
folder that appears within the Date dimension.
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
Calendar Year column appears, as desired.
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.
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.
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
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
data region, and the context menu appears.
the context menu, as shown in Illustration
16: Select Properties from the Context Menu ...
Matrix Properties dialog appears, defaulted to the
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.
tab, change the existing Name to the following:
Click the row
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