Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

Answers were Sorted based on User's Feedback



HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS..

Answer / joydeep

I completely disagree with srinivas.
the question here is regarding drill thorugh reports. and
there are no levels in drill throughs. they are completely
different reports. we can have as many drill throughs as
possible if it makes sense to create that many drill
throughs.

ex: if we have a report on the year level then we can drill
through on the year and then go to a different report at
the monthe level same way we can add drill through in the
second report which is at month level to drill through to a
different report that is at the day level and so on. so we
can have as many drill through reports as possible as far
as it makes sense.

Is This Answer Correct ?    34 Yes 2 No

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS..

Answer / arya

joydeep is absolutely right

Is This Answer Correct ?    11 Yes 1 No

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS..

Answer / pavan kumar

we use 2Levels
DrillParent
|
DrillChild
|
SubChild

Is This Answer Correct ?    4 Yes 2 No

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS..

Answer / nasa

unlimited...


Is This Answer Correct ?    0 Yes 0 No

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS..

Answer / s.srinivas

Two levels summary and detail.

Is This Answer Correct ?    2 Yes 13 No

Post New Answer



More Cognos Interview Questions

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,


what is report studiio and how to start it?

2 Answers  


What is the complex report you faced in real time?

0 Answers  


what do u mean by bridge group? where we r using this one?

0 Answers  


----------------Describe DWH Architecture?

0 Answers   Bank Of America,






What is stitched Query?

5 Answers  


what do you mean by parallel execution of query?

1 Answers   Mind Tree,


How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,


what is the difference between list report and crosstab report?

0 Answers   IBM,


Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,


What is the size of the cube?

0 Answers  


what are versions of cognos from starting release to latest in the market?

4 Answers   IBM,






Categories