You can delete applications for which you have Create/Delete Applications permissions.
When an application is deleted:
All objects within the application are deleted.
You are asked to unlock locked objects. Locked objects cannot be deleted. Non-administrators can unlock only the objects that they locked.
The application directory (ARBORPATH\app\appname) and all files stored in it are deleted.
Log chart information for the application (used for Log Analyzer) is deleted.
Open windows associated with the application (for example, Application Properties, Sessions, and Locks) are closed. For windows that contain unsaved changes, you are asked to save changes.
To delete applications:
From Enterprise View or a custom view, select an application.
Right-click, and select Delete, and then Application.
At the confirmation message, click Yes.
If the application contains locked objects, Essbase displays a list of the locked objects and indicates who locked which object at what time.
If the application contains locked objects, unlock objects, complete the delete operation, and click OK.
Essbase deletes the application—provided that all locked objects were unlocked—and updates Enterprise View.
drop application (MaxL) in the Oracle Essbase Technical Reference
deleteapp (ESSCMD) in the Oracle Essbase Technical Reference