Essbase - Substitution variables

About

Substitution variables are global placeholders for regularly changing information. Because changes to a variable value are reflected everywhere the variable is used, manual changes are reduced.

Articles Related

Example

For example, many reports depend on reporting periods, if you generate a report based on the current month, you must update the report script manually every month. With a substitution variable, such as CurMnth, set on the server, you can change the assigned value each month to the appropriate time period. When you use the variable name in a Report Script, the information is dynamically updated when you run the final report.

Where

You can use substitution variables with both Essbase - Aggregate Storage and block storage applications in the following areas:

• Aggregate storage outline formulas. See Using MDX Formulas.
• Block storage outline formulas. See Using Substitution Variables in Formulas.
• Essbase - Calculation Script (block storage databases only)
• Report Script
• Data load rules file header definitions and field definitions. You can enter variable names for Essbase - Dimension and Essbase - Members names.

See these Oracle Essbase Administration Services Online Help topics: “Setting Headers in the Rules File” and “Mapping Field Names.”

• Partition definitions. See Substitution Variables in Partition Definitions.
• Data source name (DSN) specifications in Essbase - Rules File for SQL data source. See Oracle Essbase SQL Interface Guide.
• SELECT, FROM, or WHERE clauses in Essbase - Rules File for SQL Essbase - Data Source. See Oracle Essbase SQL Interface Guide.
• Security filters. See Filtering Using Substitution Variables.
• MDX statements See Using Substitution Variables in MDX Queries.
• Essbase - Spreadsheet Add-in.

Documentation / Reference

• Rules for Setting Substitution Variable Names and Values