1. what is the purpose of creation of universe than other
data sources ?
2. which is the best method in performance tuning techniques ?
- 3 Answers
- 6482 Views
- I also Faced
- E-Mail Answers
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
Explain what three things do you consider to be the most important factors for a manager?
Explain what would you consider as your biggest achievement and why?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between webi and infoview?
What is package in BO
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How many universes can be created in a project?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
When to use local filter and when to use global filter?
How to execute the plsql procedure from the report by clicking with mouse?
Give some information on report bursting?
any difficulitis have you phase while creating bo reports and how did u solve it
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
