About Service Reporting Data Aggregation and Data Cubes

 

Updated: May 13, 2016

Applies To: System Center 2012 R2 Service Reporting, System Center 2012 R2 Orchestrator

Service Reporting data is collected hourly by a Microsoft SQL Server Agent job that executes a SQL Server Integration Services package to process the Service Reporting data warehouse. If the job is installed and registered to Service Reporting, the job first retrieves data from Windows Azure Pack for Windows Server, and then processes the data. After that, the job gathers data from System Center 2012 R2 Operations Manager and processes that data. As data is processed, it is stored in the Service Reporting data warehouse. The processed data is aggregated from the various sources and optimized for viewing in reports that have various units of time, including daily and monthly periods. Finally, the data is stored in the online analytical processing (OLAP) cube for viewing.

The following table shows how long the data warehouse stores the data that is shown in reports.

Unit of time for data Storage duration
Hourly 90 days
Daily Three years
Monthly Indefinitely

See Also

Service Reporting in System Center 2012 R2
Operating Service Reporting
Understanding Inventory and Usage Data from Windows Azure Pack and System Center