How to get top 5 rows of a selected column?
- 3 Answers
- 8356 Views
- Patni, I also Faced
- E-Mail Answers
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 |
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
What is thin client And thick client..?
When we use aggregate awareness function in designer?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
What is meaning of fullpath client in business objects?
How to create an popup in the WEBI report if the report is showing partial result?
how many micro cubes can a report can have
How to create Index to the table in the universe designer and how it improves the Query performence
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Teradata 
