- George Duckett Development
This extension enhances Anaplan formula editing in several ways; providing code completion, hover info and validity checks.
Works best with the ‘new model experience’, but can work with the old/current.
Formula Validation: Various checks are performed on formulas including simple things like ensuring all entities are named / referenced correctly or ensuring the correct data types are used throughout the formula, through to things like checking for dimension miss-matches when referring to line items with different dimensions.
Formula Formatting: Provides basic formatting for valid formulas; breaking up IF…THEN….ELSE onto multiple lines with proper indentation.
Hover Information: You can hover your mouse over most elements of a formula to get contextual information, for example hovering over line items shows their dimensions and data type and hovering over function names to get information about that function.
Code Completion: As you are typing the editor will offer auto-complete suggestions for things like line items within the current module, fully qualified line items within other modules, function names etc.
Function Information: When completing functions with parentheses you get popup contextual information relating to the parameters of the function together with an explanation of both the function and the parameters. You also get parameter type checking, and if the given parameter expects a keyword, these get auto-completed.
Shortcuts: Standard Monaco editor shortcuts apply. Ctrl-Space; Open code completion. Ctrl-Shift-Space; Open function info (when within function parentheses). Shift-Alt-F for formatting.
I welcome ideas for future enhancements; this is very much in active development.