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
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What is the functional & architectural differences between business objects and web intelligence reports?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how get the grand total in master-detail report?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is report template in b.o?
any difficulitis have you phase while creating bo reports and how did u solve it
What is a bo repository?
What would you consider as your biggest achievement and why?
Difference between b.o 5.1 and 6.1b?
What is the difference between condition & filter?