Example: ICE for profit and loss template in Planning Business Modeler

The following code snippet shows a placeholder segment from the ICE for Profit and Loss template. This segment works with Income accounts.

/* Outer SCOPE selects Income accounts */
SCOPE [Account].TypeFilterInclude("Income");
/* Inner SCOPE selects IC partners */
SCOPE ICMETHOD(#Default#);
/* Placeholders */
<<[Account].[All Members].[Minority Interest Income]>> -= PMIN * CURRENTTUPLE;
<<[Account].[All Members].[Net Income]>> -= PMIN * CURRENTTUPLE;
<<[Account].[All Members].[Minority Equity]>> += PMIN * CURRENTTUPLE;
END SCOPE; /* end inner scope*/
END SCOPE; /* end outer scope*/

The following example shows a completed version of this template segment. This example uses only one placeholder. Other placeholders are deleted.

/* No change from template: outer SCOPE selects Income accounts */
SCOPE [Account].TypeFilterInclude("Income");
/* No change from template: inner SCOPE selects IC partners */
SCOPE ICMETHOD(#Default#);
/* Substitute actual account number for Minority Interest Income placeholder*/
/* Delete other template placeholders because unused*/
[Account].[SummaryAcct].[700101] += PMIN * CURRENTTUPLE;
END 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!

×