Databases Reference
In-Depth Information
One thing to keep in mind, some Oracle affiliates have offered a three day database
calculation class that only covers how to write Essbase effective database calculation
scripts. We have mixed feelings on the real value of such a class. With the information
we provide in this chapter, combined with a little patience, practice, and common
sense, there is absolutely no reason you cannot code your own robust database
calculation scripts.
Read on, to continue this exciting calculation journey.
Calculating your database
In any Essbase database, the data can be grouped into two distinct categories. First,
there is data that has been entered or loaded into the database. This data can be from
some type of data load from an external source or from a Microsoft Excel spreadsheet
with the Essbase add-in "Lock and Send" functionality.
Second, there is data that can be derived or calculated from the existing data
elements which were entered, loaded, or input into the database. This data can be
as simple as the total value at a parent level that has been added from the children
values. It can also be the result of a complex calculation that has taken advantage
of Essbase's extensive and powerful mathematical functions that are available to
you in the calculation function library.
As we explained in the previous chapter, the input or loaded data that resides
in your Essbase database can come from many and varied sources and, using
the wide array of data load tools and options, can be quickly and easily prepared
(made Essbase-friendly) and loaded into your Essbase database. This in itself is
reason enough to become an Essbase believer.
The Essbase calculation script
The Essbase data calculation script has the same characteristics as any other Essbase
file object. The script name can be no longer than eight characters and has a
.csc
extension. The calculation script file is actually an ASCII text format and can be
opened and edited in any text editor.
The ideal way to create and edit an Essbase database calculation script is to use
the built-in
Calculation Script Editor
found in the EAS tool. The benefits of using
this provided tool includes reserve word coloring, much like the Microsoft Visual
Basic editor, and a comprehensive syntax checker. These features make creating
Essbase database calculation scripts a rather easy task.
