FACT - REPORTING CURRENCY RATES

This cube fact represents currency rates primarily used to calculate amounts in reporting currency. It is based on the core fact FACT_CURRENCY_RATES that is in the ETL process is used as source to create a new fact called FACT_REPORTING_CURRENCY_RATES. In order to retrieve rates for different base currencies it is necessary to set up a reference rate type. This is done in the specific ETL table LookupReportingCurrencyRateType. It is only possible to select one rate type in one company with the purpose to get one single rate table to find the currency rates related to reporting currency.

The ETL step will add the reference currency related to the defined currency rate type and there will also be a calculation of an adjusted rate that takes into account the conversion factor and if the rates are using inverted quotation or not. The adjusted rate can be used directly to as <base_amount> * <adjusted rate> = <reporting_currency_amount>.

In the ETL process the FACT_CURRENCY_RATES together with core dimension DIM_BI_TIME are used to create the fact FACT_REPORTING_CURRENCY_RATES that displays rate information per date. This fact is used by the cubes to handle reporting currency calculations.

USED BY CUBE

ETL Information

ATTRIBUTES