How to get top 5 rows of a selected column?
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 Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
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
Explain what sort of existing documents should business analysts refer to when starting on a new project?
normally we get many contexts when resolving loops or traps,how do u take them to reports.
What is the profile and package?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.