KB: Service Manager 2010 Reports fail to include current data

Here’s a new Knowledge Base article we published this morning. This one discusses an issue where reporting data isn’t current due to a hung MPSyncJob or DWMaintenance job. ===== Symptoms In System Center Service Manager 2010, you may experience one or more of the following: -Reports do not have current information -ETL jobs are not… Read more

How long does the Service Manager Data Warehouse retain historical data?

The short answer is that we keep data in the warehouse for 3 years for fact tables and forever for dimension and outrigger tables. Antoni Hanus, a Premier Field Engineer with Microsoft, has put together the detailed steps on how to adjust this retention period so you can retain data longer or groom it out… Read more

Create a report model with localized outriggers (aka “Lists”)

If you’ve watched my Reporting and Business Intelligence with Service Manager 2010 webcast and followed along in your environment, you may have unintentionally created a report which displays enumeration guids instead of Incident Classification strings, like below. Not too useful. In this post I’ll tell you the simple way to fix your report model to… Read more

Introduction to the Data Warehouse: Custom Fact Tables, Dimensions and Outriggers

So you’ve deployed the data warehouse and tried out the reports but now you want to want to make it your own. You may be trying to recreate some reports you’ve been using forever and now need to run them against the Service Manager platform, or perhaps you simply want to take full advantage of… Read more

Data Warehouse – Anatomy of DW/Reporting Deployment

  In my last post I went over the management pack synchronization process that brings over MP’s from Service Manager and how those MP’s drive the structure, data, and reports for data warehouse and reporting. Once those MP’s are synchronized between Service Manager and the data warehouse, we need to get the data and/or reports… Read more