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.
A substitution variable can be used in a query or calculation script to represent a member in the outline. By default, there are no substitution variables defined for a cube.
There is not an option to add substitution variables in the Designer Panel, however you can add them directly in the application workbook.
- On the Cube.Settings worksheet, in the Substitution Variables section, create a new row.
- Enter the variable name in column A and its value in column B, enclosing the value in quotation marks if it represents a member name.
See Using Substitution Variables in Designing and Maintaining Essbase Cubes.