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

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

2323

---

What do you understand by the term 'dynamic cube'?

960

---

What is meant by Reportstudio shortcut?

2140

---

What are all the different types of prompt in cognos?

1021

---

What are the types of studio?

1118

---

which type of project we r going to snowflake schema

1948

---

what are the special features in cognos reportnet?

1018

---

explain how to create powerplay reports?

973

---

What you mean by drill across?

983

---

How to join multiple db in catalog?

968

---

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2272

---

What is the difference between a data mart and a data warehouse?

1012

---

What are products of cognos?

948

---

What is the enterprise class platform architecture of cognos 8?

996

---

How can you link a query to a data container manually in Report Studio?

2330

---