Clear Data

When you run the Clear Data job in the Essbase web interface, Essbase changes the values of cells containing data to #Missing. You can perform a full clear or a partial clear. Clearing data requires at least Database Update permission.

On the Home page, click Jobs.
From the New Job menu, select Clear Data.
For Application, choose an application.
For Database, choose a cube.
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.
Click Submit.