How to get top 5 rows of a selected column?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When we use aggregate awareness function in designer?

555


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1897


What is the difference between business requirement document and use case document.

592


Is there any other repository domains rather than universe, security, document?

606


Explain the difference between union and group?

638






Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

553


What three things do you consider to be the most important factors for a manager?

609


Which versions are used in the bo dashboard work?

605


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:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3295


What is the functional & architectural differences between business objects and web intelligence reports?

564


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4199


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

1558


What is the difference between the public object&schema object?

582


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

606


What is top business?

573