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 / babu
Universe creation in other data source is to get more info
or which not possible in the same universe like(more than 2
fact tables ) in the way we can go for more than one data
source.
Performence tuning :
Universe level
1.universe should be Indexed on key columns
2.Increase Array fetch size.
3.Make short cut joins
4.Delete unnessory joins.
5.Use less no of Aliases
6.Use less Outer joins
Query Level:
1.Disable LoV for measure objects
2.Create filters(condition objects) at universe level
Report level
1.Create less no of variables
2.create comoplex logic in D/B level.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is object stores?
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?
what will be the contents for a functional requirements specifications
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference in creating filters in designer and business objects?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
what is xcelsius architecture?
When we use aggregate awareness function in designer?
How to open a universe with out using the Designer ??
Explain about a task that really tested your analytical abilities?
Explain in detail about type 2(scd),
What are the steps to be taken to schedule the report?
how to create metric universe ?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?