C_BOWI_40 · Question #107
Which three methods can you use to combine queries using the Web Intelligence Rich Client?
The correct answer is A. UNION B. MINUS D. INTERSECT. Web Intelligence Rich Client supports UNION, MINUS, and INTERSECT for combining queries, but does not include UNION ALL as a supported operation.
Question
Which three methods can you use to combine queries using the Web Intelligence Rich Client?
Options
- AUNION
- BMINUS
- CUNION ALL
- DINTERSECT
How the community answered
(30 responses)- A90% (27)
- C10% (3)
Why each option
Web Intelligence Rich Client supports UNION, MINUS, and INTERSECT for combining queries, but does not include UNION ALL as a supported operation.
UNION combines the result sets of two queries and eliminates duplicate rows, and is a fully supported query combination method in Web Intelligence Rich Client.
MINUS returns rows present in the first query but absent from the second, and is a supported query combination method in Web Intelligence Rich Client.
UNION ALL, which merges result sets while retaining all duplicate rows, is not available as a query combining operation in Web Intelligence Rich Client - only the deduplicating UNION is supported.
INTERSECT returns only rows that appear in both query result sets, and is a supported query combination method in Web Intelligence Rich Client.
Concept tested: Supported query combining operations in Web Intelligence Rich Client
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/09382e85-b2b0-4978-9f1f-5b3f86cfe18d/46e5cf2c6e041014910eff47135e4828.html
Topics
Community Discussion
No community discussion yet for this question.