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
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 |
What is mean by stored procedure ? and how we can generate stored procedure universe?
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
What is mean by tuning the report?
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
5.what is LOV? where it is store?
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
where are objects are stored ?
How many built-in objects are created in Business Objects repository?
How to Implement the the Built-in Strategy Script in BO Designer?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?