Essbase - Substitution variables

Essbase Overview


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

How to set/unset substitution variables ?

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
Oracle Essbase Technical Reference

You can create, delete, update and copy a substitution variables.

Set Level

You can set substitution variables on the Essbase Server at any of the following levels:

  • Server : Essbase Server—providing access to the variable from all applications and databases on the Essbase - Servers
  • Application : Application—providing access to the variable from all databases within the application
  • Database : Database—providing access to the variable within the specified database

Documentation / Reference

Discover More
Essbase Overview
Essbase - Naming Restrictions

Naming Restrictions for and : Naming Restrictions for Applications and Databases ...
Obiee Essbase Unbalanced Hierarchy
OBIEE - Essbase

Cube scope: Member attributesunbalanced hierarchies“”“”hierarchy columnattribute column Support...
Essbase Overview
Oracle Hyperion - Essbase

Hyperion Essbase is an Online Analytical Processing (OLAP) server that : extracts data from a wide range of datasources, including : Oracle Database 11g and other relational databases, files, ...

Share this page:
Follow us:
Task Runner