Using Substitution Variables in Scripts

You can use substitution variables in calculation and report scripts. Typically, you use substitution variables to reference information that changes frequently.

You create substitution variables in the Substitution Variables window. When you execute scripts that include substitution variables, Essbase replaces each variable with the value that is specified in the variable definition.

  To use substitution variables in calculation or report scripts:

  1. Open or create a script.

  2. Click where you want to insert a substitution variable.

  3. Type an ampersand (&) followed by the substitution variable name (for example, &CurQtr).

  4. Save and execute the script.

    Essbase replaces the substitution variable with the value that you specified in the substitution variable definition.

Related Information