How to get top 5 rows of a selected column?

Answers were Sorted based on User's Feedback



How to get top 5 rows of a selected column?..

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

How to get top 5 rows of a selected column?..

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

How to get top 5 rows of a selected column?..

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

Post New Answer

More Business Objects Interview Questions

Draw the architecture of traps?

3 Answers   Wipro,


WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,


why less number of records in loop? why more number of records in traps?

1 Answers   Wipro,


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?

0 Answers   PWC,


what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers   Fujitsu, Virtusa,






What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,


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?

2 Answers  


How many universes will run maximum in single project

1 Answers   HP,


What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers   Reliance,


My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,


What are @FUNCTION?

4 Answers  


IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,


Categories