Setting Up the Available Source Currencies (Financial Consolidation)

Return to Financial Consolidation Model Overview.

Source currencies are base elements in the Currency dimension. Valid currencies must be represented by a code consisting of three capital letters, as defined by ISO 4217. All source currencies must be children of the total element All Currencies.

For each combination of source currency (e.g. USD) and target currency (e.g. EUR), a conversion element must exist. The naming convention for the conversion element is the source currency code followed by the sequence “blank – greater sign – blank” and the target currency code (e.g. USD > EUR). These elements must be children of the total of all conversion elements. The naming convention for this total is the sequence “greater sign – blank” and the target currency code (e.g. > USD).

Currency codes not intended to be used as a source currency can be moved to the parent element Unassigned or removed from the Currency dimension entirely.

After changing the set of available source currencies, you must update the rule templates handling the currency conversion in the fact cubes.

Updated March 21, 2024