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 |
Is it possible to develop reports without Universe access?
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
How to get two dimension objects in a same block which are comming from two different contexts ?
What are the difference between merge,auto merge and extended merge ?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
what is data cubes??
What is the size of data base?
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
explain about Prompt with example?
why we are using derived tables ?how it will help?