in universe perameter u dont give the option multiple
contexts ,what is the impact in report level
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rekha
Because it will be bit confusing for the users to select
which context to use if they don't have the knowledge of
how BO works
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the profile and package?
Can i use personal database connection to the Webintellegence reports?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
which is the best way to resolve loop context r alias why?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
why we use aggregation in lower level
How to delete the duplicate colums in a sql table ?
What are the steps to taken care to improve the Report performance?
What is the slice and dice?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
how to solve the incompatible objects and how they are formed actually.
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....