O'Reilly logo

IBM Cognos 10 Report Studio Cookbook - Second Edition by Abhishek Sanghani, Ahmed Lashin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Copying and pasting drill links

Let's say that a crosstab report shows Sales Quantity by quarter (rows), Product line (columns), and Order method (columns). The report has several filters.

There is a drill-through report which is to be called from the report columns, that is, Product line and Order method. When called, all the filter values are to be passed.

In this recipe, we will see how to define the drill-through and parameter mapping once and then copy and paste it for other drills, thereby reducing the development time.

Getting ready

Create a crosstab report to be used as the main report in the following format:

Getting ready

Define all the prompts and filters ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required