how we improve the performance of report and universe?
- 4 Answers
- 14461 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
what are the day to day activities of BO administrator ?
In banking domain how many Fact tables,Dimension table are present?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what task is 98% of the required work of a business analyst?
what is universe null
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What Is Snow Flake Schema?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What are all difference between business objects 6.5 and xi r2?
Explain the data types present in bo and what happens if we implement view in the designer and report?
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 we drill up week to month?
Explain when we use aggregate awareness function in designer?
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
