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 combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

1 Answers   IBM,

---

What is the prm file ? can anybody explain me ?

2 Answers  

---

HOW TO INSTALL BOXI

1 Answers  

---

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

---

Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,

---

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,

---

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  

---

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

---

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  

---

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---