Follow these guidelines when naming custom-defined macros:
Start the macro name with the “@” symbol; for example, @MYMACRO. The rest of a name can contain letters, numbers, and the following symbols: @, #, $, and _. Macro names must not contain spaces.
For macros that are called only by other macros, start the macro name with “@_”, to distinguish it from general-use macros and functions.
Give macros unique names. Additionally, a macro name must be different from the names of custom-defined functions and from the names of existing calculation functions.
Note: | If an application contains a local macro that has the same name as a global macro, the local macro takes precedence and is used for calculation. |
For local macros, you must prepend the application name to the macro name, separating the application name from the macro name with a period:
AppName.@MacroName
For example:
Sample.@MYMACRO
Because global macros are available to any application running on the Essbase Server where the macro was created, you do not assign an application name to it.