how to find the rank in report studio?
i need steps for this question.
Answer Posted / gangadhar
1.select the list
2.drag the Data item1 & Data Item2 into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as----rank ([Data item1] for [Data
item2]) = 1.
6.If query item is number then it will display the ranks to
that number.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the considerations regarding performance kept in mind while setting up cognos?
Explain what is the difference between native sql and cognos sql?
what are slowly changing dimensions? Why we are used scd?
where you can save the report net documentation in our local system?
What do you mean by query studio?
Can you define drill across?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What are the two types of framework manager?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What are the message flows?
How do we convert from Numeric to be Words?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?