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

Get Oracle Essbase 9 Implementation Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.