Exchange Rate Dimension Properties

Table, Description, To Currency, From Currency, Method, Historical, Beg Balance, Year, Period, Average, Ending

Table 5-14 Exchange Rate Dimension Properties

Column Header in Load File	Oracle Hyperion Planning Property	Value	Default	Required
Table	fxTblId	Name of the exchange rates table	None	Yes
Description	Description	Description of the exchange rates table	None	No
To Currency	toCur	Currency defined in the application, to which the conversion will be applied	None	Yes
From Currency	fromCur	Currency defined in the application, from which the conversion will be computed	None	Yes
Operation	N/A	update (delete operations are not supported: delete level 0, delete idescendants, delete descendants)	update	No
Method	method	multiply; divide	multiply	No
Historical	historicalRate	numeric value	0	No
Beg Balance	begBalanceRate	numeric value	0	No
Year	yearId	A year defined in the application, such as FY08	None	Yes, if Average or Ending is specified
Period	tpId	A base time period defined in the application, such as Jan	None	Yes, if Average or Ending is specified
Average	avgVal	numeric value	None	No
Ending	endVal	numeric value	None	No