You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.
The cube structure is listed below:
For one TestAccount member, the total value in the Ownership column is 100%.
The Ownership column includes decimal values which stand for percentage of ownership.
The measures listed below are developed:Ownershiper Number
You should make sure that the weighted value is computed according to the Ownership measure when you are computing against the TestCustomer dimension.
Which is the correct answer?
A.
You should configure the MeasureExpression attribute of the Number method to [Number]* Ownershiper].
B.
You should configure the FormatString attribute of the Number method to [DimCustomer].
[Number]*[ Ownershiper].
C.
You should configure the MeasureExpression attribute of the Number method to [TestCustomer].[ Number].
D.
You should configure the FormatString attribute of the Number method to [TestCustomer].[ Number].