Understanding Load Item - Data for Currency Exchange Rates

Parameters

• Scenario: Select the Scenario for which you want to load exchange rates. Scenarios represent versions of a budget or forecast for a fiscal year and are created on the Scenario Setup page.
  • If you select a Budget type scenario, the Time Mapping Across Columns by Scenario option is available.
• Apply Currency Conversion: Automatically converts local currencies to a common currency. 
• Time Mapping
  • Across Columns by Scenario is available for Currency Exchange Rates if a budget scenario is selected while loading Exchange Rates.
  • Fiscal Year and Fiscal Month will be disabled in Default Settings. Fiscal Year will be disabled in Data Mappings.
    • Down Rows - Selecting this option indicates that time periods are defined down the rows.
    • Across Columns - Selecting this option indicates that time periods are defined across the columns.

Defaults

• Parameter: The parameters listed are those available to be included in the data file.
• Include in Data File: 
  • Select Yes if a dimension is not defined within the data file and there is a common member for all records.
  • Select No if you do not want the listed parameters in the data file.
• Select: Available if you select No for a parameter. Search for other dimensions to associate with the data file.

Selection Translation(s)

• Select currency translations to change the value of the source currency into another (foreign) currency target value.