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