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

Creating a nested report – defining the master-detail relationship

Users want to see product lines, products, and corresponding unit costs. For every product, they also want to see the trend of sales over the last year.

We need to produce a list report with the required information and nest a line chart within it to show the sales trend.

Getting ready

Create a simple list report based on the Sales (query) namespace. Pull Products / Product line, Products/Product and Sales fact / Unit cost in the list.

How to do it...

To complete this recipe, we need to create a relationship between the list report created and a chart report that will be embedded into it. We can do this by defining a master-detail link between them.

  1. We already have a list report that ...

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