The following permissions are required to remove a custom-defined function:
Before removing custom-defined functions, you should verify that no calculation scripts or formulas are using them. Global custom-defined functions can be used in calculation scripts and formulas across Essbase Server, so you must verify that no calculation scripts or formulas on Essbase Server are using a global custom-defined function before removing it.
Caution! | Remove global custom-defined functions only when users are not accessing Essbase databases and calculation routines are not being performed. |
To remove a custom-defined function:
Perform an action, depending on whether you are removing a local or global custom-defined function:
To remove the custom-defined function, use a tool:
Local:
drop function Sample.'@JSUM';
Global:
drop function '@JSUM';
Restart the applications that you shut down, which updates the catalog.