O'Reilly logo

Oracle Essbase 9 Implementation Guide by Joseph Sydney Gomez, Sarma Anantapantula

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Substitution Variables

One of the coolest things in Essbase is the substitution variable. Substitution variables are like global variables that can be defined once and then used anywhere in Essbase you want to. The main use for substitution variables is to create a dynamic, easy to use variable which will change with time. Each variable name will have a value associated with it which can be changed (recreated), displayed or deleted.

For example, let's say you have a batch job that runs every day. In this daily job you are loading data, calculating it, and creating a unit report for the current month. Now, can you guess what should be the value of the substitution variable? You got it, it is the Month value from the database time dimension. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required