How to get top 5 rows of a selected column?
Answers were Sorted based on User's Feedback
Answer / bobj reporting
To get top 5 rows of a selected column you need to use
ranking.
Select the column then click on the "Apply/Remove Ranking"
button from the toolbar and select on "Add Ranking". In
ranking properties select Top and 5.
Remember: you can only assign ranking to a measure.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / manasa
To get top 5 rows of a select column we use ranking option.
In our report after running the document goto toolbar ->clink on ranking option ->under these tab enable top button ->click on ok-> observe the result
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gowthami
Create a new column and Implement the rank logic<(rank(measure column)>. after that use filter conndition where rank <6 then it will display the top 5 rows of the selected column
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Boxir2 and Boxir3?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
how to creat 2 way drilling mode.can any one know this
What is the difference between master-detail and Breaks?
What is meant by data federator and what is the use of it?
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
HOW TO PUBLISH A REPORT IN BO?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
What is the slice and dice?