Interested to Buy Any Domain ? << Click Here >> for more details...
how we improve the performance of report and universe?
- 4 Answers
- 15151 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
Explain the difference between union and group?
Difference between zabo and webi?
Can more than 1 metric be applied on an analytic in business objects?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
what are the tables used in health care domain project and columns used in report?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain is there any default username & pwd for bo designer & supervisor?
what is the difference b/w the refresh and buffered data?
Explain about a tricky situation for which you found a very simple solution?
can anybody tell me about complicated object you have created
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain the data types present in bo and what happens if we implement view in the designer and report?
