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 Model Versioning or Versioning in Cognos Framework Manager?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
Diff b/w surrogate Key and Primary Key?
What are all the types of gateway used in Cognos?
What is Portal Tab?
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
What are shortcuts? Where it can be used? What are the advantages?
Can you define set to be cardinality?
What are the Ways to Import Data into Catalong?
What is conditional Formatting?
Mention the difference between ‘macros’ and ‘prompt’?
what is a query subjects item?