This blog states how to create Currency Conversion calculation using Cross Calculation dimension in a story based on a Planning Model.
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