1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Drop Macro

Drop Macro

The MaxL drop macro statement helps you remove a custom-defined Essbase calculation macro.

Minimum permission required:

  • Application Manager to drop a local (application-level) macro.

  • Administrator to drop a global (system-level) macro.

Syntax


Description of drpmacro.gif follows
Description of the illustration drpmacro.gif

MACRO-NAME

You can delete custom-defined macros using drop macro.

Keywords

drop macro <macro-name>

Delete a custom-defined macro.

Notes

If you drop a custom-defined macro after having associated it with an application (using refresh custom definitions), you may have to stop and restart the application for the drop to take effect.

Example

drop macro sample.'@COVARIANCE';

Deletes the macro called @COVARIANCE from the Sample application.