COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anjani on 09 Jul 2008 12:20:59 AM

Title: Difference b/w Drill through and Master detail report?
Post by: anjani on 09 Jul 2008 12:20:59 AM
Difference b/w Drill through and Master detail report?


Thanks in Advance
Title: Re: Difference b/w Drill through and Master detail report?
Post by: josepherwin on 09 Jul 2008 12:44:37 AM
Drill through means if you run report 1 and enable drill through, you will be able to open report 2 passing the same parameter as you'd have entered in report 1.

For example, Report 1 returns you with number of sales profit per region. by using drill through, you can open Report 2 (by clicking one of the value in Report 1) which will open list of items being sold in a particular region.

Master-Detail is like a "group by" function

example, you can have a report with number of sales profit per region, however if you create a master-detail relationship based on region, each region will display in different page of the report. in this case, the Region is the Master and the number of sales profit is the Details.

You can find more in the knowledge base.