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

How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,

---

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

---

what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,

---

What is a loop? How can we overcome?

5 Answers  

---

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

---

how many user were there

1 Answers  

---

Explain how we drill up week to month?

0 Answers  

---

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,

---

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

0 Answers   IBM,

---

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

---