Currency Conversion Configuration

Return to Profit and Loss Model Overview

Configuration of Conversion Types

The conversion type is defined through a dimension in the cube such as account, transaction type, or measure. This article will use the PnL Account dimension for explanation.

This dimension must have a Conversion Type attribute. This attribute must be set to a base element of the Conversion Type dimension for each base element of the PnL Account dimension. The ~ conversion type always contains a rate of 1 and can be used to prevent unwanted currency conversion, e.g. for the number of heads.

Setting Up Additional Conversion Types

By default, Conversion Type dimension contains the elements Average, Month Start, and Month End. These elements must not be removed.

Additional elements can be added to this dimension as children of  All Conversion Types. The Name attribute must be set. Exchange rates for the additional conversion types can be stored in the Daily Exchange Rates and Exchange Rates cubes.

Conversion from Implicit Local Currency

The element LC (Local Currency) must be a base element in the Currency dimension and must be a child of the total element All Currencies. The currency code to be used as the local currency is implied through the legal entity, and is defined through the attribute Currency in the Legal Entity dimension. This attribute must be defined with a valid source currency for each base element of the Legal Entity dimension.

Conversion from Explicit Source Currency

The conversion of explicit source currency does not require any additional configuration.

Synchronizing Exchange Rates in Forecast and Budget Versions

Exchange Rates cube features the synchronization of exchange rates across months and conversion types. This feature applies to versions starting with Budget or Forecast. After creating or renaming versions, the rule templates handling the exchange rate synchronization in the Exchange Rate cube need to be updated.

For more information, see the article Exchange Rates cube

Exchange Rates

The currency conversion works with any exchange rates stored in the Exchange Rates cube. These exchange rates can be maintained through:

  • manual input using the Exchange Rates report or an ad hoc view
  • using one of the interfaces to import exchange rates provided by the European Central Bank
  • a custom import procedure implemented in the Integrator on Jedox Web

Updated August 25, 2023