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 |
| ENDOFMONTH | Last date of period |
| FROMCURRENCY | From Currency Code |
| PREV_YEAR_LAST_PERIOD_RATE | Rate in last period previous year |
| TOCURRENCY | To Currency Code |
| Model Name |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| X-RATES | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |