Creating and Using Substitution Variables

  To create and use substitution variables:

  1. Using the instructions in the Oracle Essbase Administration Services Online Help, create the substitution variable.

  2. 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.

  3. 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.

  4. Click OK/Retrieve to retrieve the data for the rules file.

    Note:

    You must set the values for the substitution variables before you use the rules file for a data load or dimension build.