Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in BO in report level& designer
level?
- 1 Answers
- 6201 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 is data mart?
Explain in detail about type 1?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Can we create universe with no cache??
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 is difference between webi and infoview?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
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 a bo repository?
Differences between business objects and web intelligence reports?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
what is document design in boxi,have u participate in that
what is xcelsius architecture?
