Import Exchange Rates Interfaces

image_pdfimage_print

Return to Models Overview

Historic as well as current exchange rates can be imported in any of three ways:

  • from a CSV file, in the format provided by the European Central Bank (ECB) and stored in an import folder in the file system. This folder must be accessible from the server running the Integration Server. 
  • from a CSV file, in the format provided by the ECB and stored in an import folder in the Report Designer of Jedox Web.
  • online, from the ECB website.

Note: The ECB does not provide exchange rate values for weekends or public holidays. If the last day of a month happens to be such a date, then the Month End value will be zero.

All three interfaces will first import rates into the Daily Exchange Rates cube. The ECB generally provides exchange rates from EUR to a variety of other currencies. If EUR is defined as a target currency, the values are imported directly. For other target currencies, the exchange rate is calculated as cross rates during the import from two provided EUR rates.

The import procedures, then take these values to calculate the Average and Month End conversion types at the month level, filter the results to the extent of the Month dimension, and store the results in the Exchange Rates cube.

Import from a CSV file stored in the file system

Prerequisite: download and unzip eurofxref-hist.csv from http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html and store it in the standard import folder on the file system.

This file can be imported using Integration Manager job xfcc08_60_EZB_Euro_rates.

Import from a CSV file stored in Jedox Web

Prerequisite: download and unzip eurofxref-hist.csv from http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html and store it in the standard import folder in Jedox Web.

This file can be imported using Integration Manager job xfcc08_60_EZB_Euro_rates.

Import from web site

Prerequisite: the Integration Manager must have access to the internet (http://www.ecb.europa.eu).

Exchange rates are imported using Integration Manager job xfcc16_60_ECB_Euro_reates_online.

Import procedure

Any of the three Integration Manager jobs executes the following procedure:

This job will import rates first into the Daily Exchange Rates cube in version Actual. The available rates are imported only if the date is a valid element in the Day dimension and if the source currency is a valid element in the Currency dimension. The calculation is conditional upon the following criteria: 

  • Rate 1 if Currency equals XXX
  • Rate 1 if Conversion Type equals ~
  • Rate 1 if Target Currency equals Currency
  • Rate of January and Conversion Type:Average if Version belongs to Calculation Schema P
  • Rate of previous month Conversion Type:Month End if Conversion Type equals Month Start
  • Rate of previous month if the exchange rate is empty

If EUR is defined as the target currency, the conversion rates to EUR as provided by the ECB are directly imported. For any other target currency the exchange rates are calculated as cross rates via EUR.

The procedure then takes these values to calculate conversion types Average and Month End at month level and filter the results to the extent of the Month dimension. The results are stored in the Exchange Rates cube. 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...