Exchange rate tables enable budget preparers to create plans in different currencies. For example, you can specify Yen as the base currency for the Japan entity and US dollars for the United States entity. When you display a form with values for the Japan entity and display currency set to US dollars, the Yen exchange rate is used to convert values for Japan to US dollars. If the display currency is set to Yen, the exchange rate for US dollars converts values for the United States entity to Yen.
To use exchange rates, you must select Multiple Currencies when creating an application. You can set up exchange rates using the procedure in Creating Exchange Rate Tables and Editing Exchange Rate Tables.
A multiple currency application stores exchange rates with the HSP_Rates dimension, which includes these members and others that store currency rates:
When generating reports or loading data, you must 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.