Databases Reference
In-Depth Information
Member formulas can be written for all types of database outline members. The
method used to execute a member formula is the only thing different. Member
formulas can be executed when the database outline is calculated using the
Calc
All
command or when attached to a dynamically calculated member and the user
has requested data from that member.
For the script executed formula, you will set the
Data Storage
option to
Store Data
.
For the dynamically calculated member, you will set the
Data Storage
option to
Dynamic Calc
or
Dynamic Calc and Store
.
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.
