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

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

4569


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

935


What is the difference between user and versatile user?

786


What task is 98% of the required work of a business analyst?

809


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1962


When we use aggregate awareness function in designer?

755


Explain about alerts in bos, under what situation we need to use alerts?

786


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

2175


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

826


Explain how to execute the plsql procedure from the report by clicking with mouse?

838


What is the dense rank?

859


is it possible to export the webi reports to crystal reports?with out using businessview?

2062


How to open a universe with out using the Designer ??

7092


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1685


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1659