Example: ICE for investments template in Planning Business Modeler

The following code snippet shows a placeholder segment from the ICE for Investments template.

/* Outer SCOPE selects investment accounts in holding companies */
SCOPE (METHOD(#Holding#), [Account].TypeFilterInclude("Investment") );
/* First level inner SCOPE selects IC partners
who are subsiaries or holding companies */
SCOPE ICMETHOD(#Holding#,#Full#);
/* Inner SCOPE includes values in prior year Flow */
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
/* Placeholder */
<<[Account].[All Members].[Equity Clearing]>> += POWN_1 * CURRENTTUPLE;
END SCOPE;
/* Inner SCOPE excludes values in prior year Flow */
/* Note this includes all values except those in PY ADJ */
SCOPE [Flow].TypeFilterExclude("PY Adj");
() -= PCON * CURRENTTUPLE;
/* Placeholders */
<<[Account].[All Members].[ Equity Clearing]>> += POWN * CURRENTTUPLE;
END SCOPE;
END SCOPE; /* End first-level inner scope */
END SCOPE /* End outer scope */

The following example is taken from the Alpine Ski House sample application that is included with PerformancePoint Planning Server. The example shows how the previous segment might be changed into a usable rule. Note that the example substitutes specific account members for the replacement string values.

/* Outermost SCOPE selects investment accounts in holding companies */
SCOPE (METHOD(#Holding#), [Account].TypeFilterInclude("Investment"));
/* Mid-level SCOPE selects IC partners
who are subsiaries or holding companies */
SCOPE ICMETHOD(#Holding#,#Full#);
/* Inner SCOPE includes values in prior year Flow */
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON_1 * CURRENTTUPLE;
/* Substitute actual account value for placeholder */
[Account].[SummaryAcct].[399999] -= POWN_1 * CURRENTTUPLE;
END SCOPE;
/* Inner SCOPE excludes values in prior year Flow */
/* Note this includes all values except those in PY ADJ */
SCOPE [Flow].TypeFilterExclude("PY Adj");
() -= PCON * CURRENTTUPLE;
/* Substitute actual account value for placeholder */
[Account].[SummaryAcct].[399999] -= POWN * CURRENTTUPLE;
END SCOPE; /* End inner scope */
END SCOPE; /* end mid-level scope */
/* Mid-level SCOPE selects transactions where parent
Has equity control of IC partner */
SCOPE ICMETHOD(#Equity#);
/* Inner SCOPE includes values in prior year Flow */
SCOPE [Flow].TypeFilterInclude("PY Adj");
() -= PCON * CURRENTTUPLE;
/* Substitute actual account value for placeholder */
[Account].[SummaryAcct].[120100] += PCON_1 * CURRENTTUPLE;
END SCOPE;
/* Inner SCOPE excludes values in prior year Flow */
/* Note this includes all values except those in PY ADJ */
SCOPE [Flow].TypeFilterExclude("PY Adj");
() -= PCON * CURRENTTUPLE;
/* Substitute actual account value for placeholder */
[Account].[SummaryAcct].[120100] += PCON * CURRENTTUPLE;
END SCOPE; /* end PY ADJ exclude */
END SCOPE; /* End mid-level scope statement*/
END SCOPE; /* End outer 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!

×