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

Can we link the oracle and excel universess?

1 Answers  

---

How to create universe in business objects enterprise 11.5

1 Answers  

---

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers  

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,

---

Is there any other repository domains rather than universe, security, document?

0 Answers  

---

How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  

---

what is stacked chart , Bar chart, Column chart?

1 Answers   Tech Mahindra,

---

can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,

---

What is the architecture of ur project? can u explain it? PLz

1 Answers   Patni,

---

What are Alerter, Filters, Breaks and Conditions?

2 Answers  

---

What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

---

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,

---