PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the TransactionCost measure sto…

You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add a named query in the data source view that casts the data source column to two digits of precision.
Bind the TransactionCost measure to the new query.

B.
Add a named calculation in the data source view that casts the data source column to two digits of
precision. Bind the TransactionCost measure to the new column.

C.
Use the FormatString measure property to format TransactionCost as #,##0.00;-#,##0.00.

D.
Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.

E.
Use the FormatString measure property to format TransactionCost as Currency.

One Comment on “You need to ensure that the TransactionCost measure sto…

  1. Marchello says:

    B.
    Add a named calculation in the data source view that casts the data source column to two digits of
    precision. Bind the TransactionCost measure to the new column.




    1



    0

Leave a Reply