Use of different currencies on OLAP cubes
In this user manual we will present how to view OLAP analyses and reports in different currencies
 |
Case summary
This article present a few cases of currency use in OLAP:
- Company is issuing documents in currency, diiferent from primary currency. (e.g.: company in Slovenia has default curreny EUR and is doing business with its subsidiary company in USA and is therefore issuing documents in USD).
- Head of sales department would like to view OLAP analyses in default currency (EUR in our case).
- Company is cooperating on a tender in Switzerland, where the tender leader requires analysis results in CHF to compare costs wit other participants.
|
1. Use of currencies in OLAP analyses and reports
OLAP analyses uses two sistem of currencies: (a) document currency and (b) OLAP currency. Document currency is the currency in which document is issued and OLAP currency is the currency, chosen for OLAP analysis in administration panel. Exchange rate is calculated from bank, that is set in administration panel as Bank - Price List
Currencies are recalculated as follows:
1. from document currency to primary currency. Exchange rate is selected from bank on date of document.
2. from primary currency to OLAP currency. Exchange rate is selected from bank on current date.
 |
Warning
In case that country changed primary currency between date of document issue and date of analysis (e.g. Croatia transfering to EUR on 1.1.2023 and Slovenia transfering to EUR on 1.1.2007), system uses bank, set in field Bank for Central Parity Rate. This field is only visible for localisations, where currency was changed. If exchange rate for OLAP currency is not found within this bank, than bank in field Bank - Price List is used.
|
2. Prepare OLAP analysis in primary currency
Company would like to prepare OLAP analysis in primary currency (EUR in our case). If we check issued document, that we are analysing we can see that document is issued in USD. Exchange rate for USD on the issue date is 1,15, which is written also on the document. Document price is recalculated according to exchange rate, so calculation is:
Price / EUR-USD exchange rate -> 15,42 USD / 1,15 = 13,41 EUR
Is OLAP processing is done with EUR as OLAP currency (which is also default currency) than sales analysis show the value, that was calculated above.
3. Prepare OLAP analysis in different currency
If we change OLAP currency before the processing, numbers will be recalculated according to exchange rate. Date of the exchange rate is today's date so the latest exchange rate will be selected. In our case below, exchange rate EUR-USD 1,20 will be selected as it is the newest. Price on the analysis will therefore be:
Price / EUR - USD exchange rate * EUR - CHF exchange rate -> 15,42 USD / 1,15 * 0,99 = 13,53 CHF
4. Company that changed primary currency
For the countries that changed the currency some specifics apply (e.g. Croatia changed currency on 1.1.2023 from HRK to EUR):
1. All documents before 1.1.2023 are recalculated in the primary currency (HRK) on the date of the document. Documents after 1.1.2023 are recalculated on EUR primary currency on the date of the document. Exchange rate, used for recalculation has to be defined on Bank - Price List.
2. If analysis is done after 1.1.2023 and OLAP currency is new default currency (EUR), all the documents will be recalculated according to latest exchange rate on Bank for Central Parity Rate.
3. If analysis is done in different default currency (e.g. USD) or exchange rate is not found on Bank for Central Parity Rate, then Bank - Price List is used to calculate exchange rate.
|
Warning
Field Bank for Central Parity Rate is visible only for localisations, where currency was changed.
When you change OLAP currency in administration panel you have to run the processing again as this recalculates the values and fills appropriate tables.
|