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

tell me two or three issues from client side and how to solve those issues?

1683


Can you define set to be cardinality?

566


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1572


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4193


what are the dimensions that you have in your current project?list them?

1615






What is the difference between group and associare?

574


Explain the different types of views used in cognos.

484


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1462


What is Bitmap Index?

589


How is cognos model organization works?

577


What is the function of model design accelerator?

511


what are slowly changing dimensions? Why we are used scd?

596


Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

1554


Can you explain dynamic query mode?

562


Why are meta service important then other services?

563