PEL consolidation shares functions

Consolidation 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.

In addition, currency exchange is an important part of a consolidation operation. Before Planning Business Modeler performs any consolidation of entities, it first converts all currencies to a single exchange.

Consolidation functions can be used only in consolidation rules. If you use one of these functions in any other type of rule, it will cause a compiler error.

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

Reference

  • IPCON (PEL)
    Returns the percent of consolidation for the intercompany partner.
  • IPCON_1 (PEL)
    Returns the percent of consolidation for the intercompany partner from the prior year.
  • IPMIN (PEL)
    Returns the minority interest for the intercompany partner.
  • IPMIN_1 (PEL)
    Returns the minority interest for the intercompany partner from the prior year.
  • IPOWN (PEL)
    Returns the ultimate percent of shares owned by an intercompany partner on another partner.
  • IPOWN_1 (PEL)
    Returns the ultimate percent of shares owned by an intercompany partner on another partner for the preceding year.
  • MIN_PCON_1_IPCON_1 (PEL)
    Determines the minimum value of the difference between percent of consolidation and percent of intercompany consolidation for the preceding year.
  • MIN_PCON_IPCON (PEL)
    Determines the minimum value of the difference between percent of consolidation and percent of intercompany consolidation.
  • PCON (PEL)
    Consolidation rule function that returns the percent of consolidation for a company.
  • PCON_1 (PEL)
    Consolidation rule function that returns the percent of consolidation for a company for the prior year.
  • PMIN (PEL)
    Consolidation rule function that returns the percent of minority interest.
  • PMIN_1 (PEL)
    Consolidation rule function that returns the percent of minority interest during the prior year.
  • POWN (PEL)
    Consolidation rule function that returns the ultimate percent of shares owned by a company on another. The percent ownership is calculated by the shares engine.
  • POWN_1 (PEL)
    Consolidation rule function that returns the prior year ultimate percent of shares owned by a company on another. The percent ownership is calculated by the shares engine.
  • VAR_MIN_PCON_IPCON_MIN_PCON_1_IPCON_1 (PEL)
    Determines the difference between the following two values:

    • The minimum value of the difference between ultimate percent of consolidation and ultimate percent of consolidation for the intercompany partner

    • The minimum value of the difference between prior period ultimate percent of consolidation and prior period ultimate percent of consolidation for the intercompany partner

  • VAR_PCON (PEL)
    Determines the difference between the ultimate percent of consolidation for the current year and the ultimate percent of consolidation for the prior period.
  • VAR_PMIN (PEL)
    Determines the difference between the percent of minority interest for the current year and the percent of minority interest for the prior year.
  • VAR_POWN (PEL)
    Determines the difference between the current period ultimate percent of ownership and the prior period ultimate percent of ownership.