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

can anybody tell me about issues faced while creating reports

1 Answers   Accenture, Tech Mahindra,

---

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers  

---

4.what is repository? types

8 Answers   TCS,

---

Is it possible to develop reports without Universe access?

7 Answers   IBM,

---

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

4 Answers  

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,

---

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers   Polaris,

---

How many universes will run maximum in single project

1 Answers   HP,

---

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

---

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

---

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---