how we improve the performance of report and universe?
Answer Posted / sourabh
For performance of universe
1. One should never make alias of Fact tables, that
make universe very slow.
2. More number of contexts should be used rather than
creating aliases of tables.
3. Measure function must have projection function set
to Database delegated.
For report performance
1. It is better to make SQL Queries rather then using
sub reports in report.
2. Drill down Dimensions being used on report should
have hierarchy defined.
3. Create index awareness in objects.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what is the difference between slice and dice and cross tab report?
Can we Save (save as) WEBI Doc as DESKI?
in sap bi we have wad, then why we go for sap bo
what are the tables used in health care domain project and columns used in report?
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?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain about a task that really tested your analytical abilities?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
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 report template in b.o?
How many universes can be created in a project?
8. How much supervision have you typically received in your previous job?
What are the join problems comes appart from loop,chasm & fan Traps