1. Using Oracle Essbase
  2. Run and Manage Jobs Using the Web Interface
  3. Execute Jobs
  4. Clear Aggregations

Clear Aggregations

Clear aggregations. Essbase clears aggregations from your aggregate storage (ASO) cube, removing non level-0 data. User queries then calculate retrieved values dynamically from the level-0 values.

Clearing aggregations requires Database Update permission.
  1. On the Applications page, click Jobs.
  2. From the New Job menu, select Clear Aggregations.
  3. For Application, choose an application.
  4. For Database, choose a cube.
  5. Click Submit.
See Build Aggregations and Clear Aggregated Data from the Cube.