Performing Currency Conversion

The following example illustrates currency conversion results in a story:

1. Measures: The local currency property value for Store02 is EUR.
2. Local_Currency: The local currency is EUR. This value is stored in the database.
3. Group Currency USD: The group currency is USD. This value is also stored in the database.
4. Alternative Currency CAD: The alternative currency is calculated but not stored. This is an example of a model currency conversion measure.
5. Simulated_Cur_USD_PY (USD): This simulated currency is a story-calculated measure.

In the following example, you can see the information required to create a converted measure in a story:

1. Add Calculation: In the story columns, add a calculated measure for currency conversion.
2. Name: Provide a name for the new column.
3. Target Currency: Select the target currency: either fixed or based on the entity currency.
4. Category: You can choose between categories, either dynamic, or fixed to actual or plan.
5. Source Measure: Select the required measure from the drop-down list.
6. Date: Select the date to determine the exchange rate. The Booking Date, for example, is determined through the date dimension (specified in the currency setting) in the model.

Business Scenario: You want to compare values that use exchange rates for different categories. To do this, you can use category-specific exchange rates, which are useful for what-if scenarios.

In the conversion table in the following example, you can see the category-specific exchange rates for Actuals and Forecast.

• The Actuals exchange rate is 0.15.
• The Forecast exchange rate is 0.155.

Then, in the story Builder panel, two story calculations are added using the Calculation Editor for Actuals and Forecast.

Output: Set the filters to include all three measures. In this example, when the CAD value for Store01 is updated to 5,000,000 dollars, the PesoAct and PesoFcst update according to the rate table exchange rates.

• Actuals: 5,000,000 CAD x 0.15 = 750,000 MXN
• Forecast: 5,000,000 CAD x 0.155 = 775,000 MXN

Business Scenario: You want to see a company's annual growth in a model currency (such as USD) but you want a flat conversion rate applied. To do this, you filter out the currency conversion impact on your figures.

• The Default Currency (USD) values are translated with the monthly average exchange rates for 2025. For example:
  • Jan: 11,655.9 x 1.1 = $12,821.5
  • Feb: 17,302.5 x 1.15 = $19,897.9
• The USD in Constant ER (USD) values are translated with the Jan average exchange rate for 2025. For example:
  • Jan: 11,655.9 x 1.1 = $12,821.5
  • Feb: 17302.5 x 1.1 = $19,032.7