If you’ve upgraded your Team Foundation Server to Team Foundation Server 2010 you’re probably wondering what happened to all your existing reports. Your Team Project works great after the upgrade, but it all your existing reports are now missing! Not to worry, all your reports are still intact, but they need to updated to work against the new TFS 2010 warehouse schema. Let me explain…
During an upgrade to TFS 2010 the relational warehouse and cube undergo significant breaking changes. In fact, during the upgrade a brand new warehouse and cube are provisioned alongside your existing warehouse and cube. The existing warehouse and cube are left intact but are no longer “active” in the sense that new data is put into them. Because of this, any already existing reports authored against the 2008 warehouse and cube continue to show pre-upgrade data. You can view your existing reports directly from SQL Server Reporting Services at http://<yourservername>/Reports/<yourprojectname>/. In addition, after an upgrade the Reports folder in Team Explorer is mapped to a new location that accounts for Team Project Collections – this is why your reports don’t show up in Team Explorer.
You’ll also notice that after an upgrade you now see a new set of reports in your reports folder. These reports are versions of the MSF Agile/CMMI 4.2 reports that have been updated to work against the new TFS 2010 schema. You may choose to delete them or keep them based on the needs of your project.
So, what’s the effect on new projects? Any new project created in TFS 2010 using one of the new process templates will work fine without any modification as the reports included in the template have been authored against the new warehouse and cube. However, any new projects using a process template built prior to TFS 2010 (ex: MSF Agile/CMMI 4.2) will need report updates just like an existing Team Project.
To get your existing reports working against the new updated warehouse and cube you’ll need to modify the reports and apply the necessary changes. I’d recommend reading the blog posts below as they describe in detail the changes made to the warehouse and cube and how you can apply them to existing reports.
- John Socha-Leialoha has authored a detailed blog post entitled Upgrading Visual Studio Team Foundation Server 2008 Reports to 2010 that describes the steps to upgrade your reports.
- Sunder Raman has written a post describing the changes to the warehouse and cube entitled Relational Warehouse and Cube Schema Changes.