1. what is the purpose of creation of universe than other
data sources ?
2. which is the best method in performance tuning techniques ?
Answer Posted / 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 |
Post New Answer View All Answers
What are the data types present in bo? What happens if we implement view in the designer and report?
how to prepare the documentation in business objects and where to get the requirement?
Is there any other repository domains rather than universe, security, document?
Can more than 1 metric be applied on an analytic in business objects?
any difficulitis have you phase while creating bo reports and how did u solve it
8. How much supervision have you typically received in your previous job?
Explain about a tricky situation for which you found a very simple solution?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How were the reports scheduled and how to resolve unexecuted documents?
Difference between b.o 5.1 and 6.1b?
What is the difference between user and versatile user?
Can we create universe with no cache??
What Is The Difference Between Oltp And Olap?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
what is the difference b/w the refresh and buffered data?