Current Work Item Tables

  • Article

You can query for data about the current state of bugs, tasks, and other types of work items by using the FactCurrentWorkItem table and the associated dimension tables.

For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Analyzing Work Item and Test Case Data Using the Work Item Perspective.

Fact Table for Current Work Items

FactCurrentWorkItem is associated with the following dimension tables:

  • DimArea

  • DimIteration

  • DimPerson

  • DimTeamProject

See Also

Concepts

Analyzing Work Item and Test Case Data Using the Work Item Perspective

Work Item History Tables

What's New for Reporting for Visual Studio ALM

Generating Reports Using the Relational Warehouse Database for Visual Studio ALM