Currency Conversion (Cash Flow Model)


Return to Cash Flow Model Overview

The currency conversion features the conversion of amounts stored in a source currency into a target currency. The system can be customized for any set of source currencies and for one or multiple target currencies. The target currencies are also known as group or reporting currencies.

The source currency is determined in either of two ways: implicitly, as the local currency (currency code LC), where the currency is defined though the Legal Entity; or explicitly, by storing the amount of the source currency. Both methods can be mixed. In the case of explicit source currencies, multiple source currencies can be combined at the same time.

The exchange rates to be used for the conversion can be stored and used for a variety of conversion types: 

  • Average
  • Month end
  • Month start

The appropriate conversion type is defined through the CF Account dimension.

The exchange rates from each source currency to each target currency are stored and maintained by the Version dimension and either the Day or Month dimensions.

The majority of figures in the Cash Flow cube are integrated from the Profit and Loss and Balance Sheet cubes. All of these currency values are integrated as already converted values. Only the values entered on the Adjustment measure are subject to the currency conversion in the Cash Flow cube.

See the article Fact Cube Using Currency Conversion for more details on the currency conversion.