An Introduction to Cognos Drill Through

Introduction to Cognos Drill-Through

Drill-Through is useful to navigate from the Source Report to the Target Report by passing data values between reports.

The following example shows a drill-through from the Summary report to a detail report showing Revenue breakup by Product Line.

To set the drill-through we have to create a filter parameter in the Target report and pass the data to the parameter from the Source report.

[Region] = ?p_Region?

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

 Drill-through Definitions is a wizard used to setup the drill-through path, action and report format.

Steps to set drill-through:

Right click on a field and select Drill-Through Definition

Provide the Report path and select the Action and Format, the default for Action is ‘Run the report’ and Format is ‘HTML’

We can either pass the parameter or we can add the data item value from ‘Drill through Definitions’ to the target report.