------Diff B/W DrillThrough and master and Detailed Report?
- 2 Answers
- 5747 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sharath
In drill thruogh reporting we aceess a report from another
report using a column,url etc.In this type of reporting
atleast we need to have two reports and we must have a
common column in these reports.
ex:we have two reports emp(eno,ename,dno),dept
(dno,dname,loc).
from emp report if at all we want know the dept information
of a particular emp, by just clicking the dno in emp table
we can go to dept report .
In master detailed reporting,unlike drill through we have
only one report in this.
but we can have different reports to display the same
information in the same page.
ex:we can have cross-tab and chart in the same report.
plz tell me if it helps you.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / numbsyd
in simple terms, master-detail report links two objects in a
report where as drill thru needs a saved report to creat a
drill thru(you can create drill thru on the same report or
you can user another saved report)
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
What do you understand by the term 'dynamic cube'?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
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
------------ Diff b/w MemberCaption and MemberDescription?
What is the difference between macros and prompt?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
What is the difference between Open Connection command ang Open Session Command?
What is the importance of Dimension in the cognos.
Teradata 
