You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for theSalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?
A.
Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00.
B.
Use the FormatString measure property to format SalesAmount as Currency.
C.
Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.
D.
Add a named query in the data source view that casts the data source column to two digits of precision.
Bind the SalesAmount measure to the new query.
E.
Add a named calculation in the data source view that casts the data source column to two digits of
precision. Bind the SalesAmount measure to the new column.