You can delete triggers that are no longer useful. You need Database Manager permissions or higher to delete a trigger.
To delete a trigger:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Triggers.
In the Database Triggers window, select a trigger, and click Delete.
At the confirmation prompt, click Yes.
The trigger is removed.
“Monitoring Data Changes Using Triggers” in the Oracle Essbase Database Administrator's Guide
drop trigger (MaxL) in the Oracle Essbase Technical Reference