You can clear data from databases for which you have Write permissions.
You can choose to clear only data blocks that contain values that are derived from calculation (non-input blocks). When you clear calculated blocks, data values for calculated (non-input) cells are set to #MISSING.
Note: | This functionality does not apply to aggregate storage databases. |
To clear calculated (non-input) blocks from databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Clear, and then Non-input blocks.
In response to the confirmation prompt, click Yes.
clearblock noninput (calculation command) in the Oracle Essbase Technical Reference