Model: Group Reporting - Specifications for Dimension Table: X-RATES 2

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.

Attributes

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

USED BY MODEL(S)

Model Name

General Ledger

Data source Information

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