Using Data Warehouse Reporting and Analytics in System Center 2012 - Service Manager
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - 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.
Provides an overview of data warehouse and analytics in Service Manager.
Introduces standard reporting in Service Manager.
Explains OLAP cube structure, how to use and troubleshoot OLAP cube, and how to create dashboards that show OLAP cube data.
Explains data warehouse structure so that you can customize reports using its data.