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