Code Churn tables

Last Update: 3/9/2017

TFS 2017 | TFS 2015 | TFS 2013

IMPORTANT

Excel reports, Reporting Services reports, and SharePoint dashboards are only supported for on-premises TFS. For information on what is supported for Team Services, see Dashboards and reports overview.

You can query for data about the changes in the code that is under version control by using FactCodeChurn and the associated dimension tables. The fact table contains one record for each revision of a file in each changeset.

For a description of the measures and dimensions that are associated with these tables in the Analysis Services cube, see Code churn and code coverage.

Fact Table for Code Churn

FactCodeChurn is associated with the following dimension tables:

  • DimChangeset

  • DimDate

  • DimFile

  • DimTeamProject