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

Calculation types explained

As mentioned earlier in this chapter, there are three ways to calculate data in your Essbase database. There is the infamous Essbase database calculation script, the regular outline member formula, and the outline member formula written on a member tagged as Dynamic Calc or Dynamic Calc and Store. We will now give you an explanation of each calculation type along with its pros and cons.

Calculation Scripts

Mentioned already, but only briefly, was the venerable Essbase database calculation script. The database calculation script is an ASCII text file containing a series of precise commands and functions which are used by Essbase to perform calculations on the data stored in an Essbase database.

Essbase database calculation ...

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