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
- 5542 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 about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain what task is 98% of the required work of a business analyst?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain how to execute the plsql procedure from the report by clicking with mouse?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is thumbnail?
When we use aggregate awareness function in designer?
What is the difference between datawarehousing and businessintelligence?
Explain when to use local filter and when to use global filter?
What is the difference between absolute and relative div positioning?
Differences between business objects and web intelligence reports?
explain in detail about type 3?
Explain what is the difference between business requirement document and use case document.
What is the difference between business requirement document and use case document.
