So we have a cube setup that does a many-to-many currency conversion. Until this point, the Exchange Rate measure group has used a Currency data type for the exchange rate, but I didn't realize that that's limited to 4 decimal places. With the only other Data Types in SSAS being Double and Single, what are people using for their exchange rate data types when the rates may need to be more then 4 decimal places? How many decimal places would a double be accurate to from a FX rate perspective?


The range of the Double data type is huge but is it an imprecise floating point.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.