Skip to Content
0
Jun 04, 2020 at 05:51 PM

Currency Conversion - More than one currency in a country

203 Views

I am writing this question in reference to the process of currency conversion in SAP Analytics Cloud. The problem is that some countries in our system operate in different currencies.

For example, we have a model with the following rows uploaded into it:

As you can see, Mexico has two table entries with operations in both dollars and Mexican pesos. The default currency in our system is EUR, the local currency of Mexico is MXN and the local currency of Spain is EUR. Given this situation, we would like our stories to convert this amounts into the following:

Until this moment, we have only seen a country having only one currency (the local one assigned to the country dimension) so that when values are imported the measure is automatically related to the local currency. In our system, we need to import values in different currencies for the same country but the local currency must be one (Mexico example), so the other values which are not in the local currency (USD) must be converted to the local currency (MXN) and the system default currency (EUR).

How can we possibly import values in different currencies for the same country? Does SAP Analytics Cloud support it?

Do not hesitate to contact us for further details.

Thank you in advance,

Elisa

Attachments

capture.png (4.6 kB)
capture2.png (13.3 kB)