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