Removing Custom-Defined Macros

The procedure for removing global custom-defined macros, which is more complex than that for removing local custom-defined macros, should be performed only by DBAs.

  To remove a custom-defined macro:

  1. Determine whether the macro is registered locally or globally.

    See Viewing Custom-Defined Macros.

  2. Verify that no calculation scripts or formulas are using the custom-defined macro.

  3. To remove the macro from the catalog of macros; use a tool:

    Tool

    Topic

    Location

    Administration Services

    Deleting Custom-Defined Macros

    Oracle Essbase Administration Services Online Help

    MaxL

    drop macro

    Oracle Essbase Technical Reference

  4. Restart all applications associated with the macro.

    See Refreshing the Catalog of Custom-Defined Macros.

The following MaxL statement removes the local macro @COUNTRANGE, which is used only in the Sample application:

drop macro Sample.'@COUNTRANGE';

The following MaxL statement removes the global macro @COUNTRANGE:

drop macro '@COUNTRANGE';