How to use Essbase substitution variables in Smart View

In a spreadsheet you can  refer to a member name with a Substitution Variable simply adding an ampersand before the variable name, directly in the Excel worksheet. For example if you have the current month name stored in the “CurrentMonth” variable, you can directly replace the member name in the worksheet with &CurrentMonth:

After refreshing worksheet the CurrentMonth variable will be replaced with the member name. Tested on EPM version 11.1.2.