A report may contain a drill-through definition
that can be filtered by multiple values in a single query item.
For
example, while analyzing an OLAP source, you may want to focus on
Canada and the United Kingdom. When you drill through, the target
report is filtered by both countries and regions. After you run the
report in IBM® Cognos® Viewer, you are prompted to choose
values when you navigate from the report to the drill-through target.
The values you specify are used to filter the results in the target.
For
more information about drilling through to a target, see Drill Through to Another Target.
Drilling
through using multiple values is available regardless of whether the
drill-through definition is authored in the Report Studio source report
or in IBM Cognos Connection, Drill-through Definitions.
In previous releases, this functionality was available only when the
definition was authored in IBM Cognos Connection.
To run
reports, or drill to targets that run reports in the delimited text
(CSV), PDF, Microsoft Excel
spreadsheet (XLS), or XML output formats, you require the generate
output capability for the specific format. For more information, see Report formats.
Procedure
- Run the report in IBM Cognos Connection and view it
in IBM Cognos Viewer.
Tip: Alternatively,
you can open an Analysis Studio, Query Studio, or PowerPlay® Studio report in their respective
studios.
- Ctrl+click to select more than one value in a column.
- If hyperlinks appear in the column in which you are attempting
to select cells, click in the empty area around the hyperlinks.
- If there are no visible hyperlinks but you know that a drill-through
target exists, select the cells you want to use as the filter, regardless
of whether they are in the same column. Note that when you select
multiple values from different columns, the resulting filter in the
target report performs an and rather than an or operation
with the values passed, for example, Canada and Camping Equipment;
United Kingdom and Fax.
- Right-click in one of the selected cells from which you
want to navigate, and from the menu that appears, do one of the following:
- Under Go To, click the drill-through target
name, if one exists.
- Under Go To, click Related Links.
On the Go To page, click the target report
you want to run.
Results
The target report runs and if it can be filtered by the selection
made in the source report, the target is filtered by those values.
