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

Instead of cms which server you have to use?

2 Answers   CTS,

---

how to coneect to a server in a business objects

1 Answers  

---

6.what is conformed dimension? R u used?

8 Answers   TCS,

---

can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,

---

Can we Save (save as) WEBI Doc as DESKI?

2 Answers   HCL,

---

what is casual dimension?

1 Answers   CA,

---

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

---

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,

---

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

---

how to schedule a report for even number dates?

2 Answers   HCL,

---

What is the strategies ? what is the need of the strategies?

2 Answers   IBM,

---

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

0 Answers   Banking, Genpact, TCS,

---