Work Item Test Result Tables

  • Article

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 Analyze and Report on 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

Analyze and Report on 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

Generate Reports Using the Relational Warehouse Database for Visual Studio ALM

Other Resources

Test Management Reports