How to display values in thousands in MDX icCube

Question

How to display the value for a measure in thousands. I would assume to do it as follows:

FORMAT_STRING="#,,"

But the data returns: 10000000.001 while I would expect: 10,000

Answer 1

The format follows the format as described in the documentation of FORMAT_STRING :

 FORMAT_STRING="#,###" or  "#,##0" or "#,##0.0"

when defining the format you should not use your locale, but use the ',' separator for the thousands and the '.' for the decimal.

Separators will be automatically converted to your locale language in the output.

hope it helps