Display Variable
View a list of substitution variables defined on the system.
Syntax
You can display substitution variables in the following ways using display variable.
| Keyword | Description |
|---|---|
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 susbstitution variables on the Essbase Server.