Setting Substitution Variables

You can set substitution variables on the Essbase Server at the server, application, or database level. Before setting a substitution variable, see Rules for Setting Substitution Variable Names and Values.

  To set a substitution variable, use a tool:

Tool

Topic

Location

Administration Services

Managing Substitution Variables

Oracle Essbase Administration Services Online Help

MaxL

alter system

alter application

alter database

Oracle Essbase Technical Reference

ESSCMD

CREATEVARIABLE

Oracle Essbase Technical Reference

To ensure that a new substitution variable value is available in formulas, partition definitions, and security filters, stop and restart the application. All other uses of substitution variables are dynamically resolved when used.