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 data 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. (Use Performance Management Architect to specify the base currency, currency code and symbol, triangulation currency, reporting currency, and exchange rate type. See the Oracle Hyperion Enterprise Performance Management Architect Administrator’s Guide.) You can set up exchange rates using the procedure in Creating Exchange Rate Tables and Editing Exchange Rate Tables.
Multiple-currency applications store 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 Dense. You can change this in Performance Management Architect. Planning supports currency conversion by triangulation through the triangulation currency set in Performance Management Architect.