You use the New Macro dialog box to create custom-defined macros.
Read-only boxes:
Essbase Server—Name of the current Essbase Server instance
Statement—How the macro definition would be specified using a MaxL statement
Text boxes in which you enter information:
Scope—The application name (for local macros) or <all app> (for global applications)
Name—Name of the macro; for example, @MYMACRO (For naming restrictions, see the Oracle Essbase Database Administrator's Guide)
Signature—Description of the style in which macro arguments are passed
For example, the following signature passes the macro as two comma-separated arguments followed by a list of arguments: (SINGLE, SINGLE, GROUP)
Expansion—A string that determines how the signature is processed
For example, if you use the following macro, signature, and expansion, @SUM3 (x, y, z) is replaced with @SUM3 (x + y + z):
Name—@SUM3
Signature—(SINGLE, SINGLE, SINGLE)
Expansion—(@@1, @@2, @@3)
Spec—Essbase calculator-syntax specification string; for example, @MYMACRO (mbrName, rangeList)
A specification string is not required. You use a specification string to return the macro and its syntax by the output string of the EssListCalcFunctions API function.
Comment—Not required and possible only if a specification string is used
create macro (MaxL) in the Oracle Essbase Technical Reference
display macro (MaxL) in the Oracle Essbase Technical Reference