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.

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)

1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  

---

actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 Answers  

---

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

0 Answers  

---

How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

2 Answers   IBM,

---

After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?

1 Answers  

---

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

4 Answers   IBM,

---

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

---

------------- How to identify the Revenue Column in Report?

0 Answers  

---

Can you define pivot?

0 Answers  

---

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

---

Can any one tell me cognos training class in chennai? thanks in advance...

5 Answers  

---

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  

---