UPDATEVARIABLE

Updates the variable value that corresponds to the specified substitution variable.

Syntax

UPDATEVARIABLE variableName [serverName [appName [dbName]]] value

Parameter	Description
variableName	The name of the existing substitution variable.
serverName	Optional. Host name of the Essbase Server to which the variable is applied.
appName	Optional. Name of the application to which the variable is applied. If appName is not used, in a script, empty quotes must be used to take its place. ("")
dbName	Optional. Name of the database to which the variable is applied. If dbName is not used, in a script, empty quotes must be used to take its place. ("")
value	The new string value that corresponds to the substitution variable. The name must be alphanumeric, and can be a maximum of 255 characters. You can have a null value, but do not use a leading & character in the value.

Example

The following command in an ESSCMD script updates a substitution variable named CurQtr to have a value of Qtr2.

UPDATEVARIABLE "CurQtr" "Bamboo" "Sample" "Basic" "Qtr2";

The following ESSCMD script updates a substitution variable named CurQtr to have a value of Qtr3. Application and database input is left blank because the variable is system-wide; however, the empty quotation marks are still required as placeholders.

login "Aspen" "fiona" "sunflower";
UPDATEVARIABLE "CurQtr" "aspen" "" "" "Qtr3";

Another script that updates an Essbase Server substitution variable:

OUTPUT 1 "subvar_serv.log";
LOGIN "localhost" "system" "password";
UPDATEVARIABLE "GlobalVar" "" "" "" "Myserver";
exit;

Script that updates an application substitution variable:

OUTPUT 1 "subvar_app.log";
LOGIN "localhost" "system" "password";
UPDATEVARIABLE "AppVar" "localhost" "Sample" "" "MyApp";
exit;

Script that updates a database substitution variable:

OUTPUT 1 "subvar_db.log";
LOGIN "localhost" "system" "password";
UPDATEVARIABLE "DBVar" "localhost" "Sample" "Basic" "MyDB";
exit;