Hosting Management Data Warehouse (MDW) reports on a reporting service
Management Data warehouse generates excellent report useful for a database professional with click of a mouse. However these reports can be accessed and navigated from SQL Server Management Studio only. Is not this a problem?
Well, I believe it is a shortcoming on MDW. Being able to host there reports on a SQL Server reporting instance automatically (like having real-time publishing capacity in-built) will actually complete this great feature.
However I found a series of great post from Microsoft PM Bill Ramos where he described how to host these reports in a reporting service portal in details. These steps can be referred at http://blogs.msdn.com/b/billramo/archive/2010/06/06/mdw-overview-report-for-data-collector-mdw-report-series-part-1.aspx
These series of post will enable you to host all MDW reports on a SSRS portal which can be very helpful for complete automation of MDW reporting.