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


Please Help Members By Posting Answers For Below Questions

is it possible to export the webi reports to crystal reports?with out using businessview?

2018


How to open a universe with out using the Designer ??

6999


What is aggregate table and aggregate fact table ... Any examples of both?

790


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

788


Difference between b.o 5.1 and 6.1b?

869


What is difference between webi and infoview?

864


How can you first report in Business Objects by using broadcast agent?

2802


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,

1789


What are the data types present in bo? What happens if we implement view in the designer and report?

787


Difference between zabo and webi?

834


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...

1917


Can more than 1 metric be applied on an analytic in business objects?

1832


How we drill up week to month?

803


What is the difference between business requirement document and use case document.

770


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6389