About the Exchange Rate dimension in Planning Business Modeler

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

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×