What is the diff between Drill through reports and Master
detail reports?
Answers were Sorted based on User's Feedback
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 |
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 |
what is reprompt?
How to generate cubes in cognos?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
--------------Diff b/w ODS and OLAP?
what is the use of lock and unlock
-------------Diff b/w Union and Unionall?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
How create measures and dimensions?
What are all the types of hierarchies?
What are the considerations regarding performance kept in mind while setting up cognos?
What is a Complex report and explain?
what is the difference between aggregation and role up aggregation ?