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 |