On this page you will find the specifications regarding the Model: Revenue Recognition and Dimension Table: X-RATES.
This model dimension contains information on the currency rates for X-rate translation.
Attribute | Description (where applicable) |
CURRENCYRATE | Currency Rate |
CURRENCY_RATE_DATE_ID | Currency Rate Date, first date of period |
CURRENCY_RATE_TYPE_KEY | Rate Type Code |
FROMCURRENCY | From Currency Code |
TOCURRENCY | To Currency Code |
Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
X-RATES | FACT_CURR_RATE_PX_RATE_PQ_BI | FACT_CURR_RATE_PX_RATE_PQ | On Line |