what is performance tunning in BO in report level& designer
level?
- 1 Answers
- 5922 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / guest
Analyze Report SQL for unnecessary Joins
1. First get the list of reports which are performing low
and get their SQL.
2. Analyze the report SQL for joins. There could be
unnecessary join which is causing query to perform low.
make a change in your universe accordingly to generate
query with optimized joins.
Analyze report Query for Indexes.
1. Get the report SQL , check the where clause
2. Check if indexes are user properly in SQL and also they
exist in database
Use Aggregates for measures
1. Use Aggregate aware for your measure objects to use
summary tables form Database
Use Partitions for high volume fact tables
1. Partitioning the fact table can boost your query
performance.
Array Fetch Size
1. Play with Universe options for setting up optimal value
of Array fetch Size parameter.
Universe Analysis for Shortcut joins
1. Analyze your reports and universe for possible use of
shortcut joins as they play little but important role in
performance.
Index Awareness
1. Try using Index Awareness from Universe side to generate
optimized query.
Universe Cleaning.
1. Make sure LOV is disabled measure objects.
2. Make sure LOV is disable for un-necessary dimension
objects and detail objects.
JOIN_BY_SQL
1. Try evaluating JOIN_BY_SQL universe parameter
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Explain what would you consider as your biggest achievement and why?
What is a bo repository?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain when to use local filter and when to use global filter?
What is the difference between the public object&schema object?
how to create metric universe ?
any difficulitis have you phase while creating bo reports and how did u solve it
8. How much supervision have you typically received in your previous job?
What Is The Difference Between Oltp And Olap?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
When to use local filter and when to use global filter?
what are the day to day activities of BO administrator ?
Explain is data mart?
Explain about a tricky situation for which you found a very simple solution?
