Report Studio

Using Drill-through Access

Using drill-through access, you can move from one report to another within a session while maintaining your focus on the same piece of data. For example, you select a product in a sales report and move to an inventory report about that product.

Drill-through access helps you to build business intelligence applications that are bigger than a single report. Drill-through applications are a network of linked reports that users can navigate, retaining their context and focus, to explore and analyze information.

Drill-through access works by defining the target report using prompt parameters, and then using information from the source report to provide answers to those prompts. An important part of defining a drill-through path is defining which values to use for each prompt. If a prompt is answered by the drill-through value passed to it, the prompt page does not appear.

What You Should Known

For a drill-through link to work, it is necessary to know:

the source
the target
how the data in the packages that contain these objects is related

Depending on the underlying data, you may create a drill-through definition and have Cognos match the data (dynamic drill-through) or create parameters in the target (parameterized drill-through).
whether to run the target report or to open it

The target of drill-through access is usually a saved report definition. The report can be created in Query Studio or Report Studio.
whether the users of the drill-through link in the source report have the appropriate permissions to view or run the target report
if the target is being run, in what format to run it, and what filters to use on the target

If you do not want to run the target report on demand, you may link to a bookmark in the saved output instead of running the report.

In PPM Reports, you can drill through

between reports created in different packages against different data source types
For example, you can drill through from an analysis against a cube to a detailed report against a relational data source.
from one existing report to another report using Report Studio.
between reports in Report Studio, or Query Studio, exploring data in many ways