Clearing Aggregations

At times you might want to manually clear aggregations from the disk; for example, to make the disk space available for disk-intensive operations. Clearing aggregations clears all data, except level 0 values, from the database, releasing the disk area for other use. After aggregations are cleared, queries calculate retrieved values dynamically from level 0 values.

For information about when Essbase Server automatically clears aggregated data, see “Database restructure” in Table 192, Outline Differences Between Aggregate Storage and Block Storage.

  To clear aggregations, use a tool:

Tool

Topic

Location

Administration Services

Clearing Data from Aggregate Storage Databases

Oracle Essbase Administration Services Online Help

MaxL

alter database

Oracle Essbase Technical Reference