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
what are the dimensions that you have in your current project?list them?
What is a Transformer?
How to create model and how to test model?
What is the model filter?
Can you explain the advantage of using shortcuts?
What are the types of hierarchies?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
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 ?
what is log in cognos?
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
How can we create a dynamic column name in cognos?
What do you understand by the term 'aggregate advisor?'
What is the use of Cognos scenario?
What is cognos reporting tool?
can we insert all types of charts in a list report? what r the realtime prompts?