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 diff between Decode and case ? Give some Example?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
How to Shedule the reports in Xi R2
What are the steps to be taken to schedule the report?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
what is universe testing(not mention check integrity)
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
When to use local filter and when to use global filter?
What is Array bind size in universe? Plz
can we cretae views in universe level?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?