Date dimensions for Incidents, Service Requests, Change Requests and Activities.

I’ve had this blog on my todo list for quite a while and finally I found some time to actually write it. My colleague Atchut Barli created an MP last year that extended the Data Warehouse Work Item cube with a date dimension for when incidents were created. This made some reports a lot more useable. http://blogs.technet.com/b/servicemanager/archive/2013/02/20/3539405.aspx Together…


SCSM 2012 Data Warehouse jobs keep failing

I often run into the same problem with the SCSM 2012 Data Warehouse, that the cubes jobs all fail. When resuming one of the jobs the following errors appear in the log: Message : An Exception was encountered while trying during cube processing.  Message=  Processing warning encountered – Location: , Source: Microsoft SQL Server 2008…