Databases Reference
In-Depth Information
Check it out, you can use the substitution variable from the
Calculation Script
Editor
, or any other script or object that executes in Essbase.
Building your first Calculation Script
The name of this section gives you the impression that we will be discussing Essbase
database calculation scripts, exclusively. What you learn here is also about 95%
applicable to coding database outline member formulas as well. As mentioned earlier
in this chapter, aside from a few member set functions and the
FIX
and
EXCLUDE
commands, almost everything that you can code in a database calculation script can
be coded in a database outline member formula.
To begin with, open the
Calculation Script Editor
in EAS by drilling down to your
Essbase database like
Essbase
Server
|
Application
|
Database
, then right-clicking
on
Calculation Scripts
and then selecting the
Create calculation script
option. You
will now see the
Calculation Script Editor
as shown earlier in this chapter.
Take a close look at the editor itself. Notice the various options that help simplify the
calculation script writing process on the left side. First up is a checkbox allowing you
to view the database outline using the database outline member aliases instead of the
database outline member names. There is also a list box that allows you to select the
outline alias table, should you have more than one created for your database outline.
The next feature is a great help when writing a calculation script. What you see
under the alias table selection area is a simplified representation of the database
outline. When you click on an outline member, its name is placed in the script
wherever you placed the cursor.
Underneath the outline feature are two check boxes. If you check
Insert
arguments
,
when you click on an argument, listed near the bottom it will place the calculation
argument into the calculation script wherever you place the cursor. If you check
the
Enable
Auto
-
completion
, the editor will offer you the choice of automatically
completing the statements you are typing, much like a Microsoft Visual Basic editor.
Finally, at the bottom is a visual tree representation of all of the available database
calculation functions and commands. If you have the
Insert arguments
checkbox
checked, the editor will place the argument you click into your calculation script
wherever you have placed your cursor.