Test Results Schema

Article
09/24/2007

The following diagram shows the relationships between the Test Result fact table and the related measures (dimensions) in the data warehouse.

Schema showing relationships among dimensions

Fact Tables

The Test Results Schema references a single fact table:

Test Result fact table (dbo.Test Result).

The Test Runs and Results Schema also references 13 dimension tables:

Run dimension table (dbo.Run)
Platform dimension table (dbo.Platform)
Outcome dimension table (dbo.Outocme)
Machine dimension table (dbo.Machine)
Build Flavor dimension table (dbo.Build Flavor)
Build dimension table (dbo.Build)
Test Category dimension table (dbo.Test Category)
Result dimension table (dbo.Result)
Team Project (dbo.Team Project) (see Shared Dimensions)
Area (dbo.Area) (see Shared Dimensions)
Date (dbo.Date) (see Shared Dimensions)
Person (dbo.Person) (see Shared Dimensions)
Iteration (dbo.Iteration) (see Shared Dimensions)

Test Result Fact Table

The following table describes the columns in the Test Result fact table.

Column	Description
__ID	Identifying number for the record in the table (used internally).
Result Record Count	A counter that represents the value of the test result as of the build with which the result is associated. This value is summed up in the OLAP cube to represent the latest value of the matching records as of a particular test result.
Result Count	A counter that represents a simple aggregation of the number of results run. This value is 1 for each record that represents a new result, and is NULL for those records that are used only for the purposes of aggregating “Result Record Count.”
Result Transition Count	A counter that represents a change in a test result throughout test runs against a specific build. When set to 1, this value indicates that the result value for this record differs from the previous result against the same build.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__TrackingId	Identifying number that is used by the warehouse infrastructure to track the record.
Result	Foreign key to the Result dimension table.
Build	Foreign key to the Build dimension table.
Run	Foreign key to the Run dimension table.
Area	Foreign key to the Area dimension table.
Iteration	Foreign key to the Iteration dimension table.
Date	Foreign key to the Date dimension table.
Outcome	Foreign key to the Outcome dimension table.
Finished Date	Foreign key to the Date dimension table.
Agent Machine	Foreign key to the Machine dimension table.
Category	Foreign key to the Test Category dimension table.
Owner	Foreign key to the Person dimension table.
Run By	Foreign key to the Person dimension table.
Platform	Foreign key to the Platform dimension table.
Flavor	Foreign key to the Build Flavor dimension table.
Team Project	Foreign key to the Team Project dimension table.

Run Dimension Table

The following table describes the columns in the Run dimension table.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Run ID	Identifying number (GUID) for the test run.
Run	Character name of the test run. Set in the Run Configuration Editor.
Run Description	Description of the test run. Set in the Run Configuration Editor.
Remote Run	Boolean value that indicates whether the test ran locally (inside Visual Studio) or remotely.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

Platform Dimension Table

The following table describes the columns in the Platform dimension table.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Platform	Platform defined for a build type.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

Outcome Dimension Table

The following table describes the columns in the Outcome dimension table.

Column	Description
__ID	Identifying number for the record in the table (used internally).
Outcome	Outcome of the test. Possible values include the following: Aborted Completed Disconnected Timeout Error Failed Inconclusive In Progress Not Executed Not Runnable Passed Passed (run aborted) Pending Warning
Outcome Passing	Boolean value that indicates whether the Outcome is passing the test. Possible values include the following: Passed Completed Warning
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

Machine Dimension Table

The following table describes the columns in the Machine dimension table.

Column	Description
__ID	Identifying number for the record in the table (used internally).
Machine	Name of the computer that is used.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

Build Flavor Dimension Table

The following table describes the columns in the Build Flavor dimension table.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Build Flavor	The configuration of the build. The possible values include the following: Debug Release Any valid configuration created by the process template. Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Whether the dimension member has been fully populated (used internally).

Build Dimension Table

The following table describes the columns in the Build dimension table. The table contains one row for each team build.

Field	Description
__ID	Identifying number for the record in the table (used internally).
Build Artifact Moniker	Identification number that is used to link an object, such as a work item, with a specific build.
Build	Number or name used to uniquely identify the build.
Build Type	Name of the build type. Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type. Selected from the Team Builds node in Team Explorer. For more information, see How to: Run a Build on a Build Type.
Drop Location	The server and share where the completed build will be put. Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.
Build Start Time	Date and time the build began
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Whether the dimension member has been fully populated (used internally).

Test Category Dimension Table

The following table describes the columns in the Test Category dimension table.

Column	Description
__ID	Identifying number for the record in the table (used internally).
Category ID	Identifying number (GUID) for the test category.
Test Category	Character name of the test category. Set in the Create New Test List dialog box.
Category Full Name	Full path of the test category.
Parent Category	Identifying number (GUID) for the parent category of the test category.
__Parent_ID	Identifying number (GUID) for the parent category.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Value describing whether the dimension member has been fully populated (used internally).

Result Dimension Table

The following table describes the columns in the Result dimension table.

Column	Description
__ID	Identifying number for the record in the table (used internally).
Result ID	Identifying number (GUID) for the test result.
Result	The name of the Test Result of the test. By default, this is the timestamp of the time at which the test was run.
Test	Identifying number (GUID) for the test.
Test Type	Name or GUID for the type of test.
Test Description	Character description of the test. Set in the property page.
Parent Result	Identifying number (GUID) for the parent test.
Result Root	Boolean value that indicates whether the test ran inside another test or as standalone test.
Error Message	Error message displayed when the test failed.
Load Test Agent List	List of the agents on which the Load test runs.
End Time	Date and time the test finished.
__LastUpdatedTime	Date and time the record was last inserted or updated.
__DimensionMemberActive	Whether the dimension member has been fully populated (used internally).