You can query for data about work items that are linked to changesets by using FactWorkItemChangeset and the associated dimensions. For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Analyze and report on work items and test case data using the Work Item perspective.

FactWorkItemChangeset is associated with the following dimension tables:

• DimChangeset

• DimPerson

• DimWorkItem

Concepts