|
A substitution variable is a type of placeholder that can take on different values. This then flows across to all references on the variable to make changes easy to change by changing them in one place.
If I recall, substition variables came out with Essbase 5.1.
The intent was to reduce the administration headaches that you can easily get yourself into with Essbase. The following are some of the areas when you can reap the benefits of substitution variables.
Report scripts
Essbase spreadsheet add-in
Essbase API
sql load rule
Setting up a Substitution variable:
Substitution variables are setup using the application manager. A given substitution variable, &CM, can be set for the server, application, and even database level. If there is more than one occurance, the most local version will take precedance. ie. You have a server &CM set to Mar, and your App/DB &CM is set to June. While in the db June will take effect.
Where do substitution variables not work?
- outline member formula
- load rule
In the screencam movie, you will see 2 substitution variables getting setup and also why you cannot use substitution variables in a member formula in the outline.
Substitution Variable setup movie
|
|
