Environment
NetIQ Analysis Center 2.x
Situation
What do the various steps of SQL Server jobs perform for Analysis Center?
How is old data removed when I change the data retention settings to be less than the age of
How is old data removed when I change the data retention settings to be less than the age of
Resolution
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 [100] 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.
Additional Information
Formerly known as NETIQKB50520