Skip to content

Latest commit

 

History

History
35 lines (26 loc) · 1.49 KB

work-item-test-result-tables.md

File metadata and controls

35 lines (26 loc) · 1.49 KB
title titleSuffix ms.technology ms.topic description ms.assetid ms.author author ms.date
Work Item Test Result tables
Azure DevOps Server
devops-analytics
reference
Use Work Item Test Result tables to query for data about work items that are linked to test results.
33dbfef7-c17b-4884-9a33-cfc61a1d7cd6
kaelli
KathrynEE
10/17/2017

Work Item Test Result tables

[!INCLUDE temp]

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 Test results.

Fact Table for Work Items linked to Test Results

FactWorkItemTestResult is associated with the following dimension tables:

  • DimTeamProject

  • DimTestResult

  • DimWorkItem

Related articles

Test results
Test Result tables
Current Work Item tables
Test Management Reports
Testing overview
Table reference for the relational warehouse database