You can clear data from databases for which you have Write permissions.
You can clear all data values, or, for block storage databases, you can clear only calculated data blocks or only upper-level data blocks. Cells for which data is cleared are set to #MISSING.
You can also clear data automatically, as part of a data load. See Clearing Data Values Before Loading Data.
To clear all data values, see Clearing All Data Values.
To clear data from aggregate storage databases, see Clearing Data from Aggregate Storage Databases.
To clear calculated data blocks, see Clearing Calculated Data Blocks.
To clear upper-level data blocks, see Clearing Upper-Level Data Blocks.
“Data Storage in Data Blocks,” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference
resetdb (ESSCMD) in the Oracle Essbase Technical Reference
cleardata (calculation command) in the Oracle Essbase Technical Reference
clearblock noninput (calculation command) in the Oracle Essbase Technical Reference
clearblock upper (calculation command) in the Oracle Essbase Technical Reference