Removing Custom-Defined Functions

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:

  1. Determine whether the function is local or global.

    See Viewing Custom-Defined Functions.

  2. Perform an action, depending on whether you are removing a local or global custom-defined function:

    1. Local: Shut down any Essbase applications that use the functions in the .jar file.

    2. Global: Shut down all Essbase applications.

  3. To remove the custom-defined function, use a tool:

    • Administration Services: See “Deleting Custom-Defined Functions” in the Oracle Essbase Administration Services Online Help

    • MaxL: Use the drop function MaxL statement. For example:

    • Local:

      drop function Sample.'@JSUM';
    • Global:

      drop function '@JSUM';
  4. Restart the applications that you shut down, which updates the catalog.