nerdexam
SAP

C_BOWI_40 · Question #5

What is the default behavior when creating a report from two queries from the same universe?

The correct answer is B. Dimension objects are automatically merged. In SAP BusinessObjects Web Intelligence, when two queries originate from the same universe, dimension objects sharing the same name and data type are merged automatically by default.

Working with Data

Question

What is the default behavior when creating a report from two queries from the same universe?

Options

  • AResult produces two table blocks.
  • BDimension objects are automatically merged.
  • CResults are shown on two different report tabs.
  • DDimension objects are not automatically merged.

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    90% (37)
  • C
    5% (2)
  • D
    2% (1)

Why each option

In SAP BusinessObjects Web Intelligence, when two queries originate from the same universe, dimension objects sharing the same name and data type are merged automatically by default.

AResult produces two table blocks.

Two table blocks are not the default result - merged dimensions allow data from both queries to appear together rather than in separate blocks.

BDimension objects are automatically merged.Correct

When multiple queries are built from the same universe, Web Intelligence identifies dimension objects with matching names and compatible data types and merges them automatically - this synchronizes data across blocks without manual configuration. This default merge behavior allows measures from different queries to be displayed in a single table using the shared dimension as the axis. You can disable or modify merges manually afterward if needed.

CResults are shown on two different report tabs.

Queries from the same universe do not default to separate report tabs - that behavior is not triggered by same-universe sourcing.

DDimension objects are not automatically merged.

This is incorrect because automatic merging is exactly what does happen by default when queries share a universe, making this the opposite of the correct behavior.

Concept tested: Automatic dimension merging from same-universe queries

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/7c278072e98941e9a4f2de15f2c4b44b/46d3397d6e041014910eca7d85b63bef.html

Topics

#multiple queries#dimension merging#same universe#default behavior

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice