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 |