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 condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2100

---

What is the difference between static and dynamic conditions?

1037

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4161

---

Can you define confirmed dimension?

1038

---

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2067

---

What is Online View?

1915

---

How do you Parametermap variables in Quiries?

2225

---

What is the report studio?

994

---

What are various types of gateways in cognos?

999

---

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

900

---

What is cognos reporting tool?

1050

---

hi my name is siraj i want to know cognos queriy language

2239

---

---------------Tell me about DWH Concepts?

2098

---

What are cognos connection initial page components?

1085

---

--------------Explain Table of contents?

1988

---