Clearing Data from Specific Regions of Aggregate Storage Databases

You can clear data from a specified region in an aggregate storage database and retain the data located in other regions. This feature is useful when you want to delete volatile data (such as data corresponding to the last month) but retain historical data. You must have Database Manager or Administrator permission to clear data.

Methods for clearing data from a region:

In specifying the region to be cleared, follow these guidelines:

For example, to clear all January data for Forecast1 and Forecast2 scenarios, use this statement:

alter database AsoSamp.Sample clear data in region 'CrossJoin({Jan},{Forecast1, Forecast2})';

During the clear region operation, you cannot perform operations that update the database (such as loading data, merging data slices, or clearing data from another region), nor export data. You can query the database; however, the query results are based on the data set before the clear region operation.

The clear data in region grammar cannot clear data from the entire database. See Clearing All Data from an Aggregate Storage Database.