Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  System Center Service Manager Data Warehouse and Reporting

System Center Service Manager Data Warehouse and Reporting

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)
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
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
, , , , , [Edit tags]
Leave a Comment
  • Please add 7 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 16 Feb 2013 1:09 PM

    Travis Wright MSFT edited Revision 1. Comment: added link to Visio diagram

  • 28 Jan 2013 10:31 PM

    Travis Wright MSFT edited Original. Comment: added more links

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 28 Jan 2013 10:31 PM

    Travis Wright MSFT edited Original. Comment: added more links

  • Posted by
    on 16 Feb 2013 1:09 PM

    Travis Wright MSFT edited Revision 1. Comment: added link to Visio diagram

Page 1 of 1 (2 items)