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 the data types present in bo and what happens if we implement view in the designer and report?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
how to prepare the documentation in business objects and where to get the requirement?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Can we create universe with no cache??
what is the difference b/w the refresh and buffered data?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is top business?
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,
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
how get the grand total in master-detail report?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha