With appropriate permissions, you can delete calculation and report scripts from Essbase Server. You can use the method described in this topic or the file system. To delete scripts that are saved at the application level, you need at least Application Manager permissions for the application. To delete scripts that are saved at the database level, you need at least Database Manager permissions for the database.
Deleted scripts are deleted from the application or database directory in which they were saved on the Essbase Server.
To delete calculation and report scripts from an Essbase Server:
From Enterprise View or a custom view, select a script.
Right-click, and select Delete.
At the confirmation prompt, click Yes.
If the script is locked, Essbase prompts you to remove the lock (by clicking OK). If you are not an administrator, you can unlock only scripts that you locked.
Assuming that the script was not locked or was successfully unlocked, the script is deleted, and Enterprise View is updated.
drop calculation (MaxL) in the Oracle Essbase Technical Reference
drop object (MaxL) in the Oracle Essbase Technical Reference