You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis

You are developing a SQL Server Analysis Services (SSAS) cube.
The cube contains several dimensions, a local measure group, and a linked measure group.
Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable
What-If Analysis.
What should you do before the partition can be write-enabled?

You are developing a SQL Server Analysis Services (SSAS) cube.
The cube contains several dimensions, a local measure group, and a linked measure group.
Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable
What-If Analysis.
What should you do before the partition can be write-enabled?

A.
Ensure that the measure group measures only use semiadditive aggregation functions.

B.
Implement the linked measure group as a local measure group.

C.
Implement the cube as a local cube.

D.
Ensure that the measure group measures only use nonadditive aggregation functions



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marchello

Marchello

B.
Implement the linked measure group as a local measure group.