Exchange rate -
04-08-2004
, 07:39 AM
Can any one guide me in implementing Exchange rate
I have sales cube with measures which need to multiply with currrency
conversion factor from Exchangerate cube
My sales cube has countrykey,Timekey
Exchange rate cube has CurrencyKey,Timekey,Countrykey,Convfactor
Each measure in sales cube should multiply with the Convfactor
I am planning to have currency dimension with one level Currency which
will have values USD,EUR,GBP
If user selects USD should multiply with USD convfactor
Can any one tell me best approach |