Understand the Cube.Settings Worksheet: 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.

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.

  1. On the Cube.Settings worksheet, in the Substitution Variables section, create a new row.
  2. 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.


    CurrMonth "Jan"

See Using Substitution Variables.