dbTalk Databases Forums  

currency conversion

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


Discuss currency conversion in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lutz Morrien
 
Posts: n/a

Default currency conversion - 07-18-2003 , 09:36 AM






Hi all,
our customer would like to convert a measure from ? to
CHF (swiss currency). This is to happen while the cube is
aggregated (or before). My first idea was to create a
calculated measure based on the base currency measure as
in

[Measures].[swiss curr]=[Measures].[EUR curr]*1.4
/*(conversion factor)*/

But the conversion factor is changing, not fixed.

Has anyone done this before?

Thanks for a hint.
Lutz

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.