Mastering OLAP Reporting: Display a Dataset Field in a Report Page Header - Page 4
January 16, 2006
Preparation: Enhance the Report per the Business Requirements
As we noted in the Objective and Business Scenario section above, the authors / developers with which we are working have outlined a few enhancements that they wished to make to the report clone, to outfit it to meet a specific business need that is different than the need addressed by the original report. Let's make these changes, before addressing an approach to adding the previously problematic Dataset field to a Page Header, which we will also add to the report.
1. Right-click RS025_Dataset Field in Header.rdl in the Solution Explorer.
2. Select Open from the context menu that appears, as shown in Illustration 19.
RS025_Dataset Field in Header.rdl opens in Layout view, and appears as depicted in Illustration 20.
Click for larger image
Let's preview the report, so as to get a feel for its general operation prior to performing our enhancements.
3. Click the Preview tab to execute RS025_Dataset Field in Header.
Execution begins (the report initially executes with the default parameter setting).
The report executes, and appears as shown in Illustration 21.
We are now positioned to make modifications to the report to support the expressed business requirements. To do so, we will first go to the Data tab, and the MDX Query Designer, where we will make additions to the query to bring in newly required data elements.
4. Click the Data tab.
The MDX Query Designer appears, with the existing query in place, as depicted in Illustration 22.
5. Within the Metadata pane for the Adventure Works cube, locate the Sales Territory dimension.
6. Expand the Sales Territory dimension by clicking the "+" sign to its immediate left.
7. Drag the Sales Territory Country Attribute Hierarchy to the Results pane, dropping it between the existing Sales Territory Group and Internet Order Quantity columns, as shown in Illustration 23.
NOTE: A red line appears to indicate the drop point for the data element.
8. Within the Metadata pane, as before, locate the Sales Reason dimension.
9. Expand the Sales Reason dimension by clicking the "+" sign to its immediate left.
10. Drag the Sales Reason Type Attribute Hierarchy to the Results pane, dropping it to the left of the existing Sales Reason column (making Sales Reason Type the left-most column in the pane).
11. Click the Refresh Fields button, within the toolbar, to ensure that the Dataset fields are refreshed within the Datasets pane. We should see both Sales Territory Country and Sales Reason Type appear in the pane upon refreshment, as depicted in Illustration 24.
NOTE: If the Datasets pane is not in evidence, we can call it by selecting View --> Datasets from the main menu.
Having made the Dataset adjustments, we will now modify the query parameter default within the Filter pane.
12. Click the Filter Expression column within the Filter pane (the top pane in the MDX Query Designer), to enable the selector button, as shown in Illustration 25.
13. Click the downward pointing selector arrow.
The multi-value picklist appears, as depicted in Illustration 26.
14. Select the All Products checkbox within the selector, unchecking any others, as depicted in Illustration 27.
15. Click OK to accept changes, and to close the Filter Expression column selector.
The Filter Expression column of the Filter pane appears, reflecting our change, as shown in Illustration 28.