Currency Conversion (Cash Flow Model)
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:
- 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
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.