Clear Data. Essbase changes the values of all cells containing data to #Missing.

1. On the Applications page, click Jobs.
2. From the New Job menu, select Clear Data.
3. For Application, choose an application.
4. For Database, choose a cube.
5. Choose a Clear Data option.
   • For block storage cubes, choose:
     • All Data—All data, linked objects, and the outline are cleared
     • Upper-Level Blocks—Upper-level blocks are cleared
     • Non-Input Blocks—Non-input blocks are cleared
   • For aggregate storage cubes, choose:
     • All Data—All data, linked objects, and the outline are cleared
     • All Aggregations—All aggregated data is cleared
     • Partial Data—Only specified data region is cleared.

       Specify the data regions to clear in the MDX Expression text box.

       Select the Physical check box to physically remove the cells specified in the MDX Expression text box from the cube. See Clear Data from Aggregate Storage Cubes.

6. Click Submit.