Databases Reference
In-Depth Information
Drag the Date Calendar:Calendar dimension hierarchy into the Background section and then
click the drop-down arrow to select the members Year 2008, 2009, and 2010.
4.
Drag the Sales Territory dimension hierarchy into the Background section and then select the
Europe dimension hierarchy. (This serves as a background filter for the report.)
5.
Drag the Amount measure into the Bottom Axis section.
6.
7.
Drag the Geography dimension hierarchy into the Series section and then select dimension
members at the country level. Clear All and Europe.
Note You can simplify selecting all members under a single parent node by right-clicking
and selecting All Children.
Figure 8-48 shows the result of dragging dimensions and narrowing by selecting members.
FIGURE 8-48 The Results of new report.
Tip Notice that there are three tabs. Using the Query tab, you can view the MDX query as a
result of dragging dimensions and selecting members. On the Properties tab, you can type
in the folder name, Reports, to keep things organized in Workspace Browser.
You can enter Data Elements by right-clicking anywhere on the chart. Figure 8-49 shows the result
of choosing options for adding a filter, a pivot, changing the report type, and changing the report
format.
Search WWH ::




Custom Search