Interested to Buy Any Domain ? << Click Here >> for more details...
how we improve the performance of report and universe?
- 4 Answers
- 15497 Views
- Accenture, IBM, I also Faced
- E-Mail Answers
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
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What Is The Difference Between Oltp And Olap?
When we use aggregate awareness function in designer?
how to create metric universe ?
What is a bo repository?
Can Bo generates the Report from the cubical data Explain?
8. How much supervision have you typically received in your previous job?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain how many universes can be created in a project?
what are the tables used in health care domain project and columns used in report?
Explain is there any default username & pwd for bo designer & supervisor?
Can anybody tell me what are the tuning problems?
Explain the difference between union and group?
Explain what is the difference between slice and dice and cross tab report?
When to use local filter and when to use global filter?
