Skip to Content

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!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply