dbTalk Databases Forums  

AS2005: currency (language) setting problem with calculated member

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2005: currency (language) setting problem with calculated member in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nico Verheire
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.