You can clear data from an aggregate storage database using one of these methods:
Clear all data (requires Database Manager or Administrator permissions)
Cleared data values are set to #MISSING.
After data is cleared, data files are not deleted; however, Essbase attempts to shorten the files and give as much space as possible back to the operating system. For information about managing storage for aggregate storage applications, see the Oracle Essbase Database Administrator's Guide.
Clear all aggregations (requires Calculation permissions)
All but level 0 values are cleared. Thus, all aggregate cells are removed from the database, and the disk area is available for other uses.
Clear partial data (requires Database Manager or Administrator permissions)
Use an MDX set expression to specify the region to be cleared. Follow these guidelines:
The region must be symmetrical.
Individual members in any dimension in the region specification must be stored members.
Members in the region cannot be Dynamic members (members with implicit or explicit MDX formulas) nor from attribute dimensions.
Members in the region can be upper-level members in stored hierarchies.
For information about MDX syntax, see the MDX section of the Oracle Essbase Technical Reference.
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
To clear data from aggregate storage databases:
From Enterprise View or a custom view, select a database.
Right-click, and select the appropriate command:
Clear, and then All data
Clear, and then All aggregations
Clear, and then Partial data
Enter an MDX set expression that specifies the region of data to be cleared.
At the confirmation message, click Yes.