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 Analyze and report on code churn and code coverage using the code churn and run coverage perspectives.

FactCodeChurn is associated with the following dimension tables:

• DimChangeset

• DimDate

• DimFile

• DimTeamProject

Concepts