Answer Posted / rajasivam.p

To find nth value

select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);

to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno

OR

To find 10 max records

select * from (select * from emp order by salary desc) where
rownum<=&n;

What is Additive function?

2031

---

Give me any example of semi and non additive measures?

967

---

How create measures and dimensions?

1076

---

How can I schedule reports in cognos?

1006

---

What are the different types of important services used in cognos?

1017

---

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

2090

---

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

2136

---

What is the importance of having monitor service in cognos?

1035

---

How do we drill through from a powerplay cube to reportnet?\

2352

---

------------------What is Inline Query?

2223

---

how to test reports in cognos?

1028

---

-----------With out using DrillThrough how to do Reports?

2047

---

Cleared COG-112 with 100% score today. What next certification should i go for?

1835

---

how u will design the report if the objects are available

2761

---

please please give me some banking calculations in framework manager.

2085

---