Answer / joydeep

drill through means navigating from one report to a
different report in order to get detailed data. while drill
up/down is done within the same report.

drill through can be done in relational, DMR and OLAP data.
relational to relational
DMR to DMR or relational
OLAP to OLAP, DMR or relational

drlii down/up can be done only on DMR and OLAP

Answer / mohit

drill through means navigating from one report to a
different report in order to get detailed data. while drill
up/down is done within the same report.

Answer / samba

drill through means navigating from one reprt to a
different report like parrent report to child report that
child report give detaild data.
while drill
up/down is done within the same report like detaild data to
summery data.

Answer / nasa

drill through means navigation from summary level to detail
level

http://pic.dhe.ibm.com/infocenter/cx/v10r1m0/index.jsp?
topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.0.doc%2Ft_id_
cr_rptstd_modrep_drill_through_access_110createadrill-
throughdefinition.html


drill down: it show the just next level not from summary to
detail...

Answer / s.srinivas

DRILL THROUGH ALLOWS U TO NAVIGATE FROM SUMMARY TO DETAILED
INFORMATION.DRILL DOWN AL SO SIMILAR KIND OF THING FOR
EXAMPLE WILL DO DRILL DOWN ON YEAR IF WU DRILL DOWN ON THIS
THE NEXT LEVEL WILL COME MEANS YEAR CONTAINS QUATERS, IT
CONTAINS MONTHS ,MONTHS CONTAINS WEEKS, WEEK CONTAINS
DAYS.SO,WE CAN VIEW ALL THE LEVELS THROUGH DRILL DOWN

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

1 Answers  

Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.

5 Answers  

What will happen if scheduling a report with a prompt page?

1 Answers   Ness Technologies,

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,

What are initial page components of Cognos connection?

0 Answers  

what is view? types of views?

3 Answers   HCL,

What is looping and how to avoid it in framework manager?

0 Answers  

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  

How we check the errors before running the report?

0 Answers  

What is a Cube?

0 Answers  

2. What is With Clause In Cognos?

2 Answers   Wipro,