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


What is the difference between drill down and drill through?

Answers were Sorted based on User's Feedback



What is the difference between drill down and drill through?..

Answer / upendra raju

Drill down means navigating the summary level to detail
level in the same report. where as drill through is
connected to different reports.

Is This Answer Correct ?    111 Yes 9 No

What is the difference between drill down and drill through?..

Answer / karthik

Drill DOWN means a way to filter the results to a more
detailed level from the Parent Level.
Drill UP on the other hand means to go up to a Higher
(Parent) Level from a Lower (Child) level.
There is a another term for this : SLICING & DICING (Multi
Dimesion Analysis)

Drill Through on the other hand means to drill into (get
into ) another report for getting more details. The values
from the Parent(Main) report are passed to the Child
(Detailed Report) for filter conditions.

Is This Answer Correct ?    53 Yes 6 No

What is the difference between drill down and drill through?..

Answer / bash khan

Actually I found 4 different types of drilling mode.

Drill Down - When you move from summary level to detail
level in the same report and in the same hierarchy.

Drill Up - When you move back from detail level to summary
level in the same report and in the same hierarchy.

Drill Across - When you need to move from one hierarchy to
another.

Drill Through - When you need to get additional detail
data from the Database or from any other report.

Is This Answer Correct ?    28 Yes 2 No

What is the difference between drill down and drill through?..

Answer / ramesh

Drill down means to navigate one level or summary level to
next detailed level.And also the next detailed level is
shown inthe same report. But drill through navigate from
one report to another report. Here we can use some
parameters and other things are needed. Drill down is
applicable for only dims data.

Is This Answer Correct ?    17 Yes 5 No

What is the difference between drill down and drill through?..

Answer / cognos

May be one more difference is drillup and drill down we can
applay on dimentional reports,drillthrough can applay only
on relational data.

Is This Answer Correct ?    6 Yes 4 No

What is the difference between drill down and drill through?..

Answer / jim benjamin

Drill down/up is active when you have an OLAP data source
(cube or DMR) so you can drill up and down the hierarchy of
data. If your top level is a corporate organization you can
drill down to the department level and then to the employee
level if the hierarchy is setup in the cube. You can also
drill up from employee to dept to corp levels.

In a drill through you run another report by passing
parameters or data items from the host report used as
filters in the target report.

Is This Answer Correct ?    8 Yes 7 No

What is the difference between drill down and drill through?..

Answer / ram

Drill Down @ When you move from summary level to detail
level in the same report and in the same hierarchy.

Drill Up @ When you move back from detail level to summary
level in the same report and in the same hierarchy.

Drill Across @ When you need to move from one hierarchy to
another.

Drill Through @ When you need to get additional detail
data from the Database or from any other report.

Is This Answer Correct ?    1 Yes 0 No

What is the difference between drill down and drill through?..

Answer / suresh

drill through report allows you to go from summary to detail. For instance: You have a financial application in which you can show the balance and profit and loss for a specific time frame. Every general ledger displays the total amount of all transactions for this specific period. By clicking (Drill through) on one of the general ledgers you will see the underlying transactions for this specific period.


A drill down reports allows you to look to the data in different levels. For instance, a report displays information on Country level if we drill down the report displays information on state level. Next drill down will display information on city level. So Countries contains States, States contains Cities. So we can view all levels through drill down.
Another examples is Year contains Months, Months contains Weeks, Weeks contains Days, Days contains Hours, Hours contains Minutes.

Is This Answer Correct ?    0 Yes 1 No

What is the difference between drill down and drill through?..

Answer / ark chowdary

Drillthrough: It will navigate from summary to detail
report. (i.e Navigate from 1 report to another report.)

Drilldown: It will navigate from detail to summary level
information with in the report.

Is This Answer Correct ?    8 Yes 25 No

What is the difference between drill down and drill through?..

Answer / uzval_vee

Drill down means it will navigate from detail information to
summary level information with in report.

Drill through means it will navigate from summary to detail
from report to report.

above answer is according to my view,if anything wrong plz
post the answer

Is This Answer Correct ?    20 Yes 83 No

Post New Answer



More Cognos Interview Questions

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,


what is mean of Meta data definistions?

4 Answers   IBM,


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  


how to improve performance in report studio level

1 Answers   Wipro,


How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,






How to create users and permissions in cognos?

4 Answers   IBM,


hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

26 Answers   IBM,


-----------------What is Direct and Conventional loading?

0 Answers  


How you create IQD In ReportNet FrameWork?

3 Answers   IBM,


What are the main services provided by application tier?

0 Answers  


What are the advantages of cognos?

0 Answers  


What is the difference between group and associare?

0 Answers  






Categories