Answer / Vikash Singh Rathore

In Cognos, there are several types of studios: Metrics Studio, Query Studio, and Mapping Studio.

What is Local Cache and how does it help in performance tuning

1 Answers  

---

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,

---

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

---

how can i test the reports in cognos

1 Answers   IBM,

---

Tell me about Schemas?

4 Answers  

---

What is difference between primary key and unique key constraints?

1 Answers  

---

What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,

---

where exactly determinants are used in cognos framework manager?

4 Answers   Satyam,

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

1 Answers   Accenture,

---

what is the difference between aggregation and role up aggregation ?

1 Answers   Systime,

---

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

---

---------------Can we use more than 1 Fact table ?

2 Answers   Bank Of America,

---