Preparation: 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 is to begin the session with a simple OLAP report that contains
significant depth to render navigation useful. The report, as it currently
exists, is a simple, single-page presentation; we will add a bit more structure
and volume to generate
a presentation whereby we can benefit from an ability to easily navigate
between sections and pages. Once we have added the data and levels to provide
a richer presentation, we can commence our practice steps within the focus of
this article, the enablement, and use of the Document Map.
(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
view, where we will start with the Data
enter the Data tab, where we will make a simple adjustment to the
reports primary dataset. 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
Within the Dataset
selector, ensure that the ProductData dataset (the default), is
Click the Execute
button (!) to generate the currently specified dataset in the Data
pane, as depicted in Illustration 3.
Illustration 3: Execute
the Query to Populate the Data Pane
pane populates, and appears much as that shown above. It is here that we
will make a modification to the query specification to support a richer report
layout, for the reasons we have described earlier.
Within the Metadata
pane, expand the Product dimension by clicking the + sign to its
Click the Product
attribute hierarchy that appears within the Product dimension
folders exposed contents, to select it.
Drag the Product
attribute hierarchy into the Data pane, dropping it at a point between the Sales Territory Group
column and the Internet Order Quantity column (a red beam appears at
the perspective drop point), as depicted in Illustration 4.
Illustration 4: Dropping
the Product Attribute Hierarchy into the Data Pane ...
hierarchy appears (with its associated data members) between the Sales Territory Group and the Internet Order
Quantity columns, as partially shown in Illustration 5.
Illustration 5: The New Data
Column Appears (Partial View)
have a richer dataset (an additional new level, containing many new members),
upon which we can modify the existing report to present significantly more
information - giving us a presentation within which we can support navigation
in a more meaningful context than we might even find necessary with a
single-page report. 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
Click the Layout
tab, as depicted in Illustration 6.
Illustration 6: Click
the Layout Tab
Layout tab, within the Datasets pane, expand the topmost dataset, ProductData.
the new Product attribute hierarchy, as shown in Illustration
Illustration 7: The Newly
Added Product in the Datasets Pane
On the canvas
area of the Layout tab, Click inside the upper left corner of the Matrix
Data Region to give the Matrix the focus.
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
depicted in Illustration 8.
Illustration 8: Select
Properties from the Context Menu ...
Properties dialog appears, defaulted to the General tab.