Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  SSAS Currency conversion issue

Author  Topic  volyn Starting Member 30 Posts Posted - 2011-05-15 : 10:36:45 Hello, I have read a lot of text abou currency conversion, but in fact I dont know how to start, I will explain what I have and what i need. In fact table I have two columns with amounts 1.Value that was oredered by customer 2.Value that was invoiced to customer Difference between these 2 numbers is non-delivery of goods (from any reason, not important now). In this fact table are records of all orders around 3 countries, each in local currency (each country has own currency). I need to create measure SERVICE RATE, which counts simply InvoiceValue/OrderValue. If I want to count service rate for all three countries, there should be used all values in one currency. For example I have currencies USD in USA,EUR in Germany,GBP in UK. Most important currency is USD, so EUR and GBP should be converted to USD in background and then SERVICE RATE should be calculated. BUT If I need to calculate SERVICE RATE only for UK its nonsense to convert it into USD. Should be calculated from GBP values directly. Do you know how to do that? I have of course table, where are all rates. Thanks