Formulas calculate relationships between members of a database outline. You can use formulas in two ways:
Apply them to members in the database outline. Use this method if you do not need to control database calculations carefully for accuracy or performance. This method limits the size of formulas to less than 64 KB.
Place them in calculation scripts. Use this method if you need to control database calculations carefully. For more information, see About Calculation Scripts.
For more information about developing formulas, see the Oracle Essbase Database Administrator's Guide. For information about formula syntax, see the Oracle Essbase Technical Reference.
Note: | There are different guidelines for using formulas with aggregate storage databases. For more information, see Creating Formulas for Aggregate Storage Databases. |
“Developing Formulas” in the Oracle Essbase Database Administrator's Guide
“Reviewing Examples of Formulas” in the Oracle Essbase Database Administrator's Guide
getmbrcalc (ESSCMD) in the Oracle Essbase Technical Reference