ICE for equity template in Planning Business Modeler

When you complete the ICE for Equity template with appropriate account information, this rule eliminates equity that a holding company has in its consolidated subsidiaries.

This rule selects members that have account types Equity and BS-Net Income. Because these account types do not allow for intercompany (IC) transactions, no IC partners are selected for rule application. For more information about Account types, see the topic About the Account dimension.

Note:  When a rule eliminates a transaction value, the consolidation process removes a transaction from the aggregated total and makes a corresponding adjustment to the Elimination member of the Business Process dimension. For more information, see the topic About the Business Process dimension.

For examples that show more about how to customize this template, see the topic Examples: Consolidation Rule template modifications.

For information about how PerformancePoint Planning Business Modeler determines values for percent consolidation (PCON), see About financial model measure groups for consolidation.

In this topic

Prerequisites

Placeholder substitution requirements

Prerequisites

The following list shows the tasks that are prerequisite for a rule that you create with this template:

Top of Page

Placeholder substitution requirements

To use the ICE for Equity template to make a business rule, you must substitute actual account values for the placeholders in the template. For information about how to substitute values, see the topic Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make for IC transactions of this kind. In addition, the table describes the adjustments that this rule performs when these values are supplied.

If Flow member for cell has Flow type

Placeholder substitutions required

Rule action

Prior year adjustment (PY Adj)

  • Equity Clearing account

  • Minority Equity account

  • Eliminates the equity transaction by multiplying the value by percent consolidation (PCON) for the prior year

  • Multiplies the transaction value by percent ownership for prior year (POWN_1), and posts the result in the Equity Clearing account

  • Multiplies the transaction value by minority interest for the prior year (PMIN_1), and posts the result in the Minority Equity account

Other than PY Adj or FXO

  • Equity Clearing account

  • Minority Equity account

  • Eliminates the equity transaction by multiplying the value by percent consolidation (PCON)

  • Multiplies the transaction value by percent ownership (POWN), and posts the result in the Equity Clearing account

  • Multiplies the transaction value by minority interest (PMIN), and posts the result in the Minority Equity account

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!

×