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,

---

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

---

how to merge 2 crosstabs thans

0 Answers   HCL,

---

hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.

2 Answers   WNS,

---

what are the limitations of cognos reportnet?

11 Answers   IBM, Nestle, TCS,

---

what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,

---

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,

---

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

0 Answers   TCS,

---

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,

---

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,

---

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 Answers  

---

can any one pls send me the project flow at the time of interview

0 Answers  

---