& (ampersand)

The & calculation command for Essbase prefaces a substitution variable in a calculation script.

Syntax

&variableName;

Parameters

variableName

The name of the substitution variable set on the database.

Notes

Essbase treats strings beginning with & as substitution variables, replacing them with values before parsing the calculation script.

Example

&CurQtr;

becomes

Qtr1;

if substitution variable &CurQtr has the value "Qtr1".