If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Difference b/w Drill through and Master detail report?

Started by anjani, 09 Jul 2008 12:20:59 AM

Previous topic - Next topic

anjani

Difference b/w Drill through and Master detail report?


Thanks in Advance

josepherwin

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.