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.
- 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