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 |
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
what is fantrap?
Can any please explain FOR EACH AND FOR ALL?
how to coneect to a server in a business objects
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
Explain what are the measure objects?
define universe parameters?
Can we have multiple domains?
how can u find the granularity in fact table
What are the types(Specific Names) of Scheduling in BO?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
tell me about aggregate awareness in detail?