Using Substitution Variables with Some Enterprise Profitability and Cost Management Commands

Enterprise Profitability and Cost Management jobs support substitution variables as job parameters. You can use substitution variables, which are resolved when EPM Automate runs these jobs as a part of the command execution.

The jobs used for running these commands support substitution variables:

Substitution variable are supported for all parameters (required and optional) used with these commands.

Specifying Substitution Variables with Commands

To use a substitution variable with a command, start the parameter value with the & (ampersand) character. For example, in the following calculateModel sample command, you can the substitution variables &currYear and &execType in place of the actual values FY22 and :ALL_RULES.

  • Sample command without substitution variables:epmautomate calculateModel FY22::Jan::Actual::Working "10 Actuals Allocation Process" ALL_RULES clearCalculatedData=true executeCalculations=true optimizeForReporting=true comment="Running all rules to calculate a POV"
  • Sample command with substitution variables:epmautomate calculateModel &currYear::Jan::Actual::Working "10 Actuals Allocation Process" &execType clearCalculatedData=true executeCalculations=true optimizeForReporting=true comment="Running all rules to calculate a POV"

Note:

  • Only the parameter values that start with the & (ampersand) character are treated as substitution variables.
  • The substitution variable must exist in Enterprise Profitability and Cost Management. Commands will fail if you pass a substitution variable that does not exist or is misspelled.