You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership.
The sum of all the values in the Ownership column for a single DimAccount member is
100%. You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer
dimension, the weighted value is calculated based on the Ownership measure.
What should you do?
A.
Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
B.
Set the FormatString property of the Amount measure to [Amount]*[Ownership].
C.
Set the MeasureExpression property of the Amount measure to
[DimCustomer].[Amount]*[Ownership].
D.
Set the FormatString property of the Amount measure to
[DimCustomer].[Amount]*[Ownership].