Creates or updates substitution variables at application or cube level.

You cannot use this command to set multiple values and/or functions for substitution variables.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud.

Required Roles

Service Administrator


epmautomate setSubstVars CUBE_NAME SUBSTVAR=VALUE [SUBSTVAR=VALUE] where:
  • CUBE_NAME is the cube (for example, Plan1, Plan2) for which the substitution variable is created or updated. Use All instead of a cube name to set or update substitution variable at the application level.

  • SUBSTVAR is the name of the substitution variable for which a value is to be set or updated.

  • VALUE is the new substitution variable value.


  • Create or update one substitution variable at the application level: epmautomate setSubstVars ALL CurYear=2015 CurPeriod=Jan

  • Create or update substitution variables at cube level: epmautomate setSubstVars Plan2 CurYear=2013 CurPeriod=Jan