C_BOWI_40 · Question #37
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?
The correct answer is D. Dimension - Dimension. In Web Intelligence, Multi Queries allow merging only objects of the same type, and only Dimension-to-Dimension merging is supported.
Question
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?
Options
- ADimension - Detail
- BMeasure - Measure
- CDimension -Measure
- DDimension - Dimension
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- C3% (1)
- D88% (30)
Why each option
In Web Intelligence, Multi Queries allow merging only objects of the same type, and only Dimension-to-Dimension merging is supported.
Detail objects are dependent on a specific dimension and cannot be independently merged with a Dimension object across queries.
Measure objects represent aggregated numeric values and cannot be used as merge keys because they do not serve as common qualifiers between data providers.
Mixing a Dimension and a Measure for a merge is not supported because they represent fundamentally different data roles - one qualifies, the other quantifies.
When merging queries in a Web Intelligence document, the merge operation requires that both objects share the same data type and object classification. Only Dimension objects can be merged with other Dimension objects because they represent the same kind of structural data used to synchronize result sets across queries. Merging incompatible object types such as measures or details would produce undefined or meaningless aggregated results.
Concept tested: Web Intelligence Multi Query dimension merging rules
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8d49b4f7e3474d7bb5945d636e38c6c1/46d2fbb16e041014910eba7ea8d1f3e5.html
Topics
Community Discussion
No community discussion yet for this question.