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 |
How can you access your repository with different user profiles?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
how can u find the granularity in fact table
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
What is the difference between the prompt and cascading prompt
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
is there any limit for rows and columns in cross tab
what is report tracing in bo
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
can we create aliases for every table beforehand? if yes whar are the disadvantages?
how to do Ad-hoc reporting ?