Data source types: Essbase, Planning, Oracle Planning and Budgeting Cloud Service
Substitution variables are global placeholders that represent variable values. The designation “&CurMnth” might be a substitution variable representing the current month. Application designers or administrators define and manage substitution variables and their corresponding values; Smart View users can enter a substitution variable into the grid and retrieve its value by refreshing.
For example, say the value for substitution variable “&CurMnth” is August. When you enter &CurMnth into a grid, Smart View displays August after a refresh. Later, if the value is changed to September, then September is displayed after a refresh when you enter &CurMnth.
For more complete information about substitution variables, see the Essbase and Planning documentation, available in the EPM Documentation Library. To open this library, from the Smart View ribbon, select the arrow next to Help, and then select EPM Documentation.
To retrieve the value for a substitution variable:
Enter a substitution variable into a cell in the grid.
Note:
Substitution variable names must begin with an ampersand (&).
From any ribbon, select Refresh.
The current value defined for substitution variable replaces the substitution variable in the cell (and for all cells in the current worksheet that contain &CurMnth).