On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: X-RATES 2.
Contains the different available rates to calculate X-RATE 2 measures, conversion is done from one currency to another.
| Attribute | Description (where applicable) |
| FROMCURRENCY | From currency code |
| TOCURRENCY | To currency code |
| CURRENCY_RATE_TYPE_KEY | Currency Rate Type ID |
| CURRENCY_RATE_DATE_ID | Currency rate start date |
| ENDOFMONTH | Last date of period |
| CURRENCYRATE | The currency rate |
| PREV_YEAR_LAST_PERIOD_RATE | Rate in last period previous year |
| Model Name |
| General Ledger |
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 2 | N/A | N/A |