Modify the OLAP Report for Use within Our Practice Session
next make a few modifications to prepare the report for our practice session. Our objective will be to begin the session with a
simple OLAP report that contains no Parameters, and which is fitted with
a simple filter. Lets
open the report in Layout view (for those of us not already there) and
make the necessary settings to place it into a state upon which we can commence
our practice steps.
(or your own choice of a similar report) in the Solution Explorer.
from the context menu that appears, as shown in Illustration 1, as
Illustration 1: Opening
the New Report...
opens in Layout
start with the Data tab.
enter the Data tab, where we will remove a handful of components that we
do not need for our practice session. We will accomplish this from the
perspective of the MDX Query Builder, the main components of which are
labeled in Illustration 2 below.
Illustration 2: The MDX
With the Dataset
selector, select the ProductList dataset, as depicted in Illustration
Illustration 3: Select
the ProductList Dataset...
Once the Dataset
loads, click the Delete button, as shown in Illustration 4.
Illustration 4: Deleting
the Unneeded Dataset...
on the Microsoft Report Designer warning message dialog that appears
next, as depicted in Illustration 5.
Illustration 5: Confirm
Intention to Delete...
primary (and sole remaining) dataset, ProductData opens.
Within the Query
pane of the MDX Query Builder, right-click the column heading for
Internet Total Product Cost.
Internet Total Product Cost from the context menu that appears, as shown
in Illustration 6.
Illustration 6: Deleting
the Unwanted Measure from the Dataset
Within the Calculated
Members pane, right-click the sole Calculated Member, Profit.
on the context menu that appears, as depicted in Illustration 7.
Illustration 7: Deleting
the Calculated Member
the single entry in the Filter pane (directly atop the Query
to eliminate the existing Product Category Parameter from the Filter
pane, as shown in Illustration 8.
Illustration 8: Deleting
the Product Parameter from the Filter Pane
will make an addition to the Dataset next.
Within the Metadata
pane, expand the Date dimension, by clicking the "+" sign to
its immediate left.
Expand the Fiscal
folder that appears within the Date dimension.
Expand the Fiscal
hierarchy within the Fiscal folder.
Drag the Month
level into the Data pane, dropping it to the left of the Sales Reason
column, as depicted in Illustration 9.
Illustration 9: Adding
Months to the Dataset
new Month column appears, as desired.
will now add in a simple filter, to make our report a bit more manageable for
the practice session.
Click and drag
the Fiscal hierarchy into the leftmost box (currently containing the
phrase "<Select dimension>"), of the bottom row of the Filter
pane, as shown in Illustration
Illustration 10: Adding
the Date.Fiscal Hierarchy to the Filter Pane
Click the Filter
Expression box within the same row of the Filter pane to enable the
downward arrow of the Filter Expression selector to expose the selection
Periods by clicking the "+" sign to its immediate left.
2004 and FY 2005 by checking the boxes to the left of each, as depicted
in Illustration 11.
Illustration 11: Select
FY 2004 and FY 2005 as the Filter Expression
Click OK to
accept our settings, and to close the selector.
newly added row in the Filter pane appears, as shown in Illustration
Illustration 12: Our New
Entry in the Filter Pane
made the necessary changes on the Data tab, we are ready to move to the Layout
tab, where we can conclude our preparatory modifications to the report
Click the Layout
tab, as depicted in Illustration 13.
Illustration 13: 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 shown in Illustration 14.
Illustration 14: Delete
the Value for Internet Total Product Cost
the upper left-hand corner of the Matrix Data Region (the gray square).
gray column and row bars disappear, as a light, patterned outline forms around
the Matrix Data Region, and the context menu appears.