Sunday, January 1, 2012

Cognos 10 Master Detail Report

Master Detail Report:
There are more than one query in a single report.
On this report, first query(Master) drives the data in second query(detail).

Excercise: Get the cumulated sales data in a list and then display a yearly graph each for every country.

Steps for Creating a master detail report:
1- Create a list report.
2- Drag Country, Sales Amount and Sales Qty.
3- From the toolbox, drag a chart and drop it in the list.
4- Drag and drop Country, Year, Sales Amount and Sales Qty.
5- Click on the chart; from the Data menu, click on master detail relationship
6- Create the link between the Two queries on Country...

Lets do it......

No comments:

Post a Comment