16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 33550 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / itesh
simple man
top 10 alway will be on some measure based on some dim not
simply top 10 and bottom 10,
make q1>
get the rank of the measure rank(measure for dim )<=10
make q2
the rank in the desecending order of measure
rank(measure for dim desc )<=10
make q3=q1 union q2
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
how can I test reports in cagnos?
Explain the difference between powerplay transformer and power play reports?
faq's on cognos
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is defined as catalog and types of catalogs in Cognos?
what is the procedure for scheduling conditional rendering?
What is the enterprise class platform architecture of cognos 8?
What is the use of powerplay web viewer in cognos?
what is the main advantage of impromptu over cognos reportnet?
-----------Diff b/w OLAP and RDBMS?
What is looping and how to avoid it in framework manager?
whats the difference between previous version of cognos and cognos 8 BI?
Explain the characteristics of cognos?
What is drill down and slicing and dicing whats the difference between them?
Can you define fan trap?
