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

Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  

---

How to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

---

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

0 Answers  

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

How to make alternative rows red and green in WebI Report?

3 Answers   Accenture, Mphasis,

---

What is the server based ranking? and its usage?

2 Answers  

---

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

1 Answers   HCL,

---

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

---

What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,

---

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

---

how to schedule a report for even number dates?

2 Answers   HCL,

---

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

2 Answers   TCS,

---