70-448 · Question #274
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…
The correct answer is A. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership]. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASet the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
- BSet the FormatString property of the Amount measure to [Amount]*[Ownership].
- CSet the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
- DSet the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
How the community answered
(12 responses)- A75% (9)
- C8% (1)
- D17% (2)
Community Discussion
No community discussion yet for this question.