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 |
Is it possible to generate reports without having knowledge of the Universe structure?
What is detailed Object
How to create an popup in the WEBI report if the report is showing partial result?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can i merge two dataproviders if they do not have common column?
what is optional prompt in boxi r2
how we send repotrts/documents to end user
how do u resolve contexts ?
How to create Index to the table in the universe designer and how it improves the Query performence
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?