AS2005: currency (language) setting problem with calculated member -
04-20-2006
, 09:30 AM
I'm experiencing something strange with formatted values; consider the
following query:
select
{[Measures].[Internet Sales Amount],
[Measures].[Internet Average Sales Amount]}
on columns
from [Adventure Works]
result = $29,358,677.22 1.061,45 €
Notice the first value is in dollars, the second in euros.
[Internet Sales Amount] is a "normal" measure, while [Internet Average Sales
Amount] is a calculated member.
The language of the cube is 1033 = en-us = dollars.
There are no languages specifically defined on other objects (like
dimensions).
This is the sample AdventureWorks cube.
My regional settings are Belgian (dutch) = euros.
However, when I change my regional settings (to, say, Hungarian), I keep
getting the same results (in euros !).
So:
1. why is the currency-formatting for calc member different from formatting
for normal measures.
2. and how is it deciding to show the calc member in Euros, while there
seems not te be an obvious reason to choose euros. What the logic behind this?
thanks in advance,
Nico |