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 a dimension in the cube, such as account, transaction type, or measure.
The exchange rates from each source currency to each target currency are stored and maintained by the dimensions Version and either Day or Month.
See the article Fact Cube Using Currency Conversion for more details on the currency conversion.
Updated January 13, 2023