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…


Incident reports failing with - Query execution failed for dataset 'RelatedCIs'.

I ran into a funny problem the other day when working with the SCSM Incident reports. The reports all ran fine, but when we wanted to drill furter down we got the following error: Query execution failed for dataset ‘RelatedCIs’. (rsErrorExecutingCommand) I tried to run the report directly on the SSRS server and got little…