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

What is domain? How many are there in a basic setup? What are they?

1 Answers  

---

How do you find what type of trap is there by seeing the report?

4 Answers   TCS,

---

What is recurring sheduling and batch scheduling?

2 Answers   TCS,

---

when and where we use @varialble function

1 Answers  

---

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

---

what is merged imension in 6.5 and webi

1 Answers  

---

How to execute the MACRO through Infoview?

1 Answers  

---

How we can resolve the loops by using the Aggrigate Awareness?

1 Answers   Hexaware,

---

Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  

---

What is drill across ? can anybody explain me in detail?

1 Answers  

---

How to delete the duplicate colums in a sql table ?

3 Answers   IBM,

---

In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,

---