Code Churn Perspective
You can use the Code Churn perspective to view just the measures, attributes, and calculations in the data cube that pertain to the Team Foundation Build process. The Code Churn perspective helps you analyze how source files are changing over time and across builds.
In order to use perspectives with the Team Foundation cube, you must use Microsoft SQL Server 2005 Enterprise Edition or SQL Server 2005 Enterprise (64) Edition on the data tier. SQL Server 2005 Standard Edition that ships as part of Team Foundation Server, does not support the use of perspectives. When you use SQL Server 2005 Standard Edition, the cube elements from all perspectives reside in the Team System data cube.
You can use the Code Churn perspective to answer questions such as:
How many files of a specific file name extension changed in a particular build?
How many lines of code are in the source base for a particular build?
Which changesets have been submitted, and the details of each change (for example, who performed the change, what files were modified, and the date the change was made).
The following table describes the measures that are included in the Code Churn perspective. The Code Churn perspective contains a single measure group named Code Churn. A new fact is added to this measure for each file change referenced by a check-in action in the version control system.
Code Churn Count
The number of times that changes were made to files in the version control system.
Lines added to files for the selected dimensions.
Total number of deleted lines.
Total number of changed lines in the time period selected.
Total churn in the code, computed as: [Lines Added] + [Lines Deleted] + [Lines Modified].
Total number of lines in the selected part of the file path hierarchy at the point of a specific build or across a set of builds. This calculation only returns information for builds, and will return NULL when you use it without selecting individual builds. The number of lines is calculated by aggregating the lines added and lines deleted that have contributed to a specific build type/operating system combination.
The following table describes the attributes that are included in the Build perspective. You can aggregate the measures along each of these attributes.
Number or name used to uniquely identify the build.
Build Start Time
Date and time the build began.
Name of the build definition. For more information, see How to: Create a Build Definition.
The check-in comment associated with the changeset.
The Changeset Name or ID which included the file changes.
Policy Override Comment
The comment that is provided when a policy is overridden. If a policy was not overridden with this changeset, this field is null.
Checked In By
The alias of the person checking in the code modifications.
Checked In By
The user name of the person checking in the code modifications.
Year Month Date
The date on which the changeset was submitted organized by year, month and date.
Year Week Date
The date on which the changeset was submitted organized by year, week of the year and date.
The date on which the changeset was submitted.
The type of file (file name extension) for which the changes were made.
A hierarchy of the directories and files in the source control database.
The name of the team project.
The work item's ID, as assigned when the work item was created.
The previous state of the work item.
Work Item Type
The type of the work item.
The reason that the state of the work item changed.
The revision of the work item.
The state of the work item.
The title of the work item.
Other attributes depending on the process template used to create the team project. For more information, see the "The Work Item Dimension" section of Current Work Item Perspective.