Skip to Content
Technical Articles

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.

In this Story, I have created an Input Control to select the Currency on which the data has to be displayed in the table.

CURRENCY – SAR

CURRENCY – USD

Be the first to leave a comment
You must be Logged on to comment or reply to a post.