What is the diff between Drill through reports and Master
detail reports?

Answer Posted / ranga

Master Detail report - we are navigating to the detail
information within the same report. No second report is
involved.

Drill through report - we are navigating to the detail
information from one report to another. Second report is
involved in this scenario.

Depends upon the business scenario, how you want to handle
using either of the concepts. In MD report, you are
including the detail info in the same report which might
put load on the server everytime, you run the report. But
in the DThru scenario, we are just loading the server when
we wanted the detail info (not everytime the business wants
to go to the detail info.. and in those scenarios, dril
thru comes handy).

Guess that helps.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the dimensions that you have in your current project?list them?

1687


What is a Transformer?

741


How to create model and how to test model?

702


What is the model filter?

679


Can you explain the advantage of using shortcuts?

692






What are the types of hierarchies?

658


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3180


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1779


what is log in cognos?

743


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1933


How can we create a dynamic column name in cognos?

604


What do you understand by the term 'aggregate advisor?'

631


What is the use of Cognos scenario?

822


What is cognos reporting tool?

699


can we insert all types of charts in a list report? what r the realtime prompts?

1767