Performing Currency Translation

The following example illustrates currency conversion results in a story:

1. Measures: The local currency property value for Store02 is EUR.
2. P_ACCT Values: The local currency is EUR. This value is stored in the database.
3. Group Currency USD: The group currency is USD. This value is stored in the database also.
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. Columns: In the story, 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. You use category-specific exchange rates, which are useful for what-if scenarios.

In this example, the CAD value for Store01 is 5,000,000 dollars.

1. Currency conversion table:
   • The Actual exchange rate is 0.15
   • The Forecast exchange rate is 0.155
2. Actual currency: Add a currency conversion for actual.
3. Forecast currency: Add a currency conversion for forecast.
4. Output: View the results in the story.
   • Actuals: 5,000,000 CAD x .15 = 750,000 MXN
   • Forecast: 5,000,000 CAD x .155 = 775,000 MXN

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

• The Default Currency (USD) values are translated with the monthly average exchange rates for 2020. 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 2020. For example:
  • Jan: 11,655.9 x 1.1 = $12,821.5
  • Feb: 17302.5 x 1.1 = $19,032.7