Analysis Center 2.x does not currently allow you to manually groom data from your Data Mart or Data Warehouse. However, you can control the aggregation of data by specifying the number of months of data to be stored in the Data Mart and in the Data Warehouse.
To configure data retention settings:
- Start the Analysis Center Console in the Analysis Center program folder.
- On the Tools menu, click Options.
- In the left pane, expand Options.
- Select Data Warehouse.
- Configure the appropriate Data Mart data retention and Data Warehouse data retention settings. To preserve necessary fact data, ensure the number of months you specify for Data Mart data retention is at least equal to the value you set for Data Warehouse data retention.
- Click OK.