System Center Service Manager Data Warehouse and Reporting
The System Center Service Manager Data Warehouse is a powerful IT business intelligence platform built on the Microsoft BI stack (SQL Server, SharePoint, Excel). This article serves as a home page for resources on how to manage and extend the data warehouse as well as how to author custom dashboards and reports in SharePoint and Excel. Please feel free to edit this article to add additional links to other resources about the data warehouse or reporting!
Data Warehouse Architecture
The System Center Platform in Service Manager Part 6: The Data Warehouse
Service Manager Data Warehouse and Reporting
Data Warehouse – Anatomy of Management Pack Synchronization
Data Warehouse – Anatomy of DW/Reporting Deployment
Data Warehouse – Anatomy of Extract, Transform, Load (ETL)
Data Warehouse Administration
PowerShell Script to Run ETL and Cube Processing in Sequence
Automating ETL and Cube Processing using Orchestrator
How To Process All the Dimensions in the Data Warehouse in Bulk Using PowerShell
How long does the Service Manager Data Warehouse retain historical data?
Troubleshooting the Service Manager Data Warehouse
OLAP Cubes in the SCSM Data Warehouse: Troubleshooting
OLAP Cubes in the SCSM Data Warehouse : Maintenance and Administration
Moving the SCSM Data Warehouse Databases
Extending the Service Manager Data Warehouse
The System Center Platform in Service Manager Part 6: The Data Warehouse – Try It!
Creating Outriggers and Dimensions in the Data Warehouse
Creating Relationship Facts in the Data Warehouse
Creating Custom Fact Tables, Dimensions and Outriggers
How to Build OLAP Cubes in the SCSM Data Warehouse
OLAP Cubes in the SCSM Data Warehouse: Introduction
OLAP Cubes in the SCSM Data Warehouse : Key Concepts
OLAP Cubes in the SCSM Data Warehouse : Modeling the OLAP Cube in Management Packs
OLAP Cubes in the SCSM Data Warehouse : OLAP Cube Partitioning
OLAP Cubes in the SCSM Data Warehouse: OLAP Cube Processing
OLAP Cubes in the SCSM Data Warehouse: OLAP Cube Deployment
OLAP Cubes in the SCSM Data Warehouse: Troubleshooting
OLAP Cubes in the SCSM Data Warehouse : Maintenance and Administration
Report Authoring
Creating Custom Reports in SCSM
Service Manager Data Warehouse Schema
The System Center Platform in Service Manager Part 6: The Data Warehouse – Try It!
How to Create a Custom Report and Display it in the Console
Creating a Dashboard with the Report Viewer Control and a Custom Overview View Type
How to Make SharePoint PerformancePoint Dashboards Using SCSM DW Cubes
Count of Incidents by Classification Query and How to Get Enumeration Display Strings
Create a Report Model With Localized Outriggers
How to Slice Incidents by Days, Months, Quarters
Using Reporting
Displaying Non-Service Manager Reports in Service Manager
Displaying Service Manager Reports in SharePoint