Skip to Content
User Experience Insights
Author's profile photo Dirk Pelz

SAP Analytics Cloud Currency Conversion with Conversion Measure and Currency Variable – new Model

In this blog we will look at the possibilities of currency conversion in the new SAP Analytics Cloud Model and compare “in Story Calculation” and the new conversion with “Conversion Measures” and “Currency Varibales”.

With currency conversion in SAP Analytics Cloud, it is possible to report and plan in different currencies. The use of “Conversion Measures” and “Currency Variables” allows new possibilities of application and extends the previous “in story” calculations.

For our example we need

  • a planning model,
  • a currency conversion table and
  • a story.

At the very beginning we set up the conversion table for our currency rates in SAP Analytics Cloud “Currency Conversions”.

 

Figure%201%3A%20Conversion%20table%20for%20currency%20rates.%20This%20also%20includes%20the%20currency%20scenarios%2C%20such%20as%20here%20Specific%20FC2020.

Figure 1: Conversion table for currency rates. This also includes the currency scenarios, such as here “Specific FC2020”.

 

Second, we build a very small SAP Analytics Cloud planning model. The model (New Model) consists of an account dimension with profit and loss structure. In addition, an organization dimension with companies in different countries and currencies. One currency is assigned to each company (Local Currency). Other setups are possible, but in this example we will keep it simple.

 

Figure%202%3A%20Model%20with%20account%2C%20company%2C%20time%20dimension%20and%20the%20measure%20M2%20with%20currency%20type.

Figure 2: Model with account, company, time dimension and the measure M2 with currency type.

 

Figure%203%3A%20The%20society%20dimension%20with%20the%20currencies%20set%20per%20unit

Figure 3: The entity dimension with the currencies set per unit

 

Figure%204%3A%20The%20account%20dimension%20for%20mapping%20the%20profit%20and%20loss%20structure%20%28simplified%29

Figure 4: The account dimension with profit and loss structure (simplified)

 

After the base model is built, a “Conversion Measure” can be created in our model.

 

Figure%205%3A%20Creating%20the%20Conversion%20Measure%20for%20an%20in%20Model%20Calculation

Figure 5: Creating the Conversion Measure for an in Model Calculation

 

In a story, we use the table to view our model. To do this, we create a table with the company and accounts in the rows and version, measure and date in the columns.

 

Figure%206%3A%20A%20new%20story%20on%20our%20model%20and%20selecting%20the%20Conversion%20Measure.

Figure 6: A new story on our model and selecting the Conversion Measure.

 

Before we use the “Currency Variable”, we will create an “in Story” currency conversion for comparison.

 

Figure%207%3A%20Create%20in%20story%20calculation%20for%20currency%20conversion

Figure 7: Create in story calculation for currency conversion

 

Now we apply the currency variable and see the different possibilities of the two conversion variants. With the currency variable we have the possibilities to set the report currency via the filter function. Each conversion variant stored in the currency table can be reported or analyzed directly. The old variant only allowed the conversion set or selected in each case.

 

Figure%207%3A%20Use%20of%20the%20currency%20variable

Figure 7: Use of the currency variable

 

With the new SAP Analytics Cloud Model and the “Conversion Measure” plus “Currency Variable”, new possibilities of currency simulation and exchange rate conversion come into use. The structure used here shows a variant of the modeling and can be used as an idea or introduction.

 

Many thanks for your interest in the topic and I hope you like it. Please share your feedback in the comments and let me know if you have any questions.

 

Stay tuned and stay healthy,
Dirk

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jan Vereecken
      Jan Vereecken

      Dirk ,

      Can the Currency and Unit conversion be taken over from the ECC/S4 system ? In a similar way as in the BEx / AfO .... Or do we need to maintain the conversion in SAC ? ,

      Is this only available in a planning model ?

      Regards

       

      Jan

       

      Author's profile photo Dirk Pelz
      Dirk Pelz
      Blog Post Author

      Hi Jan - thank you for your questions and interest in the topic.

       

      This article looks at modeling with currencies in an SAP Analytics Cloud planning model. SAP Analytics Cloud is much more than "only" a frontend like BEX/AfO, because also the holding and/or planning of currency scenarios is possible. The master and transaction data is loaded into a SAP Analytics Cloud Model. If already converted currencies (Preconverted) of are to be used, these can also be utilized (see -> https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.1/en-US/fe39568a750e4ef38bf43065ff403ce8.html).

       

      This link to an article by Kanchana Subbiah

      explains more ideas on how to handle currencies and I find it particularly well done

      https://blogs.sap.com/2021/07/08/sap-analytics-cloud-planning-measure-based-model-pre-converted-actuals-working-with-multi-currency-conversion/

      I will be happy to have helped a little.