Databases Reference
In-Depth Information
•
on database
: Displays all of the variables which are defined on the Database.
Example:
display variable on database 'ESSCAR'.'ESSCAR';
Displaying the Substitution Variable in the
SQL editor
As we have discussed earlier, substitution variables can be used in most of the
Essbase editors or API programming statements.
We would quickly like to demonstrate how we can use the substitution variable
in the Essbase SQL interface. As you know, sometimes you are required to build a
cube only for a particular month and the month may vary depending on the user's
request. Instead of changing the SQL code for every request we can actually create
a
varMonth
variable and pass this variable in the SQL.
To call this variable in the SQL interface, you need to say
&Substitution-variable
(@VarMonth)
as shown:
