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)

Architecture Visio Diagram



Data Warehouse Administration

PowerShell Script to Run ETL and Cube Processing in Sequence

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

KPIs





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

Analyze System Center Cubes Using Excel

Publishing and Subscribing to Service Manager Reports