The latest state of the work items - not historical You will also note that on the Show fields related to drop down there are different items related to work items as compared with 2008. Simply the fact of using dates as one of the dimensions will pull the historical information. This is one of the major changes - the cube handles cumulative and historical values depending on how you do your queries.

You'll also notice there are no cumulative measures. In fact, the only measures available to you for the work item are the following: The first change is that there are no Historical Work Item measures anymore. Looking specifically at the work items measures, there have been some big changes. If you have never reported off of the cube through Excel, then this article serves as a brief introduction on how to do this.įigure 1 shows the Excel pivot table panel which is used for reporting off of the cube. This article will focus on the work item measures as they are the most used in reporting. The usage is the same but this article looks at a tour of the new facets of the cube and how you can use it to make your own custom fields easier to find. In TFS 2010 the cube has changed significantly at the user interface level and some of the default measures. This cube is accessible through SQL Server Reporting Services (SSRS) and Microsoft Excel and even Microsoft's new add-in for Excel, Power Pivot. Of all of the integrated tools available on the market, none that I know of is supported by a back end reporting cube. One of the most powerful features of Team Foundation Server (TFS) is the SQL Server Analysis Services (SSAS) cube that back TFS. Jeff Levinson offers a tour of the new reporting cube functionality in Team Foundation Server 2010.

Inside VSTS TFS 2010 and the SQL Server Analysis Services Cube

Tfs client tools 2010