in universe perameter u dont give the option multiple
contexts ,what is the impact in report level
Answer Posted / nathan
By having multiple contexts you can utilize the 'multipass'
sql feature. Multipass: Breaking one large SQL into
multiple SQLs.If you are using the star schema with two or
more fact tables,and you enable this feature, BO will
automatically generate two or more SQLs (i.e. one SQL for
each fact table object used in the report). Then the
results will be synchronised in the report. For more on
multipass concept please refer to Ralph Kimball's Lifecycle
toolkit (not modelling)book.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Can more than 1 metric be applied on an analytic in business objects?
Can you please send me the migration related issues .
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain the data types present in bo and what happens if we implement view in the designer and report?
can anybody tell me about complicated object you have created
Differences between business objects and web intelligence reports?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain about a time when you discovered a more efficient way to do a work task?
Which versions are used in the bo dashboard work?
What are all difference between business objects 6.5 and xi r2?