Share via


Work Item Test Result Tables

You can query for data about work items that are linked to test results by using FactWorkItemTestResult 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 Test Results Using the Test Perspective in the Analysis Services Database for Visual Studio ALM.

Fact Table for Work Items linked to Test Results

FactWorkItemTestResult is associated with the following dimension tables:

  • DimTeamProject

  • DimTestResult

  • DimWorkItem

See Also

Concepts

Analyzing Test Results Using the Test Perspective in the Analysis Services Database for Visual Studio ALM

Test Result Tables

Current Work Item Tables

Testing the Application

Generating Reports Using the Relational Warehouse Database for Visual Studio ALM

Other Resources

Test Management Reports