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
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain what is the difference between business requirement document and use case document.
Explain the difference between detect alias and detect context?
What is object stores?
Give some information on report bursting?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is the dense rank?
what are the day to day activities of BO administrator ?
How to generate the report from excel sheet?
In banking domain how many Fact tables,Dimension table are present?
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?
Explain the difference between union and group?
Explain when to use local filter and when to use global filter?