1. Administering Planning
  2. Accessing More Administrative Tasks
  3. Administering Dimensions
  4. Setting Up Currencies
  5. Specifying Exchange Rates
  6. Hsp_Rates Dimension for Standard Multicurrency Applications

Hsp_Rates Dimension for Standard Multicurrency Applications

Note:

This topic assumes the Standard multiple currency option was selected during application creation. If the Simplified multiple currency option was selected, see About Simplified Multicurrency.

A Standard multiple currency application includes the Hsp_Rates dimension for storing exchange rates. It includes these members and others that store currency rates:

  • Hsp_InputValue: Stores data values

  • Hsp_InputCurrency: Stores currency types for data values

When generating reports or loading data, refer to the Hsp_InputValue member. When loading data, you must load data against the local currency. You need not refer to the Hsp_InputCurrency member.

By default, the Hsp_Rates dimension is set to Sparse. You can change this (see Setting Dimension Density and Order).