The Format String setting enables specifying how BI client applications render a measure selection in Schema Editor Tree View. You can type a unique string in the text box or select a predefined format string from the Format String list.
A format string "$#,##0.00" or "$#,##0" does not use the literal dollar-sign ($) character, it is a placeholder for the operating system's locale-specific currency character. This means the visual currency symbol changes if the operating system locale changes. For example, if the locale is “United States” the string has the $ value however, if the locale is “France” the string has the € value.
To lock the currency symbol to a specific currency character regardless of locale, prefix the string with a backslash: "\$#,##0.00" or \$#,##0".
- https://msdn.microsoft.com/en-us/library/ms146084.aspx
- Spofford, George, Format String Codes, in MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Second Edition, (Indianapolis: Wiley Publishing, Inc., 2006), 675