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 |
Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
How to create Index to the table in the universe designer and how it improves the Query performence
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode
1.what is context? How u create? With example.
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Can anybody tell me what are the tuning problems?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,