About Standard Multicurrency

If you're familiar with Planning, then you're familiar with the Standard multiple currency approach. This is the approach that your current Planning applications use.

Selecting the standard multiple currency option during application creation creates two additional dimensions called Currency and HSP_Rates. You can add more currencies as members of the Currency dimension. The HSP_Rates dimension is a hidden dimension that stores exchange rates. This dimension includes these members and others that store currency rates:

  • Hsp_InputValue: Stores data values

  • Hsp_InputCurrency: Stores currency types for data values

For more information, see Hsp_Rates Dimension for Standard Multicurrency Applications.

For an account with a currency data type, you can choose from one of the following exchange rate types:

  • Historical

  • Average

  • Ending

For more information, see Data Type and Exchange Rate Type.

Based on the exchange rate type, a user-defined attribute (UDA) is associated with the account that is used in the currency calculation. You can associate an entity to a currency. For example, when you associate the entity USA to the currency USD, the local currency in the form for the USA entity is USD.

You can create multiple exchange rate tables, each representing a different business scenario. Each scenario can be associated with only one exchange rate table.

You can run a calculate currency rule that generates the rule at runtime based on the members included in the form. This rule can be set to run when the form is saved or loaded, based on the requirement.

For more information about using the standard multiple currency approach, see Administering Dimensions.