There's a great write-up from Bryan MacFarlane on troubleshooting Team Foundation reports and the warehouse on the TF forum.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1
