C_BOWI_40 · Question #55
Which type of relationship links sub-queries by default?
The correct answer is B. AND. In SAP BusinessObjects Web Intelligence, multiple sub-queries added in the Query panel are linked by an AND relationship by default.
Question
Which type of relationship links sub-queries by default?
Options
- AOR
- BAND
- CNOR
- DNAND
How the community answered
(62 responses)- A2% (1)
- B90% (56)
- C5% (3)
- D3% (2)
Why each option
In SAP BusinessObjects Web Intelligence, multiple sub-queries added in the Query panel are linked by an AND relationship by default.
OR is a less restrictive operator that returns rows satisfying any one condition; it is not the default and must be explicitly set by the user.
Web Intelligence mirrors standard SQL behavior by combining multiple sub-query predicates with AND by default, requiring all sub-query conditions to be satisfied simultaneously for a row to qualify. This default ensures the most restrictive and precise filtering behavior when sub-queries are stacked. Users can manually change the operator to OR if broader matching is needed.
NOR is not a valid or supported sub-query linking operator within the Web Intelligence Query panel.
NAND is not a valid or supported sub-query linking operator within the Web Intelligence Query panel.
Concept tested: Default AND relationship linking sub-queries in Web Intelligence
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/9c1a9dee-8b0c-4e3f-aab3-e4cc6e877e74/46d7a1836e041014910ded01120ca65c.html
Topics
Community Discussion
No community discussion yet for this question.