This content has been marked as final. Show 1 reply
The BI Applications have currency conversion features built in; I would explore them in the first instance.
Up to three global currencies are supported; these are setup using DAC parameters:-
The ETL populates these for each datasource into the Warehouse table W_GLOBAL_CURR_G (using mapping SIL_GlobalCurrencyGeneral_Update).
The rate type parameters tell the ETL where to source exchange rates from in your source system. If you want to source rates from a different data source (e.g. a flatfile) then you will have to customise mappings to load W_EXCH_RATE_G accordingly (see the mappings SIL_ExchangeRateGeneral and the corresponding SDE mapping(s) for your data source e.g. PeopleSoft).
If you look at the SIL mapping for the W_GL_BALANCE_F table (SIL_GLBalanceFact) you will see a Mapplet called MPLT_CURCY_CONVERSION_RATES1 which gets the three global exchange rates for a given DATASOURCE_NUM_ID, TENANT_ID, EXCH_DT and DOC_CURR_CODE. This mapplet references W_GLOBAL_CURR_G to get the rate types. A latter Expression transformation called Exp_W_GL_BALANCE_F_Update_Flag then multiplies the retrieved rates by the local amounts to get the global amounts.
So, the custom mapping that loads the exchange rate table should load rates (between local and global currencies) with all the necessary dates for conversion, the correct datasource_num_id and tenant_id. The rate type should then be defined in the DAC parameter(s).
Please see the following section of the configuration guide:-
Please mark if helpful / answered,