Using Data Warehouse Reporting and Analytics in System Center 2012 - Service Manager
Updated: November 1, 2013
Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager
Service Manager reports enable you to collect and view data and trends from across the business environment. For example, you can generate a report that shows the number of incidents that occur in a specific time frame. You can then use that information to calculate the cost of each incident (in hours) and also to identify any trends and take preventative measures to reduce the cost and occurrence of incidences.
Standard reports are viewable for all Service Manager console users in the Reporting workspace. If users can view work items and have permission to the SystemCenter and ServiceManager folders on the SQL Server Reporting Services (SSRS) server, they can also view reports in work item task lists. Any user can export report data from a report they view. Exported reports are saved in a variety of file formats.
The following tasks are addressed in this guide.
Data Warehouse Reporting and Analytics Topics
Data Warehouse and Analytics Overview
Provides an overview of data warehouse and analytics in Service Manager.
Using and Managing Standard Reports
Introduces standard reporting in Service Manager.
Using OLAP Cubes for Advanced Analytics
Explains OLAP cube structure, how to use and troubleshoot OLAP cube, and how to create dashboards that show OLAP cube data.
Customizing the Data Warehouse
Explains data warehouse structure so that you can customize reports using its data.
Other Resources for This Component
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.