Using currency conversion functions to select exchange rate in Planning Business Modeler

PerformancePoint Planning Business Modeler includes a set of Microsoft Office PerformancePoint Expression Language (PEL) currency conversion functions that enable you to use a variety of exchange rates in a Currency rule. These functions depend on an existing model-to-model association between a financial model and an Exchange Rate assumption model. Currency conversion functions may only be used in a Currency rule.

To change a particular exchange rate for a particular account type or flow type, substitute the currency conversion function that returns the exchange rate that you want to use.

For example, the following snippet from the Currency Rule template uses the AVE (PEL) function to convert Income Statement currency values. For more information, see AVE (PEL).

SCOPE ([Account].ClassificationFilterInclude("Income statement", "Non financial"));
() += AVE * CURRENTTUPLE;
END SCOPE;

The next example changes the rule segment so that the currency calculation uses HIST (PEL), the historical exchange rate. For more information, see HIST (PEL).

SCOPE ([Account].ClassificationFilterInclude("Income statement", "Non financial"));
() += HIST * CURRENTTUPLE;
END SCOPE;

Currency conversion functions

The following table describes the currency conversion functions that are included with Planning Business Modeler.

Function

Description

AVE (PEL)

Returns the average exchange rate between the source currency and the currency to which it is being converted.

For more information, see AVE (PEL).

CLO (PEL)

Returns the closing exchange rate between the source currency and the currency to which it is being converted.

For more information, see CLO (PEL).

CLOAVE (PEL)

Returns the difference between the closing exchange rate and the average exchange rate. That is, it returns (closing rate - average rate).

For more information, see CLOAVE (PEL).

CLOAVEPRIOR (PEL)

Returns the difference between the closing exchange rate and the prior average exchange rate. That is, it returns (closing rate - prior average rate).

For more information, see CLOAVEPRIOR (PEL).

HIST (PEL)

Returns the historical exchange rate between the source currency and the currency to which it is being converted.

For more information, see HIST (PEL).

OPE (PEL)

Returns the opening exchange rate between the source currency and destination currency.

For more information, see OPE (PEL).

PRIORAVE (PEL)

Returns the difference between the prior exchange rate and the average exchange rate, as applied to the data types of the specified model. That is, it returns (prior rate - average rate).

For more information, see PRIORAVE (PEL).

VAROPE (PEL)

Returns the difference between the opening exchange rate and the prior exchange rate, as it applies to the data types of the specified model.

For more information, see VAROPE (PEL).

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!

×