Currency Conversion in SAP Analytics Cloud Planning Model
The product is constantly changing, so if you find anything different than the real product, don’t be surprised and please do comment and let us know.
SAP Analytics Cloud Planning model has the capability of currency conversion( in this blog, we’ll user CC for short ). The rate information is maintained in rate table
Below is a how a rate table looks like.
Currency and Currency Conversion setting
Currency Conversion off
The Currency setting will be a bit different when you switch on and off Currency Conversion.
For a Model that has CC switched on, you should choose either a Default Currency or a Currency Dimension for the model.
CC off with Default Currency
In the case of CC off, the Default Currency is both the default reporting and input currency.
You can also choose to use a Currency Dimension. Noticed that unlike BPC the ID of the Currency dimension is the currency key, in SAC, you need to specify a currency property.
- For Organization type dimension, the property is Local Currency
- For Generic type dimension, the property is Currency
In any of the case above, the Story will not automatically detect the currency type and the number will be displayed as normal key figure without any currency sign.
Use Local Currency from Organization dimension as the Currency Dimension
Currency Conversion On
You can also switch on the Currency Conversion feature for a model. And once the CC is created, you’ll need to setup both Default Currency and a Currency Dimension. Similar to above, the Currency Dimension can be either Organization or Generic type.
Also you need to choose the rate table you want to attach to this model.
Currency Conversion on
How CC is performed
CC in SAC is performed at runtime. Different than BPC, the converted results are not persisted. When CC is on, SAC only stores the local currency data. For planning case, user can input both local currency and converted currency.
In SAC, unlike BPC where you can drag/drop CURRENCY on row/column as it’s a dimension, to display the Currency property, you’ll need to create a Currency Conversion typed Cross Calculation.
By default, there are 2 types of Cross Calculation members. One is Default Currency and the other is Local Currency. When you create a story, by default only the Default Currency is displayed.
Default Currency and Local Currency
*If you use Org type, it’s Local Currency, if you use Generic type, it’s Currency.
Below is a report with CC on. Story will automatically attach the currency sign to the number.
Currency Conversion on and Org type dimension as Currency Dimension
Besides the 2 types, you can create more “currency measures” by adding a new CC type calculation.
Create CNY type Currency Conversion
After creating the CC, it’ll become a member in CrossCalculation. You can choose to display it on the story like any other dimension members.
CNY displayed on the report
*You need to make sure the rate values are maintained beforehand, otherwise the story won’t show correctly.
Meaning of Default Currency is different when switching on/off Conversion
- When CC is off, Default Currency is both reporting currency and input currency
- When CC is on, Default Currency is Reporting currency. The end user is inputting data on Local Currency, Default Currency is automatically converted. If user input data on Default currency or Converted Currency, before publishing, the other type of currency data will become temporarily unavailable. After publishing, SAC will calculate all types of data.
Type in Default Currency, before publish
After publish
About Import from S/4HANA
S/4HAHA has 3 default types of currencies:
- Global Currency
- Transaction Currency
- Company Code Currency
The relationship of currency between S4 and SAC is below:
| S4 | SAC |
| Global Currency | Default Currency(model setting) |
| Transaction Currency | Currency dimension(Generic type Currency Dimension) |
| Company Code Currency | Local Currency( The Currency property in Organization dimension ) |
So based on above mapping relationship, we can create below table as recommendation of Import
| CC on | Import Company Code Currency to Local Currency |
| CC off w.o Currency Dimension | Import Global Currency to Default Currency |
| CC off w. Currency Dimension | Import Transcaction Currency to the Currency Dimension |
Export to S/4HANA Mapping Recommendation
SAC Export is flexible. But without proper configuration it’s easy to make mistakes.
Below is the recommendation for export:
| CC on | CC off | ||
| w. Default Currency | w. Default Currency | w.o. Default Currency | |
| Org Currency Dimension | LC->ComCode Curr | NA | (new case) LC->ComCode Curr |
| Generic Currency Dimension | (new case)Generic Curr -> Tranx Curr | NA(used to support) | (new case) Generic Curr -> Tranx Curr |
| w.o. Currency Dimension | NA | Def Curr -> Glbl Curr | NA |
Import/Export with BPC Recommendation
This is still being discussed as the behavior could be very complex when introducing the new Currency as dimension concept.
At last
As I have also emphasized at the beginning of this blog, this is an evolving product and the feature is kept enhanced. Do not feel surprised my blog becomes completely wrong in a few months. If you find do, do leave comments and let us know. Thanks in advance!
Dear Sibo Zhang,
This is a Super blog on Currency conversion, most of the queries will be resolved after walking through it. appreciate your great work.
Regards