With Administrator permissions, you can delete custom-defined macros that are defined at the global (server) level. With Application Manager permissions for an application, you can delete custom-defined macro that are defined for the application.
When you delete local (application-level) macros, the Essbase application associated with the macros must be restarted. When you delete global (server-level) macros, all running Essbase applications on the server must be restarted. When applications are restarted, each macro catalog is refreshed.
Before deleting macros, ensure that no calculation scripts or formulas are using the macros.
Caution! | Global custom-defined macros should be deleted only when no users are accessing Essbase databases and no calculations are being performed. |
To delete custom-defined macros:
From Enterprise View or a custom view, select an Essbase Server.
Right-click, and select Edit, and then Macros.
In the Custom Defined Macro Manager window, select a macro, and click Delete.
At the confirmation message, click Yes.
Essbase removes the macro from Essbase Server.
Restart all applications associated with the macro.
drop macro (MaxL) in the Oracle Essbase Technical Reference