Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part I - Page 4
By William Pearson
on the context menu that appears, as depicted in Illustration 7.
Illustration 7: Deleting
the Calculated Member
when asked, Are you sure ....
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 (labeled Date.Fiscal) 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. Having 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 file.
Click the Layout
tab, as shown in Illustration 10.
Illustration 10: 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 11.
Illustration 11: 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.
from the context menu, as
shown in Illustration 12.
Illustration 12: Select
Properties from the Context Menu ...
Properties dialog appears, defaulted to the General tab.
In the Columns
section of the Groups tab (in the lower half of the tab), select the
middle group, named matrix1_Sales_Territory_Group.
Edit button, as depicted in Illustration 13.
Illustration 13: Editing
the Matrix1_Sales_Territory_Group Column Group ...
and SortingProperties 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_Territory_Group.Value),
within the Group on list, to enable the selector.
within the selector, as shown in Illustration 14.
Replacing the Existing Group Expression ...
to accept our modifications, and to close the Grouping and SortingProperties dialog.
on the Groups tab, to close the Matrix Properties dialog.
Once again on
the Layout tab, within the Matrix Data Region, right-click the
value appearing underneath the Internet Orders column heading (the
leftmost of the two remaining value cells).
on the context menu that appears, as depicted in Illustration 15.
Illustration 15: Modifying
Properties for the Count Value ...
On the Textbox
Properties dialog that next appears, click the Format tab.
existing Format code setting (in the upper left corner of the Format
tab) with the following string:
we are simply changing the existing format to one more appropriate for a count
value. The Format code appears on the Format tab of the Textbox
Properties dialog as shown
in Illustration 16.
Illustration 16: Replacing
the Existing Format Code ...
to accept our modifications, and to dismiss the Textbox Properties dialog.
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.