Skip to main content

Development

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.

link

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?

 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

2nd one

 

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

3rd

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

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Sarmistha Panda

More from this Author

Categories
Follow Us
TwitterLinkedinFacebookYoutubeInstagram