C_BOWI_40 · Question #36
Where are contexts created?
The correct answer is B. In a universe. Contexts are a universe-level construct created in the universe design tool to resolve loops and ambiguous join paths in the underlying database schema.
Question
Where are contexts created?
Options
- AIn a report
- BIn a universe
- CIn a derived table
- DAt the database level
How the community answered
(42 responses)- A7% (3)
- B88% (37)
- C2% (1)
- D2% (1)
Why each option
Contexts are a universe-level construct created in the universe design tool to resolve loops and ambiguous join paths in the underlying database schema.
Reports consume data already returned by the universe and query engine; they have no mechanism to define or manage join contexts.
Contexts are defined in SAP BusinessObjects Universe Designer or the Information Design Tool by grouping joins that represent a valid query path, allowing the engine to resolve loops in schemas with multiple fact tables. This is a semantic-layer operation that prevents the query generator from producing ambiguous or incorrect SQL when multiple join paths exist.
Derived tables are virtual SQL constructs embedded within the universe to encapsulate reusable sub-queries, but they are not where join contexts are created or managed.
Contexts are a semantic-layer concept that exists only within the BusinessObjects universe metadata; the underlying database has no awareness of or participation in context definitions.
Concept tested: Universe context creation to resolve schema loops
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM
Topics
Community Discussion
No community discussion yet for this question.