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;
See Also