how to find the rank in report studio?
i need steps for this question.
Answer Posted / uday
1.select the list
2.drag the query items into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as.
6.in functions we have rank function(in summaries)
7.drag the rank function like rank(query item)
8.if query item is number then it will give the ranks
to that number.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a Pivot?
How Metrics Studio is better than Report Studio?
How to test a cube?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What is Bitmap Index?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What are the roles defined by cognos platform?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What is a dimension?
How security is concerned with Reportnet? Explain its implementing steps.
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is a Query Subject?
------------------What is Inline Query?
What is the difference between Open Connection command ang Open Session Command?