So I was really looking forward to using the analysis services cube that is created from TFS to connect directly to Excel. I have a statistical status report that predicts completion dates based on historical data and have some custom code to connect to Quality Center. I was hoping to use the same report with TFS and create a similar set of macros to connect to TFS. Here’s the issue - there is only one database created for a TFS install. So, in order for me to create the connection between Excel and the analysis services cube, I would need to have read access directly on the database for all projects. The client I am working for does not want us to have access to the other projects (there are personal data and other security concerns that I completely understand). I am disappointed that TFS does not have a way for users to connect to analysis services for just one project….