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

Answers were Sorted based on User's Feedback



1. what is the purpose of creation of universe than other data sources ? 2. which is the best meth..

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.

Is This Answer Correct ?    1 Yes 0 No

1. what is the purpose of creation of universe than other data sources ? 2. which is the best meth..

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

Is This Answer Correct ?    2 Yes 2 No

1. what is the purpose of creation of universe than other data sources ? 2. which is the best meth..

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 This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

How we can add a comment in universe...?

1 Answers  


how to do Ad-hoc reporting ?

6 Answers   IBM,


CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,


2.What is loop? How resolve the loop?explain it?

11 Answers   TCS, UHG,


Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,






Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  


What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  


my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  


What are alertors in Business Objects?

5 Answers  


what r the types of joins universe supports

3 Answers  


what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,


Categories