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,

---

does query is created for date prompt?

9 Answers  

---

What is called Cognos powerplay?

0 Answers  

---

-----------------What is Direct and Conventional loading?

0 Answers  

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

---

What is Index?

2 Answers  

---

What are the advantages and disadvantages of using Transformer cube?

1 Answers   TCS,

---

How do add dynamic titles in PP?

3 Answers  

---

What is Star schema group?

1 Answers   IBM,

---

There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

1 Answers   CTS, IBM,

---

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

---

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,

---