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 / 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 |
Post New Answer View All Answers
Explain in detail about type 1?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what would you consider as your biggest achievement and why?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What Is Snow Flake Schema?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain in detail about type 2(scd),
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is a fantrap in business objects?
What task is 98% of the required work of a business analyst?
In banking domain how many Fact tables,Dimension table are present?
What is difference between webi and infoview?