This topic has not yet been rated - Rate this topic

Test Result Tables

Visual Studio 2010

Visual Studio 2012

You can query for data about test results by using the FactTestResult 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 Test Results Using the Test Perspective in the Analysis Services Database for Visual Studio ALM.

In this topic

Test Results, Test Suites, and Test Plans
Test Results and Test Runs
Test Results and Builds
Test Results and Team Project Data

Test Results, Test Suites, and Test Plans

The DimTestResult table provides details about the test results themselves, and you can use the DimTestPlan and DimTestSuite tables to organize the results by test plan and test suite.

Test Results and Test Runs

You can use the DimTestRun, DimConfiguration, and DimPerson dimension tables to include data about how the tests were run.

Test Results and Builds

You can use the DimBuild, DimBuildFlavor, and DimBuildPlatform dimension tables, to include data about the build that was used to create the test results.

Test Results and Team Project Data

You can use the DimTeamProject, DimArea, and DimIteration tables to obtain details about how the tests are organized in the team project, and you can use DimDate to show when the test results were created.

Concepts

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

Testing the Application

Work Item Test Result Tables

Generating Reports Using the Relational Warehouse Database for Visual Studio ALM

Other Resources

Test Management Reports

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD