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.
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.
You can use substitution variables with both Essbase - Aggregate Storage and block storage applications in the following areas:
See these Oracle Essbase Administration Services Online Help topics: “Setting Headers in the Rules File” and “Mapping Field Names.”
You can manage substitution variables on the Essbase - Servers following this naming rules and using this tools :
Tool | Topic | Documentation Location |
---|---|---|
Essbase - Administration Service (EAS) | Managing Substitution Variables | Oracle Essbase Administration Services Online Help |
Essbase - MaxL | alter system alter application alter database | Oracle Essbase Technical Reference |
Essbase - EssCmd | CREATEVARIABLE DELETEVARIABLE UPDATEVARIABLE | Oracle Essbase Technical Reference |
You can create, delete, update and copy a substitution variables.
You can set substitution variables on the Essbase Server at any of the following levels: