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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / vidya prasad

Master Detail Report contain Nested Frame to produce flow
less information.
But in Drill through report we can access more Detail
Information in one Report by selecting Data item value from
Source Report.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Cognos Interview Questions

what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?

1 Answers   Dr Reddys, TCS, Thomson Reuters,


what are diff b/w cognos and business objects

6 Answers   HCL,


What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,


Explain about embedded & standalone filters?difference between them

1 Answers  






I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,


if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,


suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  


What is loop in frameworkmanager ?

4 Answers  


Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,


16. How can we create top 10 and bottom 10 records in the same list?

9 Answers   TCS,


What is the difference between Standard and Metrics folder?

0 Answers  


Categories