I have currency exchange rates stored in a SQL Server table. I want
to specify these currency rates in a MDX to multiply currency amounts
with these exchanges rates at runtime. Is it possible for accessing a
SQL table from MDX.

Alternatively I am thinking of loading these exchanges rates into a
SQL shared dimension if this shared dimension is not used in a cube is
it possible to access this dimension from the MDX running against the
cube to dynamically get the relevant exchange rate and multiply the
currency value with the exchange rate.

Also I tried finding the Microsoft whitepaper on currency conversion
cannot locate it anywhere can somebody point me a URL where I can
locate this URL for the currency conversion white paper.

Thanks
Belinda