Service Manager Data Warehouse and Reporting

re: Service Manager Data Warehouse and Reporting

Travis Wright MSFT — Fri, 01 Mar 2013 19:22:17 GMT

@Rob -

Both the ActivityDim and ProblemDim are defined as HierarchySupport="IncludeExtendedClassProperties" so any properties that you add to the Activity or Problem class should be included in the ActivityDim and ProblemDim. Make sure that you seal your class extension management pack before you import it into SCSM.

re: Service Manager Data Warehouse and Reporting

Rob — Thu, 28 Feb 2013 09:57:13 GMT

If you add fields to existing classes such as Activity or Problem should they come through in the DW tables automatically? Mine aren't but I cannot find what to do to update the DW Schema. Any ideas?

re: Service Manager Data Warehouse and Reporting

kpm — Wed, 16 Mar 2011 23:09:26 GMT

Am I blind? For the life of me, on these tech net blogs, I see no useful navigation. Some bloggers mention in the first sentence a previous or future post and link to it. There are no 'Previous' or 'Next' links, or even just a list of titles... some have a 'previous posts' lists, but not all, and if the previous sequential posts go back beyond the five or so links in the previous posts list, your out of luck. So, for instance, I landed on this page by clicking the "In my previous post..." links. But now that I'm here on this page, all I see is "in my next post..." but absolutely no navigation to get to the next post... I know it exists, since I landed here from it, but if I got here via a search, well, my only assumption is that the blogger has not yet created the next post.

re: Service Manager Data Warehouse and Reporting

Christo — Wed, 15 Dec 2010 10:57:02 GMT

How do I give a manager access to the Reports?

re: Service Manager Data Warehouse and Reporting

Greg — Thu, 18 Nov 2010 23:47:06 GMT

All I want is a report where the end user in SCSM can select a bunch queries to get the desired data they want. For example, to search for change requests... I want a report where the user can select the following queriable data:

Change Request Area

Change Request Priority

Change Request Impact

Change Request Title (Contains Text)

Scheduled End Date (Range)

Actual End Date (Range)

etc etc etc

Why is this so impossible? My SQL guy wants to kill me right now beause the databases with this tool look like spaghetti. Why is this so complex and hard to do?????

Data Warehouse – Anatomy of Management Pack Synchronization

System Center Service Manager — Sat, 28 Mar 2009 03:45:58 GMT

  In my last post I gave an overview of some of the components that make up Data Warehouse and Reporting.

The System Center Platform in Service Manager Part 2: The Model-Based Database

System Center Service Manager — Wed, 28 Jan 2009 11:40:35 GMT

This post is a continuation of the series started with The System Center Platform in Service Manager