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 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 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