Grow by amount template in Planning Business Modeler

The rule that you can create by using the GrowAmount template increases data values across time by a fixed amount. The rule calculates the account value for each period as the amount for the previous period plus the growth amount. You can use a rule that you create with the GrowAmount template to populate a new scenario or to modify data in a budget or forecast scenario.

To create a business rule from the GrowAmount template, you must provide not only values to substitute for template placeholders, but also values for input parameters. For specific information about placeholders, see the Placeholder Substitution Requirements section of this topic. PerformancePoint Planning Business Modeler displays prompts for input parameters when the rule runs. For specific information about input parameters, see the Input Parameter Requirements section of this topic.

In this topic

Prerequisites

Implementation

Placeholder substitution requirements

Input parameter requirements

Prerequisites

The following is a prerequisite for a rule that you create with this template.

  • Be sure that the SCOPE statement that your rule uses includes the appropriate application dimensions.

Top of Page

Implementation

A GrowAmount rule has MdxQuery implementation. You can run a GrowAmount rule directly from Planning Business Modeler, or include this rule as a part of a user-specified job. For more information, see MdxQuery implementation.

Note:  To get the best possible performance with MdxQuery implementation, restrict the resultant dataset that you define in the SCOPE statement to only the members required.

Top of Page

Placeholder substitution requirements

To convert the GrowAmount template into a business rule, you must substitute actual dimension values for the placeholders in the template. For information about how to substitute values, see Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make to create a GrowAmount business rule from this template.

Placeholder

Comment

<<[Scenario].[Hierarchy]. [Target_Scenario]>>

Destination scenario for calculated growth values

<<[TimeHier]>>

Period for which the percentage growth rate should be applied

Top of Page

Input parameter requirements

The following table shows the values that Planning Business Modeler prompts you to input at run time every time that you run the GrowAmount rule.

Name

Type

Comment

Time

One or more periods from the Time dimension

The periods for which the growth rate is applied

Account

One or more members of the Account dimension

The accounts to change

Entity

One or more members of the Entity dimension

The entities to change

Growth Amount

Decimal

The fixed growth amount, expressed as a decimal number

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!

×