About the Exchange Rate dimension
The Exchange Rate dimension is a flat dimension that stores values of exchange rates that are used by an Exchange Rate Assumptions model. In addition, this dimension might be used by currency conversion calculations.
Dimension members
The Exchange Rate dimension has a single member property, ExchangeRateTypeID, with multiple attributes. The attributes specify how the exchange rate is to be calculated.
The following table describes the possible values for ExchangeRateTypeID.
| Exchange rate type | Label | Description |
|---|---|---|
Average |
AVE |
Average exchange rate for the period |
Budget |
BUD |
Budget exchange rate for company internal reporting |
Closing |
CLO |
Closing exchange rate for the last period |
Historical |
HIST |
Historical exchange rate that existed when a transaction occurred, if it differs from the current exchange rate |
No member |
NONE |
No exchange rate member |
Opening |
OPE |
Opening exchange rate for the current period |
Prior Average |
PRIORAVE |
Prior year average exchange rate that will be used for accounts that have Flow type PY Adj or Opening |
User modifications in the Exchange Rate dimension
In the Exchange Rate dimension, users have some limits on their ability to modify or structure the predefined dimension members and other member sets.
Note
You cannot create a member hierarchy in the Exchange Rate dimension.
The following table describes the ways you can control and manage objects in this dimension.
| Object | Create | Update | Delete |
|---|---|---|---|
Dimension Properties |
No |
Yes |
No |
Dimension Members |
Yes |
Yes |
Yes |
Member Sets |
Yes |
Yes |
Yes |
Member Views |
No |
No |
No |
Member Properties |
Yes |
Yes |
No |