You can clear all data from databases for which you have Write permissions.
For information about clearing data from aggregate storage databases, see Clearing Data from Aggregate Storage Databases.
To clear all data from block storage databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Clear, and then All data.
In response to the confirmation message, click Yes.
alter database (MaxL) in the Oracle Essbase Technical Reference
resetdb (ESSCMD)
cleardata (calculation command) in the Oracle Essbase Technical Reference