You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services cube you are developing contains multiple dimensions. The cube also
contains linked measure groups and local measure groups. All measure group partitions use
Multidimensional OLAP (MOLAP).
You need to write-enable a partition containing a linked measure group to enable business users
to explore scenarios by changing cell values and analyzing the effects of the changes on cube
data.
What should you do first?
A.
You should change the storage mode of the partition to Relational OLAP (ROLAP).
B.
Ensure that no other cubes link to the same measure group.
C.
Remove the Min and Max aggregation functions from the measure group.
D.
Create a local measure group by importing the linked measure group.
Explanation:
http://technet.microsoft.com/en-us/library/ms174750.aspx