Clearing Data from Aggregate Storage Databases

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.

Related Information

Clearing Data

Related Commands

• 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:

1. From Enterprise View or a custom view, select a database.

2. 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.

3. At the confirmation message, click Yes.