Display Variable
The MaxL display variable statement helps you view a list of Essbase substitution variables defined on the server.
Keywords
You can display substitution variables in the following ways using MaxL display variable.
- display variable [all]
-
Display all substitution variables defined on the Essbase Server, including those associated with applications and databases.
Example:
display variable; - display variable VARIABLE-NAME
-
Display a substitution variable by name.
The minimum permission required to display variables is:
-
Read access, to display variables associated with the specified database or application.
-
Administrator, to display system-defined variables.
Example:
display variable Sample.curmonth; -
- display variable on application APP-NAME
-
Display only substitution variables defined on the specified application.
The minimum permission required to run this statement is Read access for the specified application.
Example:
display variable on application Sample; - display variable on database DBS-NAME
-
Display only substitution variables defined on the specified database.
The minimum permission required to run this statement is Read access for the specified database.
Example:
display variable on database CalcTuple.Tuple; - display variable on system
-
Display only the substitution variables associated with the Essbase Server.
The permission required to run this statement is Administrator.
Example:
display variable on system;
Notes
To create and manage substitution variables, use MaxL alter database (containing add, drop, and set variable).