Setting Up the Target Currencies

Return to

Models Overview

Target currencies are base elements in Target 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 Target Currencies.

In addition to each target currency, several elements in the Currency dimension are required:

  • For each combination of source currency (e.g. MXN) and the target currency (e.g. USD), 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. MXN > USD).
  • For the trivial conversion, where source and target currencies are identical, no conversion element is needed.
  • For the conversion of local currency to each target currency, another conversion element (e.g. LC > USD) must exist.
  • For each target currency, a total of all conversion elements must exist. The naming convention for this total is the sequence "greater sign – blank" and the target currency code (e.g. > USD). Children of this element are:

    • the non-currency element (XXX)
    • the source currency element to the target currency (e.g. USD)
    • the conversion element of the local currency (e.g. LC > USD)
    • all conversion elements from any source currency (e.g. MXN > USD)



Note: After changing the target currencies, the rule templates handling the currency conversion in the fact cubes need to be updated.

Updated November 5, 2024