Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in BO in report level& designer
level?
- 1 Answers
- 6194 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 how to execute the plsql procedure from the report by clicking with mouse?
What are the steps to be taken to schedule the report?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
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 difference b/w the refresh and buffered data?
what is xcelsius architecture?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What task is 98% of the required work of a business analyst?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Difference between b.o 5.1 and 6.1b?
in sap bi we have wad, then why we go for sap bo
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
can anybody tell me about complicated object you have created
What are the steps to do to use alerts in bo?
