Example: ICE for equity template in Planning Business Modeler

The default ICE for Equity template selects accounts of type Equity or type BS-Net Income.

Note: ICMethod of #Default# indicates either of two possible situations: The corresponding Intercompany dimension member is NONE, or the Intercompany dimension member is an Entity with a consolidation method of DEFAULT.

The following example shows the ICE for Equity rule template.

/* Outer SCOPE selects Equity and BS-Net Income accounts
For subsidiaries where there are no IC partners. */
SCOPE (METHOD(#Full#), ICMETHOD(#Default#), [Account].TypeFilterInclude("Equity", "BS-Net income"));
/* First inner SCOPE includes prior year Flows */
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
/* Placeholders */
<<[Account].[All Members].[Minority Equity]>> += PMIN_1 * CURRENTTUPLE;
<<[Account].[All Members].[Equity Clearing]>> += POWN_1 * CURRENTTUPLE;
END SCOPE;
/* Next inner SCOPE excludes PY ADJ.
Note: This scope includes all Flow EXCEPT prior year */
SCOPE [Flow].TypeFilterExclude("PY Adj", "FXO");
() -= PCON * CURRENTTUPLE;
/* Placeholders */
<<[Account].[All Members].[Minority Equity]>> += PMIN * CURRENTTUPLE;
<<[Account].[All Members].[Equity Clearing]>> += POWN * CURRENTTUPLE;
END SCOPE;
/* end outer scope */
END SCOPE;

The following example shows how this rule might appear when the placeholders are filled with actual account values.

/* Outer SCOPE */
SCOPE (METHOD(#Full#), ICMETHOD(#Default#),[Account].TypeFilterInclude("Equity", "BS-Net income"));
/* Inner scope for PY ADJ */
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
/* Actual account values */
[Account].[SummaryAcct].[350101] += PMIN_1 * CURRENTTUPLE;
[Account].[SummaryAcct].[399999] += POWN_1 * CURRENTTUPLE;
END SCOPE;
/* Inner scope for everything other than PY ADJ and FXO */
SCOPE [Flow].TypeFilterExclude("PY Adj", "FXO");
() -= PCON * CURRENTTUPLE;
/* Actual account values */
[Account].[SummaryAcct].[350101] += PMIN * CURRENTTUPLE;
[Account].[SummaryAcct].[399999] += POWN * CURRENTTUPLE;
END SCOPE;
/* End outer SCOPE */
END SCOPE;

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!

×