When you create formulas for block storage databases, you must follow the appropriate syntax guidelines for formulas, calculation commands, and calculation functions.
For information about formulas in aggregate storage databases, see Creating Formulas for Aggregate Storage Databases.
See the following for details:
“Understanding Formula Syntax” in the Oracle Essbase Database Administrator's Guide
Calculation Commands in the Oracle Essbase Technical Reference
Calculation Functions in the Oracle Essbase Technical Reference
“Reviewing Examples of Formulas” in the Oracle Essbase Database Administrator's Guide