nerdexam
SAP

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.

Restricting Data with Query Filters

Question

Which type of relationship links sub-queries by default?

Options

  • AOR
  • BAND
  • CNOR
  • DNAND

How the community answered

(62 responses)
  • A
    2% (1)
  • B
    90% (56)
  • C
    5% (3)
  • D
    3% (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.

AOR

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.

BANDCorrect

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.

CNOR

NOR is not a valid or supported sub-query linking operator within the Web Intelligence Query panel.

DNAND

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

#sub-queries#AND relationship#query linking#default behavior

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice