dcsimg

BlackBelt Authoring: Conditional Drillthrough to Multiple Reports - Page 6

September 18, 2006

Although we have deleted the entry, which initially defined a Product Category parameter, we must also delete the related Report Parameter.

24.  Select Report -> Report Parameters ... from the main menu, as depicted in Illustration 46.


Illustration 46: Accessing Report Parameters ...

The Report Parameters dialog opens.

25.  Select the sole Report Parameter that appears within the Parameters list, ProductCategory.

26.  Click Remove in the bottom left corner of the dialog, as shown in Illustration 47.


Illustration 47: Removing the Report Parameter ...

The Report Parameters dialog clears completely.

27.  Click OK to accept our deletion, and to dismiss the Report Parameters dialog.

Having removed the parameter and extra dataset, we are ready to add two new parameters to customize the report to act as a target within our practice report set.

28.  In the Filter pane, select Sales Territory via the Dimension column selector button.

29.  Select Sales Territory Group in the Hierarchy column, to the immediate right of the Dimension column, within the Filter pane.

30.  Select Equal in the Operator column.

31.  Select All Sales Territories, via the checkbox within the selector for the Filter Expression column, as depicted in Illustration 48.


Illustration 48: Select All Sales Territories ...

32.  Click OK to accept the selection.

33.  In the Parameters column, to the immediate right of the Filter Expression column, click the checkbox to check it.

34.  Click the Dimension column box (which currently displays "<Select dimension>") in the next row, underneath the box where we selected Sales Territory earlier.

35.  Select Date via the Dimension column selector button that appears.

36.  Select Date.Fiscal Year in the Hierarchy column, to the immediate right of the Dimension column, within the Filter pane.

37.  Select Equal in the Operator column.

38.  Leave the box in the Filter Expression column blank.

39.  Place a check in the checkbox for the Parameters column, as we did for the box in the row above it.

The Filter pane of the Query Designer appears, with our settings, as shown in Illustration 49.


Illustration 49: The Filter Pane with our Settings

Next, we will modify the new Report Parameters that were created when we established them within the Filter pane. Settings for Parameters are, in some cases, adequate as they are automatically created. However, the intended use of this report, as a drillthrough target, will drive a need to enable passthrough of parameters. This means we will need to adjust some of the pre-established settings.

40.  Select Report -> Report Parameters ... from the main menu, as we did earlier.

The Report Parameters dialog opens, and appears, with the pre-defined settings for the initially selected parameter, as depicted in Illustration 50.


Illustration 50: Pre-Defined Report Parameter Settings

41.  Ensure that the top Parameter (named SalesTerritorySalesTerritoryGroup by default), is selected.

42.  Within the Prompt section of the dialog, uncheck the Multi-value checkbox, which will leave all the checkboxes in the section de-selected.

43.  Within the Available values section, click the Non-queried radio button.

44.  In the Default values section at the bottom of the dialog, click the Null radio button.

The relevant portion of the Report Parameters dialog for the SalesTerritorySalesTerritoryGroup parameter appears, with our adjustments, as shown in Illustration 51.


Illustration 51: Affected Report Parameters Settings for SalesTerritorySalesTerritoryGroup

45.  Click the second Parameter (named DateFiscalYear by default) to select it.

46.  Within the Prompt section of the dialog, uncheck all checkboxes, as necessary.

47.  Within the Available values section, click the Non-queried radio button.

48.  In the Default values section at the bottom of the dialog, ensure that the Null radio button is selected.

The relevant portion of the Report Parameters dialog for the DateFiscalYear parameter appears, with our adjustments, as depicted in Illustration 52.


Illustration 52: Affected Report Parameters Settings for DateFiscalYear

49.  Click OK to accept our modifications and to close the Report Parameters dialog.

50.  Select File -> Save All from the main menu, as shown in Illustration 53, to save our work to this point.


Illustration 53: Select File -> Save All

We are now ready to move to the third, and last, report. This report will serve as a second target report.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers