Clear Aggregations

You can clear aggregations using a Job in the Essbase web interface. 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 Home 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.