You create a materialized reference dimension between a dimension named Regions and a measure group named Orders. You use a table named Customers as a bridge in shown in the exhibit. (Click the Exhibit button.) You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed. What should you reprocess?

Question

Accepted Answer

C. The Customers dimension A materialized reference dimension stores a snapshot of the intermediate dimension's key values to speed up query resolution. When the relationship data in the Customers bridge table changes, reprocessing the Customers dimension refreshes the materialized linkage between the Regions dimension and the Orders measure group. This targeted reprocess satisfies the requirement to reflect relationship changes without reprocessing the entire cube.

Answer

A. The Sales partition The Sales partition is a measure group partition and does not store or manage the reference dimension relationship; reprocessing it would not update the materialized linkage.

Answer

B. The Regions dimension Regions is the referenced outer dimension, not the intermediate bridge; reprocessing it does not update the materialized data stored through the Customers bridge.

Answer

D. The Orders partition The Orders partition holds fact data for the measure group and does not contain the materialized reference dimension relationship data that needs updating.

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders. You use a table named Customers as a bridge in shown in the exhibit. (Click the…

Question

Options

How the community answered

Why each option

Topics

Community Discussion