PrepAway - Latest Free Exam Questions & Answers

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

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Set the Type property of the partition’s measure group to Forecast.

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

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

D.
Set the StorageMode property of the linked measure group to Rolap.

2 Comments on “You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable


Leave a Reply