Setting Up Currency Conversion
You run the currency conversion process from a prepackaged ETL job, which uses the Currency Conversion Rule ID as an input and is a composite of the conversion rules whose parameters you have set up before you run the currency conversion process. The Currency Conversion Rule ID provides the necessary information to perform the currency conversion, such as the rule to obtain the appropriate exchange rate, the rule to obtain the subset of data on which the currency conversion is performed, and the source and target columns for currency conversion.
To set up currency conversion, use the Schema Definition (CCU_SCHEMA_DEFN) component and the Currency Conversion (CCU_CONV_DEFN) component.
Before you run the ETL currency conversion process, you must define the required parameters. This section discusses how to:
Set up the schema definition and columns.
Define schema source columns.
Define schema target columns.
Define rules for currency conversion.
Pages Used to Set Up the Schema Definition and Currency Conversion Rules
Page Name |
Definition Name |
Navigation |
Usage |
---|---|---|---|
Schema Definition |
CCU_SCHEMA_DEFN |
|
Set up the schema definition. |
Schema Source Columns |
CCU_SCHEMA_SRC |
|
View or modify source monetary amount and currency code columns. |
Schema Target Columns |
CCU_SCHEMA_TGT |
|
View or modify target monetary amount and currency code columns. |
MDW Currency Conversion Rule |
CCU_CONV_DEFN |
|
Set up currency rule definition and chunking rule definition. |
MDW Conversion Schema Rule |
CCU_CONV_SEQ |
|
Set up conversion schema rule. |
Schema Definition Page
Use the Schema Definition page (CCU_SCHEMA_DEFN) to set up the schema definition.
Image: Schema Definition page
This example illustrates the fields and controls on the Schema Definition page. You can find definitions for the fields and controls later on this page.
MDW Currency Conversion Rule Page
Use the MDW Currency Conversion Rule page (CCU_CONV_DEFN) to set up currency rule definition and chunking rule definition.
Image: MDW Currency Conversion Rule page
This example illustrates the fields and controls on the MDW Currency Conversion Rule page. You can find definitions for the fields and controls later on this page.
Currency Conversion Rule |
The name of the currency conversion rule. |
Conversion Rule Definition
Chunking Rule Definition
MDW Conversion Schema Rule Page
Use the MDW Conversion Schema Rule page (CCU_CONV_SEQ) to set up conversion schema rule.
Image: MDW Conversion Schema Rule page
This example illustrates the fields and controls on the MDW Conversion Schema Rule page. You can find definitions for the fields and controls later on this page.