Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between drill down and drill through?
- 10 Answers
- 61984 Views
- DELL, Deloitte, Systime, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 ? | 29 Yes | 2 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
How to a create header dynamically in a crosstab report in cognos 8.1?
how u create security to reports ????
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
what is fact less fact give me proper example?
what is the main advantage of impromptu over cognos reportnet?
How do we drill through from a powerplay cube to reportnet?\
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
What is the use of report studio?
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview
Teradata 
