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	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select Schema Definition	Set up the schema definition.
Schema Source Columns	CCU_SCHEMA_SRC	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select Schema Definition	View or modify source monetary amount and currency code columns.
Schema Target Columns	CCU_SCHEMA_TGT	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select Schema Definition	View or modify target monetary amount and currency code columns.
MDW Currency Conversion Rule	CCU_CONV_DEFN	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select MDW Currency Conversion Rules	Set up currency rule definition and chunking rule definition.
MDW Conversion Schema Rule	CCU_CONV_SEQ	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select MDW Conversion Schema Rules	Set up conversion schema rule.

Schema Definition Page

Use the Schema Definition page (CCU_SCHEMA_DEFN) to set up the schema definition.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select Schema Definition

Image: Schema Definition page

This example illustrates the fields and controls on the Schema Definition page.

Business Unit Column

Enter the name of the PF (performance) business unit column.

MDW Fact Exchange Dt Column (MDW fact exchange date column)

Enter the date column used to determine the exchange date or conversion date.

Date/Period Dimension Record

Enter the level (year, month, day, and so on) for the Fact Exchange Date column.

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.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select MDW Currency Conversion Rules

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

Rate Type

Select the rate type for this rule.

To Currency Code

Select the currency code for the converted value.

Specify conversion date

Select the date as of which the conversion rate should be applied. Values are:

Dt. column (date column): From the transaction record.

Exchng Dt. (exchange date): User defined for the entire data set on which currency conversion is performed.

Recent Dt. (recent date): The most recent conversion rate that exists in the exchange rate table.

Chunking Rule Definition

Warehouse BU (warehouse business unit)

(Optional) Select the warehouse business unit (PF BU) for the currency conversion. If you supply a business unit parameter, only MDW fact data that belongs to that business unit will experience currency conversion. If you do not supply a business unit parameter, data for all business units will experience currency conversion. Because all source business units have an associated PF BU in the EPM MDW, the business unit in the conversion rule refers to the PF business unit.

Start Date

(Optional) Enter the date for which the currency conversion should begin. If you supply a start date parameter, any date greater than or equal to this parameter value will experience currency conversion. If you do not supply a start date parameter, then the currency conversion process uses 01-01-1900 in place of a start date.

End Date

(Optional) Enter the date for which the currency conversion should end. If you supply an end date, any date less than or equal to this parameter value will experience currency conversion. If you do not supply an end date parameter, then the currency conversion process uses the present (or process) date in place of an end date.

Notes

(Optional) Enter notes about this currency conversion rule.

MDW Conversion Schema Rule Page

Use the MDW Conversion Schema Rule page (CCU_CONV_SEQ) to set up conversion schema rule.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select MDW Currency Conversions, then select MDW Conversion Schema Rules

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.

Record (Table) Name

Select the record on which the conversion will be performed. The record name must exist in the schema definition.

To Amount Column

Select the column for the conversion result. The options are obtained from the schema definition.

From Amount Column

The column to be converted. This field is automatically populated from the schema definition when you select the To Amount Column.