Running the ETL Currency Conversion Process
The process that actually converts monetary amounts stored in your MDW tables is an ETL utility. Currency conversion is a post process that must be applied after initial data load of all Fact tables. Therefore, before running this utility, make sure to run all the fact jobs in your project.
You can perform the ETL currency conversion process using both a direct exchange rate and a triangulated exchange rate. (A triangulated exchange rate conversion takes place when no direct exchange rate between a from currency and a to currency exists, but the exchange rates exist between the from currency and a reference currency, and from the reference currency the to currency. Using the triangulation method, the currency conversion process indirectly establishes the exchange rates between a from currency and a to currency using the intermediary reference currency. You set up triangulation parameters with other EPM setup functions.
If you provide an optional exchange rate date parameter, the currency conversion process searches for an exchange rate for a given exchange rate date. If you do not provide an exchange rate date parameter, the conversion utility uses the date of the transaction to determine the exchange rate.
Note: The MDW currency conversion process does not perform balancing; that is, when there are parent and child tables and rounding occurs, the process does not ensure that the sum of the child tables equals the value of the parent table.
If you map multiple source business units into one warehouse business unit (WBU), the default currency of the source business units must be the same as the default currency of the warehouse business unit.
Note: The Currency Conversion Rule ID exists on the MDW Conversion Schema Rule and the MDW Conversion Schema Rule pages. The Currency Conversion Rule ID provides the MDW Currency Conversion process with the necessary information to perform the currency conversion that you have previously identified, such as the rule to obtain the appropriate exchange rate, the rule to obtain the subset of dates within which the currency conversion will take place, and the source and target columns for the currency conversion.
Steps Required to Run the MDW ETL Currency Conversion Utility
Perform the following steps to run the MDW ETL currency conversion process:
In IBM WebSphere DataStage Director, navigate to the MDW currency conversion job by expanding the nodes in the left navigation panel using the following path: Jobs, EPM_Utilities, Currency_Conversion, Init_Process, SEQ_J_Run_CurrencyConversion.
Select the sequence job SEQ_J_Run_CurrencyConversion in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters by entering the required currency conversion rule for a specified fact table, and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Currency conversion occurs for all the facts grouped under this rule.
Repeat steps one through three for each currency conversion rule that you want to run.