Scenario reports
Use the Scenario reports to view the effects of currency exchange. There are two reports, one for one data version. The second report compares two data versions.
The report for one data version is calculated based on the matched currency version. For example, Budget 1. The matching of data version and currency version is done on Configure Version Translation tab. The rates from the assigned currency version are displayed. The values in the entity currency are calculated into the selected currency. You can select rates from another currency version.
The report for two data versions lets you compare two versions. Transaction differences are the calculated difference values from both data versions in entity currency. Exchange rate differences are amounts in analyze currency resulting from:
- The difference of both selected exchange rates multiplied by the value of first data version.
- The difference of both selected exchange rates multiplied by the transaction difference.
The exchange rates of different rate types (PA; F; H) are affected by the value of the selected time element, either periodic or Year-to-Date.
The Scenario reports are available for balance sheet and profit and loss.
The exchange rates displayed in the report are calculated rates and they are not stored in OLAP. An exchange rate can be an entity currency, for example EUR. An exchange rate can consist of several local currencies such as GBP, USD, and EUR). Exchanges rate can come from any source system. They are calculated automatically by conversion standard rules.
The report it is restricted with five digits. This restriction is why slight differences can appear in Periodic Average or Historical rates. Closing rates are not affected.