How is old data removed when I change the data retention settings to be less than the age of
When you use the Options window to change the retention settings for the data outside the Data Retention times, the following steps groom out that data:
- For the DataMarts, the ETL task uses Step 16.
- For the DataWarehouse/OLAP, the Analysis Center (OLAP Processing) job uses  Groom Regular Cubes (Microsoft Analysis Services Enterprise Edition). Steps 4 and 6 of the Analysis Center (OLAP Processing) job process the OLAP dimensions and cubes respectively. The two steps then create and run DTS packages in memory and do not save the packages anywhere.
Both SQL Server Agent Jobs must complete to successfully remove the data from Analysis Center.