Interested to Buy Any Domain ? << Click Here >> for more details...
hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
- 2 Answers
- 5954 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / annareddy
If u find the top 5 sal :
Create quires with Product type, Quantity, create Rank
column with rank(quantity)
Query1 give filter Rank<=5
Change the filter Application property from Before Auto
Aggregation to After Auto Aggregation.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
How to perform single signon in Cognos by using URL?
What are the ways to import data into catalog?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
is there any possibility to hide items other than render variable?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
How do you call a store procedure within a transformation?
2.How do you drill through report from Report Studio to Analysis studio?
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
What are the differences between main Cognos 8.2 and 8.3 ?
How to hide the prompts
Teradata 
