Databases Reference
In-Depth Information
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 scripts are highly versatile and can be written, stored,
and executed in a variety of ways.
To write an Essbase database calculation script, known as a calc script or calc, the
easiest method is to use the
Calculation Script Editor
provided in EAS. This custom
editor provides many features for coding database outline member selections, syntax
checking, and function or command choices and their use.
The storing of an Essbase database calculation script is something that is entirely
upto you—as the programmer/administrator. When you use the EAS Calculation
script editor, it will default to saving the calculation script file object in the default
Essbase database file structure, which is basically the database folder on the server.
This is an acceptable place to leave the scripts, but it is not the best idea to allow
access to a secure folder on a database server to too many people.
