16. How can we create top 10 and bottom 10 records in
the same list?
Answer Posted / suman
ex. if we have a report with 100 records then
1.select a column which has measures(ex: quantity)
2.click on calculate ,select operationtype as analytic &
operation as rank
3.select the measure col, click on sorting
4.select the measure col, click on filters(in edit data)
5.select combine filters
6.add a filterline
7.select the range as from 1 to 10
again click on add a filter & set the operation as OR &
range from 90 to 100
click ok & run
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are shortcuts? Where it can be used? What are the advantages?
What is called Cognos powerplay?
Is it possible to join multiple Databases in a Catalog?
what is model and say about process how to create model and how to test model?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Define datastores in cognos?
explain how to create powerplay reports?
what are the features in cognos8ui
faq's on cognos
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Define query items?
What are all the types of hierarchies?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What are the roles defined by cognos platform?
Write various indexes used in cognos?