You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008 Analysis Services (SSAS) solution.
Following is the cube structure. (Click the Exhibit button.)
According to the business requirements, the Amount measure and the Ownership measure are created.
Decimal values that represent percentage of ownership are contained in the Ownership column.
Besides, for a single DimAccount member, there is 100% sum of all the values in the Ownership column.
Now you get an order from your company CIO, according to his requirement, when you calculate the Amount measure against the DimCustomer dimension, you have to make sure that you have the weighted value calculated on the base of the Ownership measure. What action would you perform to achieve this goal?
A.
The FormatString property of the Amount measure should be set to [DimCustomer].[Amount]*[Ownership]
B.
The MeasureExpression property of the Amount measure should be set to [Amount]*[Ownership]
C.
The FormatString property of the Amount measure should be set to [Amount]*[Ownership]
D.
The MeasureExpression property of the Amount measure should be set to [DimCustomer].[Amount]*[Ownership].