Currency Codes and Exchange Rates

System Data Export updates the FX_Rate table in aP Analytics. The FX_Rate table contains an entry for each currency that is defined in aPriori . The record for each currency stores the following data:

• Currency Code: a three-letter alphabetic code based on the ISO 4217 standard (e.g. USD)
• Currency to Reporting rate: the FX rate from the currency to the default reporting database currency
• Currency to USD rate: the FX rate from the currency to the US dollar
• Start Date: the beginning of the time period that this rate is valid
• End Date: the end of the time period that this rate is valid

Whenever a System Data Export takes place, the FX_Rate table is updated with new currencies and/or existing currencies whose FX rate has changed in aPriori . Whenever an update takes place, aP Analytics will create a new entry in the FX_Rate table, thus preserving a historical record for currency rates. This enables aP Analytics to select the appropriate exchange rate that was in place when the scenario was costed.

The first time a currency is added to the FX_Rate table, its Start Date is set to January 1, 2000. Any scenario whose last costed date happened before the first system data export date will use this first FX entry when currency translation is required. This is the same way that the aPriori client works. For scenarios costed later than the first system data export date, aP Analytics will look for the appropriate entry in the FX_Rate table for currency exchange rates. The appropriate entry is the one whose start date is before the last costed date of the scenario and whose end date is after the last costed date of the scenario.

Customers creating their own reports could choose to have their reports work differently. For example, reports could choose the latest exchange rate for all currencies. This might be useful when creating a trend report and you want the currency figures to be constant and not affected by exchange rate fluctuation.