How to display the top 5 records along with the additional
records,plus their sub and grand totals to be display in the
same block.
- 1 Answers
- 5966 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / anand
*1st step-* expression topcount([Products],5,[Revenue])
*2nd step-*then i will select this expression in detail
filter condition
like ([data item1])< 5
OR directly will double click on Measure column and write
it down this condition.
| Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
Can more than 1 metric be applied on an analytic in business objects?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What we need to discuss with designer before starting the universe designing.
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain about a tricky situation for which you found a very simple solution?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What Is The Difference Between Oltp And Olap?
how many reports have u created ? explain a few.
How to schedule the report in b.o?
Explain what would you consider as your biggest achievement and why?
What is difference between custom hierarchy and report based hierarchy?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how to create reports on screech?
