Using Auto-Completion

Calculation Script Editor, Report Script Editor, and Formula Editor provide an auto-completion feature that helps you build scripts interactively as you type. When you start typing, a list of possible matches is displayed. When you select an item, the text required for the item is inserted into the script, and the cursor is placed where the arguments are to be entered.

For block storage databases, auto-completion applies to Essbase calculation functions and commands and to report commands (not to member names). For example, in an editor, for a block storage database, if you type @a (no case-sensitivity), you are prompted to select from a list of calculation functions that start with @a, such as @ABS and @ACCUM. Auto-completion can also be used for insertion of argument templates.

For aggregate storage databases, auto-completion applies to MDX syntax. For information about how auto-completion works with MDX, see Using Auto-Completion in MaxL and MDX Script Editors

  To use auto-completion in Calculation Script Editor, Report Script Editor, or Formula Editor:

  1. Open or create a script.

    In the lower left pane of the editor window, relevant functions and commands are displayed in a tree view.

  2. Select Enable auto-completion.

  3. If you want to insert an argument template with functions or commands into the script, select Insert arguments.

  4. In the script, click where you want to insert text, a command, or a function.

  5. Start typing, and then select a command or function from the drop-down list.

    The selected command or function is inserted into the script.

    Note:

    To close a list, press Esc.

Related Information