Editors (such as Calculation Script Editor and Formula Editor) display a tree view of relevant commands and functions. For example, Calculation Script Editor displays Essbase calculation functions, custom-defined functions and macros, calculation commands, and calculation operators; and Report Script Editor displays report commands. Items selected from the current tree are inserted into the current script or formula. You need not enter the items manually.
As you insert functions and commands, you can insert argument templates. You can then modify the arguments.
Also see these topics in the Oracle Essbase Technical Reference:
Calculation Function Categories
Calculation Command Groups
Report Writer Command Groups
Note: | Various functions and commands may be displayed, depending upon the Essbase Server release level to which you are connected. |
To insert commands, functions, and operators into scripts and formulas:
Open an editor.
In the lower left pane of the editor window, relevant functions, commands, and operators are displayed in a tree view.
Optional: Perform an action:
To view the list by category, click the Categorical tab.
To view the list alphabetically, click the Alphabetical tab.
In the script or formula area, click where you want to insert the function, command, or operator.
In the Commands and functions tree, locate the item that you want to insert.
Optional: To insert an argument template with the function or command, select Insert arguments.
You can preview the argument template by right-clicking the function or command.
Double-click the selected item.
Essbase inserts the function, command, or operator at the cursor position in the script or formula.
If you inserted an argument template, replace the template with the preferred values.