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 there any other repository domains rather than universe, security, document?
What are universe parameters?
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
in xir2 how to send reports to end user
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
How to create Index to the table in the universe designer and how it improves the Query performence
how to link 3 fact tables
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
Explain the difference between detect alias and detect context?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
whats the Diffrerence between business objects and cognos?