UPDATEVARIABLE

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

Syntax

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

variableName The name of the existing substitution variable.
serverName Optional. Host name of the Analytic 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.

Examples

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 Analytic 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;

See Also

LISTVARIABLES
UPDATEVARIABLE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com