Interested to Buy Any Domain ? << Click Here >> for more details...
what is performance tunning in BO in report level& designer
level?
- 1 Answers
- 6375 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
Is there any other repository domains rather than universe, security, document?
U r project in which stage in implementation?
Explain about a task that really tested your analytical abilities?
Explain which versions are used in the bo dashboard work?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
When we use aggregate awareness function in designer?
Explain when we use aggregate awareness function in designer?
What is the functional & architectural differences between business objects and web intelligence reports?
What is the difference between absolute and relative div positioning?
How to execute the plsql procedure from the report by clicking with mouse?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is object stores?
what will be the contents for a functional requirements specifications
What are all difference between business objects 6.5 and xi r2?
