Using Substitution Variables

Using substitution variables in SQL strings and data source names enables you to use one rules file for multiple data sources. One substitution variable can apply to all applications and databases on an Essbase server or to a particular application or database.

You can also define substitution variables for data source names (DSNs) and specify in the rules file the substitution variable names.