Every record/row of the data mart a Datamart can be in a different currency. When querying the Datamart data of the data mart (either by call of calling a Groovy API function or indirectly via built-in charts), you would like want to get the aggregated data in a single currency, so that the money summarizations are meaningful.
When you query the data, there will be an automatic conversion of money fields to the target/requested currency. If you do not request the target currency explicitly, it will use the base currency set for the data martDatamart.
The exchange rates are looked up at query time, meaning there is no need to refresh any the Datamart after updating exchange rates.
To make the conversion work, you need to follow the next sections downherefollow these steps.
Set up
properly fields of data martDatamart Fields
Pricing Date - one – One Date field must be marked as the Pricing Date function. This date will be used to lookup proper look up the right currency conversion in the ccy data source Data Source.
Currency - one – One field must be of the type Currency - this . This field denotes in which the currency are of all the money values in the record. This currency value will be used to lookup look up the ccyFrom field of the ccy data source Data Source when looking up the conversion rate.
Base Currency - when – When querying the data, you can either specify the target currency, and if you do not, then the query result will be in the Base Currency specified of for the data martDatamart.
Upload
dataData to
theccy
data sourceData Source
You must upload data to the data source ccy Data Source. The currency conversions could can be specified either per day , or per date range. If you specify a date range, then in the data you upload you still specify only the Valid From. The Valid to date will be automatically derived from the uploaded data right after the upload.
You must provide all combinations from of Ccy From, Ccy To and Ccy Valid From.
Ccy From - you – You need to provide all currency symbols , which you’re using you use in your data and which you will upload to the system.
Ccy To - you – You need to provide all currency symbols , which you would like your users to be able to use in the built-in charts or in the Datamart queries to data mart.
Ccy Valid From - the – The first date of the validity of the conversion rate.
Ccy Valid To - the – The date of a day right after the last dat date of the validity period (i.e. this date does not belong to the validity period). I.e. the exchange rate is applied to the CcyValidFrom date, as well as any date before CcyValidTo. Note , that this value is automatically derived from the other records. So do not supply this value for the upload.
See description To see descriptions of all fields on page , go to Data Source "ccy" - Currency Conversion.
Configure
daily conversion optimizationDaily Conversion Optimization
If you’re using you use exchange rates changing which change every day, set up the Daily daily conversion optimization.