Suppose we had a scenerio like in an universe there are
nearly 250 objects but only 50 objects data is updated
frequently so is there any way to overcome it.(Birla Soft,)
Answers were Sorted based on User's Feedback
Answer / alka
I think this question requires more clarifiaction. Because
as far my understanding goes, Universe is just a symantic
layer between report and database. It is holding schema
details and not data. If objects are unwanted then they can
be hidden. The extra 200 objects will just hold the space
in BO repository like joins,table names,etc. Any comments
on this welcome. CHEERS,ALKA
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / vidhya
Create a view for only those 50 objects and load into
universe,connect this view with some table.
Reason: When you update the base table the view will be
automatically updated for those 50 objects.
Advantage: Performance will be good as the refreshment of
universe is minimized.
Kindly let me know if i am wrong with correct reply.
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / av
there is always a query behind a view which gets executed
while a view is queried. so creating a view doesn't help in
performance enhancing. best way is to create a table with
50 objects.
| Is This Answer Correct ? | 2 Yes | 3 No |
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest
Explain the difference between compatible and incompatible objects?
Can anybody tell me the difference b/w canned and adhoc reporting?.
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
what is Scope of Analysis
Can i merge two dataproviders if they do not have common column?
What are alertors in Business Objects?
What is the user Object ? What is the need of it?
how do u migrate BO 6.x to XI ?
52 Answers Cognizant, HCL, IBM, Wipro,
What Is The Difference Between Oltp And Olap?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
Explain about derived tables?