To create and use substitution variables:
Using the instructions in the Oracle Essbase Administration Services Online Help, create the substitution variable.
As you edit the rule file, open the SQL data source by selecting File, then Open SQL.
See the Oracle Essbase Administration Services Online Help.
In the Open SQL Data Sources dialog box, perform an action:
To specify a substitution variable for the DSN, select Substitution Variables, and select a substitution variable.
To specify a substitution variable in the query, in Select, From, or Where, enter the substitution variable (with its preceding ampersand), instead of a “field=value” string.