How to get top 5 rows of a selected column?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the data types present in bo and what happens if we implement view in the designer and report?

558


What is a bo repository?

589


What is the difference between absolute and relative div positioning?

578


how many reports have u created ? explain a few.

1656


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1969






Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2597


What is thumbnail?

578


8. How much supervision have you typically received in your previous job?

1830


Explain is data mart?

588


what are the tables used in health care domain project and columns used in report?

4035


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1815


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

573


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1969


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1574


what is document design in boxi,have u participate in that

1660