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

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

What is ment by For each For all function. In which case we use the option in BO?

2 Answers   IBM, TCS,

---

WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers   PCS,

---

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

---

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,

---

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---

WHAT IS SAP BO AND BO?

1 Answers  

---

Tell me about a complicated object you have created?

1 Answers  

---

10.why we are going to data warehouse?

4 Answers   Satyam, TCS,

---

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---