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
tell me two or three issues from client side and how to solve those issues?
Can you define set to be cardinality?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate 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?
what are the dimensions that you have in your current
project?list them? What is the difference between group and associare? Explain the different types of views used in cognos. 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. What is Bitmap Index? How is cognos model organization works? What is the function of model design accelerator? what are slowly changing dimensions? Why we are used scd? 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! Can you explain dynamic query mode? Why are meta service important then other services?