what is performance tunning in BO in report level& designer
level?
- 1 Answers
- 5639 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
What is mean by stored procedure ? and how we can generate stored procedure universe?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Explain which versions are used in the bo dashboard work?
Any body help me...what are challenges did u face in Business object project?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
How toconnect one to one report?
Can we use unconnected lookup as dynamic lookup?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
what is the core universe and what is the active universe?
What are Alerter, Filters, Breaks and Conditions?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Teradata 
