PEL currency conversion functions

Currency functions have special characteristics in PerformancePoint Expression Language (PEL). These functions are data-driven; that is, the precise operation of the function varies according to the dimensional data to which the function is applied. In particular, the Flow dimension affects the way each function is computed.

Currency functions can be used only in currency rules. If you use one of these functions in any other type of rule, the compiler will issue an error.

The following table describes the functions that are specific to currency rules.

Reference

  • AVE (PEL)
    Returns the average exchange rate between the source currency and the currency to which it is being converted.
  • CLO (PEL)
    Returns the closing exchange rate between the source currency and the currency to which it is being converted.
  • CLOAVE (PEL)
    Returns the difference between the closing exchange rate and the average exchange rate. That is, returns (closing rate - average rate).
  • CLOAVEPRIOR (PEL)
    Returns the difference between the closing exchange rate and the prior average exchange rate. That is, returns (closing rate - prior average rate).
  • HIST (PEL)
    Returns the historical exchange rate between the source currency and the currency to which it is being converted.
  • OPE (PEL)
    Returns the opening exchange rate between the source currency and the destination currency.
  • 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, returns (prior rate - average rate).
  • 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.