Locale dependent numeric format
I have a shared dimension defined as follows:
<Dimension name="My dimension">
<Hierarchy hasAll="true" primaryKey="ID">
<Table name="DIMESION_TABLE" />
<Level name="My level with large numeric values" column="MY_COLUMN" type="Numeric" />
The values in "MY_COLUMN" are large numeric values for example 14678678. The values returned for "My dimension" from an MDX query are formatted as follows 1.4678678E7.
Is there a way to change the formatting of this? I want it to be returned as it is formatted in my database or possible formatted in a Swedish locale where the separator should be ',' instead of '.'
Thanks for any help on this!