nerdexam
SAP

C_BOWI_40 · Question #121

You create a document with data from multiple data providers. Which two tasks can you perform to include all data from all providers in the same report block?

The correct answer is A. Synchronize the data providers. B. Manually merge all dimensions. In Web Intelligence, when a document contains multiple data providers, synchronizing the providers and manually merging dimensions enables all data from all sources to appear together in a single report block.

Working with Data

Question

You create a document with data from multiple data providers. Which two tasks can you perform to include all data from all providers in the same report block?

Options

  • ASynchronize the data providers.
  • BManually merge all dimensions.
  • CSynchronize the data providers SQL.
  • DManually merge the parent dimensions.

How the community answered

(16 responses)
  • A
    75% (12)
  • C
    19% (3)
  • D
    6% (1)

Why each option

In Web Intelligence, when a document contains multiple data providers, synchronizing the providers and manually merging dimensions enables all data from all sources to appear together in a single report block.

ASynchronize the data providers.Correct

Synchronizing data providers links the separate data sources so that Web Intelligence can reconcile their data within the same report block, resolving the multi-provider context conflict.

BManually merge all dimensions.Correct

Manually merging all dimensions creates a common dimension key that bridges the data from different providers, which is required for Web Intelligence to display rows from all providers in a unified block.

CSynchronize the data providers SQL.

'Synchronize the data providers SQL' is not a valid Web Intelligence feature or menu option; SQL-level synchronization is not exposed as a user action in WebI.

DManually merge the parent dimensions.

Merging only parent dimensions is insufficient because unmerged child dimensions will still prevent data from different providers from being combined in the same report block.

Concept tested: Merging dimensions across multiple data providers

Topics

#data providers#synchronize#merge dimensions#multiple queries

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice