Managing Substitution Variables

Substitution variables act as global placeholders for information that changes regularly. You create the variable and a corresponding string value, and the value can then be changed at any time. You can specify whether the substitution variable applies to an entire Essbase Server, an application, or a database.

You can create variables directly from the right-click menu on the Variables node, or in the Substitution Variables dialog box.

Note:

When creating substitution variables using single quotes, precede the single quote with a forward slash. If you do not do this, the single quotes will be discarded.

  To manage a substitution variable:

  1. From Enterprise View or a custom view, select an Essbase Server.

  2. Right-click and select Edit, then Variables.

  3. In Substitution Variables, select the application and database to which the variable should apply.

  4. Specify or edit the variable name and value.

  5. Click Set to apply the settings.

  6. Stop and restart the application to make the new value available in outline formulas, partition definitions, and security filters.

  7. To delete a variable, select the row containing the variable you want to delete, and click Delete.

Related Information

Related Commands