Answer Posted / arangaraj

Hi,

All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like

For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.

For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.

if u want any query about cognos don't hesitate call me
by mobile:9787642227

----------------------What are the User Securities?

1795

---

What is main difference mapplets and mapping?

1099

---

write a query to display the departments with no employee?

1915

---

What is model filter?

1102

---

Can you define pivot?

998

---

How to publish a package by running Java Script?

2028

---

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

961

---

Can you define cognos impromptu?

978

---

What is difference between content store and content manager?

922

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2251

---

------------- How to identify the Revenue Column in Report?

2315

---

What is a Transformer?

1025

---

hi friends pls forward impropmtu interview question

2071

---

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

2073

---

What is metric store database?

942

---