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 |
Draw the architecture of traps?
WHAT DOES SQL TAB CONTAIN?
why less number of records in loop? why more number of records in traps?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
What are the join problems comes appart from loop,chasm & fan Traps
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
How many universes will run maximum in single project
What are the advantages of Xcelsius & Crystal reports over Infoview?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
What are @FUNCTION?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?