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

How to change the order of prompts in universe?

3 Answers  

---

tell me about aggregate awareness in detail?

2 Answers   Cap Gemini,

---

How to create universe in business objects enterprise 11.5

1 Answers  

---

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....

1 Answers  

---

what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,

---

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,

---

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers  

---

what is universe

4 Answers   TCS,

---

How we drill up week to month?

0 Answers  

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---