hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
Answer Posted / 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 |
Post New Answer View All Answers
Why cognos decision stream is used?
what is hints in cognos and where we use it.
How to publish a package by running Java Script?
Can we test the report other than manual testing?
How can I schedule reports in cognos?
What is drill down and slicing and dicing whats the difference between them?
What do you understand by the term 'dynamic cube'?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Mention the difference between ‘macros’ and ‘prompt’?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How create measures and dimensions?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is the advantage of using shortcuts?
What are the considerations regarding performance kept in mind while setting up cognos?