You can clear data from databases for which you have Write permissions.
If you clear only upper-level blocks, the data values for upper-level blocks are set to #MISSING. Upper-level blocks are created for sparse member combinations of which at least one sparse member is a parent member.
Note: | This functionality does not apply to aggregate storage databases. |
To clear upper-level blocks from databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Clear, and then Upper-level blocks.
In response to the confirmation prompt, click Yes.
clearblock upper (calculation command) in the Oracle Essbase Technical Reference