Changing Currency in Planning

In forms enabled for currency conversion, you can enter data in a currency other than the base currency of a cell. Currencies in the drop-down list can be designated as the local currency.

Note:

To override the base currency for an entity, the cell must be displayed in the local currency, and its version must be bottom-up. The application must be a multi-currency application and the form should support multi-currency.

To enter cell data in a local currency other than the base currency for the cell:

  1. In a form, select a local currency member for the cell.
  2. Optional: To look up the currency's code, select View, then Currency.

    Available Currencies shows the application's currencies. Note the Currency Code for the currency you want to work with, and close the window.

  3. In the right column, HSP_InputCurrency, type the new Currency Code in the data cell.

    Typing the currency code in the data cell overrides the base currency for the entity.

  4. Click Submit to submit the new currency code to the Oracle Hyperion Planning server.
  5. Enter the currency value in the left column, HSP_InputValue, of the data cell.
  6. Click Rules on Form and select the Calculate Currencies rule to calculate and save the new currency value.

    If the Calculate Currencies calc script is set to run when the form is saved, and the form is enabled for multiple currencies, the data value is displayed in the currency you selected.