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
how to prepare the documentation in business objects and where to get the requirement?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is the difference between user and versatile user?
How to open a universe with out using the Designer ??
What is package in BO
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What would you consider as your biggest achievement and why?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is the difference between datawarehousing and businessintelligence?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Did you face any problems while creating reports? Name? Solutions?
U r project in which stage in implementation?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Difference between zabo and webi?