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?
What Is The Difference Between Oltp And Olap?
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...
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what are the measure objects?
Explain what is the difference between business requirement document and use case document.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain in detail about type 2(scd),
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain the difference between union and group?
How to open a universe with out using the Designer ??
what is document design in boxi,have u participate in that
What is the difference in creating filters in designer and business objects?