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

Use a virtual cube to combine both your exchange rate cube and data cube.

Then you can use calculated cell for each of your currency to create a
calculation that multiply your raw data by the conversion factor at the leaf
of time (Since I asusme your exchange rates vary over time).

I have a question though, why do you have a CountryKey in your Exchange rate
fact table in addition to the CurrencyKey?
Do you rates vary by country? Ie: USD/EURO is different whether you are in
the US or in France?
Usually, exhange rate cube have Time key, currency key, scenario key
(optional, but usefule for Budget vs Actual rates), Rates measures...

Thierry [MS]

Thanks for your response but can you have any sample which
demonstrates creating calculated cells and what condition has to be
applied for calculated cells
will help me


"Thierry [MS]" <tdhers (AT) microsoft (DOT) com> wrote