Using Substitution Variables in User Requests

Enterprise Profitability and Cost Management supports substitution variables in following PCM Agent commands:

  • Clear POV
  • Copy POV
  • Delete POV
  • Calculate Model

When you use substitution variables, you can save the user request containing the substitution variable as a job to use later. These substitution variables are resolved for the POV at runtime, and the job executes accordingly.

For example, if you wanted to run a calculation job every month, you could use a substitution variable like &currPeriod and configure its value in the user interface. In subsequent months, you would not need to update the saved job’s POV parameters, or any automation processes, as long as you update the substitution variable.

When using substitution variables, keep in mind the following:

  • The substitution variable should start with &.

  • If it does not start with &, it will be treated as a regular parameter.

  • If the substitution variable does not exist or an invalid name is passed, the job fails with an error.

Sample user requests with substitution variables:

Calculate Model &Model povs &CurrYear::&CurrMonth::Actual::Working

Copy pov source pov '&CurrYear::&SourceMonth::Actual::Working' destination pov '&DestYear::&DestMonth::Actual::Working' pov delimiter '::' copy type 'INPUT' create destination pov 'true' source cube 'PCM_CLC' destination cube 'PCM_REP'

clear point of view &DestYear:&DestMonth:Actual:Working cube PCM_CLC clear input true clear allocated true clear adjustment true and save job as 'Clear FY16 Mar POV'

Delete POV &CurrYear::&DelPovMonth::Actual::Working pov delimiter '::'

Note:

To define substitution variables:

  • From the Home page, select Tools, and then Variables.

  • On the Variables page, click Substitution Variables.

    Substitution Variables tab