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 |
Explain about a task that really tested your analytical abilities?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
what is the source for metrics?
When we are going for Shortcut join and why.
without creating the business view is there possible to create & generate the Crystal reports?
whats the diff between break and section
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
What are the Input and Output Context Operators.