Databases Reference
In-Depth Information
In Essbase, you can use substitution variables in the following places:
• Dimension Build or Data load Rules File (used in the SQL interface)
• Calculation Scripts
• Report Scripts
• Outline Formulas
• MDX Queries
• Partition Deinitions
Substitution variables can be defined on a server level, application level, or database
level. These variables can be created using EAS, MaxL scripts, or using API calls and
Essbase EssCmd scripts.
Some rules while creating the variables are:
• The value of a substitution variable should not exceed 256 bytes or characters.
• The substitution variable value should not begin with the ampersand [
&
]
character, although all other characters are allowed.
• The user should have
READ
access to the application or database which
has the variable and should have ADMINISTRATOR access to read a
variable at the server level.
Substitution Variables using EAS
We have talked a lot about the substitution variable, let us now see how to create
a substitution variable using the EAS.
1. In EAS, scroll down to your
Essbase server
and select it.
2. Click on
Actions
|
Variables
|
Variable for
<YOUR SERVER NAME>
.
3. You should see the
New Variable
screen as shown:
