Answer / poonam tekchandani

To increase the performance in universe:

-as possile as use less number of joins
- avoid use of user objects
- use aggregate awareness

To increase the performance in reports:
- avoid use of user objects

Answer / ashish

1. Increase array fetch size.
2. Use Bit map indexing on Fact columns.
3. Remove unwanted objects and classes from your universe.
4. Remove unwanted variables, filters and charts from report
5. Always ensure your fact table execute before your
dimensional table in the FROM clause (Query optimization)
ex. Select F1.A
D1.B
FROM
Fact F1,
Dim D1
6. Use of Derived Tables so that complex calculation can be
performed at universe level.
7. Aggregate table
8. Remove unwanted alias and context.
9. Always ensure in join condition you have fact table
appearing at LHS. (F1.A=D1.B)
10. For prompts related columns, have indexing done at DB
level
11. Also at universe level you can change row count for
table rows for SQL execution as per requirements.

Answer / anil kumar ganga

To increase the performance in designer
1. Use as much conditions as possible
2. Use array fetch parameter
3. Limit the number of rows in Universe parameters as per
ur need
4. Resolve loops completely etc.,
To increase performance in reports:
1. Avoid usage of more variables
2. Use indexes on columns

Still more points are there, i didn't remember. Any body
can continue this post

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

---

what are the complex reports you have created. Tell me with example?

7 Answers   Insurance, TCS,

---

How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

Can anybody tell me what are the tuning problems?

0 Answers  

---

Differences between business objects and web intelligence reports?

0 Answers  

---

What are the steps to be taken to schedule the report?

0 Answers  

---

When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

2 Answers   Rolta, TCS,

---

what is universe testing(not mention check integrity)

1 Answers  

---

i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers   TCS,

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  

---

disadvantages of boxi

2 Answers   Accenture,

---