Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Process for Configuring Currencies >

Supplying Document-to-Group and Local-to-Group Currency Exchange Rates

This task is a step in the Process for Configuring Currencies.

As mentioned in the previous section, the Siebel Customer-Centric Enterprise Warehouse can present all amount values in three different currencies—document, local, and group. If all three amounts are not supplied by the source system, then the ADI can calculate the amounts using prepackaged exchange rate logic.

Usually the EXT_DOC_TO_GRP and EXT_LOC_TO_GRP values are null at the input of the ADI. Therefore, the ADI has to perform a lookup to retrieve the exchange rates. However, if you want to supply an exchange rate directly, you can do so by using the appropriate column. The EXT_XRATE_DOC_TO_GRP column supplies the exchange rate that converts the document currency to group currency, and the EXT_XRATE_LOC_TO_GRP column supplies the exchange rate that converts the local currency amount to the group currency amount. In this topic, you can find procedures for providing exchange rates.

To supply exchange rate values directly

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. In the MPLT_SA[Source Abbreviation]_XRATES Source Adapter mapplet, edit the expression for the applicable port.

   You can use the EXT_DOC_TO_GRP column to convert the document currency to the group currency. You can use the EXT_LOC_TO_GRP column to convert the local currency to the group currency.

3. Validate and save your changes to the repository.