Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Relational Schemas

You can use the relational schemas to better understand the way in which fact tables and dimension tables relate to one another in the Team Foundation data cube.

Build Schema

Describes the relationships between the three Build fact tables and the related measures (dimensions) in the data warehouse.

Code Coverage Schema

Describes the relationships between the Run Coverage and Build Coverage fact tables and the related measures (dimensions) in the data warehouse

Load Testing Schema

Describes the relationships between the five Load Test fact tables and the related measures (dimensions) in the data warehouse.

Source Control Schema

Describes the relationships between the Code Churn fact table and the related measures (dimensions) in the data warehouse.

Test Results Schema

Describes the relationships between the Test Result fact table and the related measures (dimensions) in the data warehouse.

Work Items Schema

Describes the relationships between the three Work Item fact tables and the related measures (dimensions) in the data warehouse.

Community Additions

ADD
Show:
© 2015 Microsoft