Substitution Variables

Data source types: Essbase, Planning

Essbase substitution variables can be used in Smart View spreadsheets. Substitution variables are global placeholders for variable values, and are defined and managed by the administrator. When you enter a substitution variable name in a grid, the current value as defined by the administrator is displayed after the grid is refreshed.

For example, suppose the substitution variable “&currentmonth” represents the current month, and the current month is October. Any cell in the grid that contains “&currentmonth” will display “October” after refresh. When the administrator updates “&currentmonth” to “November”, then November will be displayed after the grid is refreshed.