nerdexam
Microsoft

70-466 · Question #103

You need to configure the format of the Sales Total measure. Which value should you use for the FormatString property?

The correct answer is C. Currency. Using 'Currency' as the FormatString value in SSAS applies the system's standard currency format to a measure without requiring a custom format string.

Build an analysis services database

Question

You need to configure the format of the Sales Total measure. Which value should you use for the FormatString property?

Options

  • A$#,##0.00;($#,##0.00)
  • B#,##0.00;#,##0.00
  • CCurrency
  • DA custom-entered value

How the community answered

(26 responses)
  • B
    4% (1)
  • C
    96% (25)

Why each option

Using 'Currency' as the FormatString value in SSAS applies the system's standard currency format to a measure without requiring a custom format string.

A$#,##0.00;($#,##0.00)

$#,##0.00;($#,##0.00) is a custom format string that hard-codes the US dollar symbol and uses parentheses for negatives, which does not adapt to different regional settings and is unnecessary when the predefined 'Currency' constant is available.

B#,##0.00;#,##0.00

#,##0.00;#,##0.00 is a plain numeric format that includes no currency symbol and duplicates the positive format for negatives, so it does not correctly represent a currency measure.

CCurrencyCorrect

The predefined 'Currency' FormatString value in Analysis Services instructs the client to format the measure using the system's regional currency settings, including the appropriate currency symbol, thousands separator, and decimal places. This approach is preferred over hard-coded custom strings because it adapts to the locale of the client consuming the cube. It is a named format constant recognized by the OLE DB for OLAP specification and supported by Analysis Services natively.

DA custom-entered value

A custom-entered value requires manual definition and maintenance, is more error-prone, and is redundant when the standard 'Currency' named format already provides the required behavior.

Concept tested: SSAS measure FormatString currency configuration

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/mdx-cell-properties-format-string-contents

Topics

#FormatString#measure formatting#currency format#SSAS properties

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice