You use the Formula tab to edit formulas that are applied to members and that are calculated through default database calculations and calculation-script calculations.
Note: | To edit formulas that are calculated only within calculation scripts, use Calculation Script Editor. In aggregate storage outlines, formulas are expressed in MDX syntax. See Creating Formulas for Aggregate Storage Databases. |
The tab features a text editing pane, point-and-click member selection, function templates, and a syntax checker.
Within the tab, you can perform the following actions:
Use either member names or alias names in a formula
Create formulas using pre-defined templates
“Developing Formulas” in the Oracle Essbase Database Administrator's Guide
“Reviewing Examples of Formulas” in the Oracle Essbase Database Administrator's Guide