C_BOWI_40 · Question #151
Which two statements are true about the AND operator? (Choose two.)
The correct answer is B. Used when all conditions are met by two filters C. Used when all conditions are met by more than two filters. The AND operator in Web Intelligence report filters requires every combined condition to be true simultaneously, and this behavior holds whether two or more filter conditions are chained together.
Question
Which two statements are true about the AND operator? (Choose two.)
Options
- AUsed when any condition is met by two filters
- BUsed when all conditions are met by two filters
- CUsed when all conditions are met by more than two filters
- DUsed when only one condition is met by any of the filters
How the community answered
(58 responses)- A3% (2)
- B88% (51)
- D9% (5)
Why each option
The AND operator in Web Intelligence report filters requires every combined condition to be true simultaneously, and this behavior holds whether two or more filter conditions are chained together.
Returning data when any condition is met describes the OR operator, not AND; AND requires all conditions to be true, not just one of them.
The AND operator returns data only when all conditions across two filters are simultaneously satisfied, meaning a row must pass every filter rather than just one.
AND logic extends beyond two filters - when three or more filter conditions are combined with AND, a record is included only if it meets every single one of those conditions at the same time.
Returning data when only one condition is met by any filter also describes OR behavior; AND will only return a row if it satisfies all conditions, not a single arbitrary one.
Concept tested: Web Intelligence report filter AND operator logic
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1ca10a0e77fe4b6a8e00f3b60fdaf9fa/46a3453b6e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.