VAR

The VAR calculation command for Essbase declares a temporary variable that contains a single value. The variable lasts for the scope of the calculation script.

You can also use a single VAR command to declare multiple variables by supplying a comma-delimited list of variable names.

Syntax

VAR varName [= value] ;

Parameters

varName: Name of the temporary variable.
value: Optional parameter that declares the data value.

Notes

The name of the variable cannot duplicate a database member name.
If a value is not declared, it is set to #MISSING.
VAR commands can only be assigned values within a member calculation or when VAR is declared.

Example

VAR Target = 1200;

VAR Break1, Break2, Break3;