Currency Conversion in Cross Calculations – SAC

This blog states how to create Currency Conversion calculation using Cross Calculation dimension in a story based on a Planning Model.

Content:

1. Enable Currency Conversion in the Model

In the Model Preferences, enable Currency Conversion. You can choose the options to set the Default Currency and the Dimension with Currency Property Enabled.

In this Model, COMPANYCODE (Organization) dimension has been with Currency property enabled.

2. Maintain Exchange Rate

The Exchange Rate must be maintained in the Currency Rates Table that has been selected in the Model. You can maintain exchange rates based on Category, Rate Version (Category – Specified) and Rate type (INC and EXP – Average; AST and LEQ – Closing) in the Exchange Rate Table.

3. Enable Cross Calculation in the Story

Create a story based on the Model and enable Cross Calculation

Add Calculation in the Cross-Calculation dimension

Select Type – Currency Conversion and select the currency from the dropdown. The Exchange rates maintained in the table will be shown in the dropdown.
You can choose the Category, Rate Version and Date based on which the Exchange rate to be considered maintained in the Exchange Rate Table.