Which steps in the SQL Server jobs groom data? (NETIQKB50520)

  • 7750520
  • 02-Feb-2007
  • 25-May-2011

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

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