C_BOWI_40 · Question #65
Which two operators are available when using wildcards in a query filter?
The correct answer is B. Matches Pattern D. Different from Pattern. In SAP BusinessObjects Web Intelligence, only two operators support wildcard characters in query filters: 'Matches Pattern' and 'Different from Pattern'.
Question
Which two operators are available when using wildcards in a query filter?
Options
- ALIKE
- BMatches Pattern
- CNot equals Pattern
- DDifferent from Pattern
How the community answered
(38 responses)- A3% (1)
- B87% (33)
- C11% (4)
Why each option
In SAP BusinessObjects Web Intelligence, only two operators support wildcard characters in query filters: 'Matches Pattern' and 'Different from Pattern'.
LIKE is a SQL keyword used in database queries, not a named operator in the Web Intelligence query filter interface.
Matches Pattern is one of the two wildcard-compatible operators in Web Intelligence query filters, allowing the use of wildcard characters such as '%' (any string) and '_' (single character) to match values against a pattern.
'Not equals Pattern' is not a valid operator name in Web Intelligence; the correct negating wildcard operator is called 'Different from Pattern'.
Different from Pattern is the negating counterpart to Matches Pattern, also supporting wildcard characters, and returns results where the field value does not match the specified pattern.
Concept tested: Web Intelligence query filter wildcard operators
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/5a1c3e27a7d14c0a8e0f6a5b6c3d2e1f/query-filters.html
Topics
Community Discussion
No community discussion yet for this question.