October 20, 2011 at 4:54 pm
I am developing a BI system where data is stored in one currency and the users want to be generating reports in many currencies. I have read the books and articles such this consultingblogs.emc.com/christianwade/ar...s-services-2005.aspx and followed the instructions but it is just displaying one wrong v figures. I have those dimensions and facts for time, currency dimension and sales and exchange rates facts respectively. When I try to generate reports in different currency i get wrong figures. please help me. I am expecting same values displayed in different currencies but I am not getting that. In the other words I want one -to - many .Thanks in advance.
October 21, 2011 at 4:47 am
If you have all of the data for exchange rates per currency then it should be a matter of using MDX to create calculations from your base currency to get the conversion amount.
For example, let's say your base currency is Pound sterling and the exchange rate to US Dollar is 1.35 (not using actual exchange rates here by the way :-D) then it would be a case of taking the pound sterling amount and multiplying it by 1.35 which would give you your US Dollar conversion amount.
I have no idea of your cube structure so cannot write the MDX for you.
Take this article as a starting point and go from there:
http://msdn.microsoft.com/en-us/library/ms175660.aspx
or this:
or this:
http://www.bp-msbi.com/2010/10/a-guide-to-currency-conversions-in-ssas/
Google is your friend 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply