Substitution Variables

Substitution variables define global variables that represent Essbase-specific values. For example, CurMonth can be a substitution variable for displaying the latest time period. Rather than constantly updating queries when a value changes, you change only the value for the substitution variable on the server. Essbase creates substitution variables, but you can specify a substitution variable when selecting members.

  To add a substitution variable:

  1. Select a member in the data layout and select Edit on the shortcut menu.

    The Member Selection dialog box is displayed.

  2. Select Browse.

  3. In the Available pane click + to expand the Substitution Variable node.

  4. To include a substitution variable, select the member in the Available pane and click Include icon.

  5. To include a dynamic function on a substitution variable, on the shortcut menu, select the member in the Available pane and select the desired function from the sub-menu:

    • Member

    • Children

    • Descendants

    • Bottom

    • Siblings

    • Same Level

    • Same Generation

    • Select Next/Previous

    • Subsets

  6. Click OK.