You can create custom-defined calculation macros for use with the Essbase calculator framework. When you create macros, you specify scope, syntax rules, and expansion instructions, and, as needed, other optional information.
Note: | Custom-defined macros do not apply to aggregate storage applications. |
To create custom-defined macros:
From Enterprise View or a custom view, select an Essbase Server.
Right-click, and select Create, and then Function.
In the fields of the New Macro dialog box, enter information.
Click OK.
Essbase registers the macro and displays it in the Custom Defined Macro Manager window. You can use the macro just as you use a native Essbase calculation function.
create macro (MaxL) in the Oracle Essbase Technical Reference