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
- 5563 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
What is the report extension in webi and deski
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain about a task that really tested your analytical abilities?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
How to create an popup in the WEBI report if the report is showing partial result?
Explain what are the measure objects?
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
What is the sheduling the report? What is the need of sheduling the report?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
Teradata 
