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
how to create cubes in transformer ?
What is the difference between a cascading report and drill through report?
How create measures and dimensions?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are the two types of framework manager?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What is the difference between the standard and metrics folder?
how to perform back drill through in cognos 8 what is the use of it
-----------With out using DrillThrough how to do Reports?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
How to publish a package by running Java Script?
whats the difference between previous version of cognos and cognos 8 BI?