Drill-through from crosstab intersection
We have a crosstab report that shows sales quantity by month and order method. We need to create drill-through links from months and sales values.
Getting ready
Create two target reports for the drill-throughs. One takes only Month as parameter. The other takes Month and Order Method (Henceforth referred to as Drill-1 and Drill-2 reports respectively).
Create a simple crosstab report to be used as main report. Pull Time dimension | Month on rows, Order method | Order method on columns, and Sales fact | Quantity as measure.
How to do it...
- Select the Month item placed on crosstab rows. Click on the drill-through definition button from the toolbar.
- This opens the drill-through definitions dialog. Create a new ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.