Browse by Tags

Tagged Content List
  • Blog Post: How to rebuild your SSAS and cubes in SCSM 2012 R2

    I’ve recently published a blog post, describing how to rebuild a corrupt SQL Analysis database, used by SCSM 2012 R2. http://blogs.technet.com/b/thomase/archive/2014/11/24/how-to-rebuild-your-analysis-database.aspx A big thank you to Alex Young, for helping out with writing the procedure...
  • Blog Post: Fixing Service Manager Data Warehouse Registration Information

    Mihai Sarbulescu , Support Escalation Engineer from Romania, have written a cool blog post on troubleshooting and fixing a Service Manager Data Warehouse registration. The blog post includes a small Tool that migth solve your DW issue. You can read the blog post here: http://blogs.technet.com/b/mihai...
  • Blog Post: Data Retention Policies (aka "Grooming") in the Service Manager Database

    What is Grooming? Why Groom? The ServiceManager database is the “online” or “operational” database in Service Manager. It is the database which most users are interacting with when they are using Service Manager. Therefore, you want to keep it running as fast as possible. Databases...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Introduction to Reporting in Service Manager

    Hi, my name is Chris Lauren and I’m a Senior Program Manager on the System Center Service Manager team. I’ve been on the team a little more than 3 months now, but I’ve been doing business intelligence, reporting and data warehousing in Microsoft since 2000. In my first blog I’m going to guide you...
  • Blog Post: 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 the customizations...
  • Blog Post: Service Manager Data Warehouse and Reporting

    Hi, my name is Chad Rowe and I am a Program Manager for the System Center Service Manager team working on the data warehouse and reporting features. I’ve been with the team for about 8 months and prior to that I worked within Microsoft’s IT organization for 9+ years managing operations teams that supported...