You can delete filters from a database. See Managing Filters for information about permissions needed to manage filters.
To delete a filter:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Filters.
In the Filters window, select one or more filters.
Right-click and select Delete filter(s).
Click Yes.
Essbase deletes the filter and updates the Filters window.
drop filter (MaxL) in the Oracle Essbase Technical Reference