Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Team Foundation Server Data Warehouse

Updated: July 2010

Team Foundation Server includes a data warehouse where data from work item tracking, source control, builds, testing tools, and third-party tools (if any) are stored. This data is used by Team Foundation for its built-in reporting functionality. The warehouse includes both a relational and an OLAP database. The relational database is organized in an approximate star schema, and the OLAP database is a data cube derived from the relational database.

NoteNote:

For information about how to rebuild or troubleshoot the data warehouse, see How to: Rebuild the Team System Cube and Troubleshooting the Data Warehouse.

Each Team Foundation tool contributes one or more facts to the data warehouse. Each type of fact has a primary relational table and a cube in the OLAP database that draws from that table. Each fact is composed of dimensions, measures, and details.

  • Dimensions are properties that are used to slice the data in a report. For example the Work Item facts include Type and State dimensions. Dimensions are realized in the relational database as tables, with foreign key references to the dimension tables from the primary fact table.

  • Measures are properties that are aggregated (counted, added, and so on) to provide the quantitative values in reports. The CodeChurn cube provided by the source control tool, for example, includes Lines Added, Lines Deleted, and Lines Modified measures. Measures are columns in the primary fact table.

  • Details are columns that appear in the relational database only. They are generally longer text strings like work item titles that are primarily used in list reports that can be drawn as efficiently from a relational database as it can from an OLAP database. Details are columns in the primary fact table that do not appear in the OLAP cube.

All the facts have a project dimension that can be used to slice the data in the warehouse by team project.

Understanding the Data Warehouse Architecture

Describes the overall organization of the Team Foundation Server data warehouse.

Understanding the Structure of the Data Warehouse Cube

Describes the fact tables, dimensions tables, schemas, and perspectives that can be found in the data warehouse and are aggregated in the data cube.

Setting Properties for the Data Warehouse

Explains the procedures for changing the refresh frequency and security settings on the data warehouse.

Date

History

Reason

July 2010

Provided links to information about how to rebuild and troubleshoot the data warehouse.

Customer feedback.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.