hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
Answer Posted / srini madhala
Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.
running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
------------------What is Inline Query?
What you mean by drill across?
What are all the different types of prompt in cognos?
What is the difference between group and associare?
how to create measures and dimensions?
Can you define metrics designer?
faq's on cognos
What are the different types of reports present in cognos?
What is model filter?
What is set to be cardinality?
What are the two types of framework manager?
is there any difference between operational database and data base?if yes what r they?
What is metric store database?
what is the difference between list report and crosstab report?
how you migrate reports to cognos 8 from previous versions?