Display Variable
The MaxL display variable statement helps you view a list of Essbase substitution variables defined on the server.
Syntax
![Description of dispvarb.gif follows Description of dispvarb.gif follows](img/dispvarb.gif)
Description of the illustration dispvarb.gif
You can display substitution variables in the following ways using display variable.
Keywords
- all
-
Display all substitution variables defined on the Essbase Server, including those associated with applications and databases.
- <variable-name>
-
Display a substitution variable by name.
Permission required:
-
Read access for the applicable database or application.
-
Administrator for system-defined variables.
-
- on application
-
Display only substitution variables defined on the specified application.
Permission required: Read access for the application.
- on database
-
Display only substitution variables defined on the specified database.
Permission required: Read access for the database.
- on system
-
Display only the substitution variables associated with the Essbase Server.
Permission required: Administrator.
Notes
To manage substitution variables, use alter database (containing add, drop, and set variable).
Example
display variable;
Displays a list of all substitution variables on the Essbase Server.