setSubstVars
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, Sales Planning, and Strategic Workforce Planning.Required Roles
Service AdministratorUsage
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. UseAll
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.
Examples
-
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