What is the difference between drill down and drill through?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1674


Can you define cognos powerplay?

619


How create measures and demensions?

595


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1538


hi friends pls forward impropmtu interview question

1676






how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

1686


what are the errors faced while bursting the reports and how to solve those errors?

1554


What is the advantage of using shortcuts?

632


Define dimensions?

608


How security is concerned with Reportnet? Explain its implementing steps.

1605


How to join multiple db in catalog?

559


What is the difference between Open Connection command ang Open Session Command?

1908


How create measures and dimensions?

592


write a query to display the departments with no employee?

1539


What is a Query Subject?

648