Preparing Euro Conversion Source Files

You must prepare your source files for the conversion.

Procedure

  1. If you have not already done so, create and load the required source files for your base Currency Table source files, and then create the corresponding source files to populate the euro portion of your currency conversion table. These files should contain the three mandatory columns, and may contain a fourth currency Label column, as described below:
    • For each EMU-member country or region, insert a zero value for the date. For countries or regions that are not EMU members, add a row for each time period to which the conversion rates apply, and insert the correct date. This constitutes the Date column.
    • Uniquely identify the countries or regions to which the rates apply, using the internationally recognized code for each country or region. If the country or region already appears in the base Currency Table, the code must be identical to that used there. This constitutes the Country Code column.
    • Specify the amount by which you must multiply one unit of the currency to convert it to a euro. This constitutes the euro conversion rate column.
    • Optionally, specify a meaningful label for the currency. If you do not, the label is generated automatically, from the country or region code.
  2. Add a data source to your model for each euro conversion source file.
    Note: If you create the time dimension from more than one source file, the Date column names must match. Also, the column names specified for euro conversion must differ from those specified for the base Currency Table.
  3. Double-click each source in the Data Sources list to open its property sheet, click the General tab, and clear the Sets the current period check box and all check boxes under Timing.

    Alternatively, ensure that the conversion Date column has a different name from that of the column used to create the time dimension.

  4. Click OK.