Answer / babu

Universe creation in other data source is to get more info
or which not possible in the same universe like(more than 2
fact tables ) in the way we can go for more than one data
source.

Performence tuning :
Universe level
1.universe should be Indexed on key columns
2.Increase Array fetch size.
3.Make short cut joins
4.Delete unnessory joins.
5.Use less no of Aliases
6.Use less Outer joins
Query Level:
1.Disable LoV for measure objects
2.Create filters(condition objects) at universe level
Report level
1.Create less no of variables
2.create comoplex logic in D/B level.

Answer / ranu

Universe is a semantic layer in BO. it provides a user
Business friendly view of database fields. So user can
create their own report based on the object from universe
easily.

For performance tuning:
There are following areas we can tune the perfomance
1.Database level:
*by tuning SQL
1.Making less joins
2.Using less functions
3.Using Indexes
4.using aggregation
5.Not using Like function
2. Using high performace Server and OS on which BO would be
installed
3.Universe Level
By setting appropriate Parameters
By increasing Array fecth Size
By setting appropriate Case Size

Answer / gowthami

would like add few points:
At report level,
1. Remove unused objects from the result objects panel
2. Remove unused variables from the report
3. Prefer prompts(query level filter) instead of using report level filter or input control

what are they different types of report in BO?

6 Answers  

---

can anybody tell me how many classes where there and objects in each class

3 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,

---

What is user docs and how to use this option in bo?

1 Answers   Bank of Baroda,

---

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  

---

what is meant by slowly changing dimensions?

3 Answers   TCS,

---

Can i use personal database connection to the Webintellegence reports?

1 Answers   Infotech,

---

What is the use of Surrogate key in BO?

8 Answers   IBM,

---

what is dashboards? what is metrics?

7 Answers   TCS,

---

Explain about a time when you discovered a more efficient way to do a work task?

0 Answers  

---

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,

---