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
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Difference between b.o 5.1 and 6.1b?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain difference between zabo and webi?
Which versions are used in the bo dashboard work?
how many reports have u created ? explain a few.
How to schedule the report in b.o?
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
What is object stores?
How were the reports scheduled and how to resolve unexecuted documents?
what is xcelsius architecture?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
what is universe null
