Grow by amount template
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. 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.
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.
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.
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.
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 |
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 |
See Also
Concepts
Making a rule more general with #if - #else
Parameters (PEL)
About the Scenario dimension
About the Time dimension