Understanding the Structure of the Data Warehouse Cube

The Visual Studio Team System data warehouse consists of a relational database and an SQL Server 2005 Analysis Services OLAP database that combine information from across the components of Visual Studio Team System.

In This Section

  • Fact Tables
    Describes the fact tables contained in the Team System relational database.

  • Dimension Tables
    Describes the dimension tables contained in the Team System relational database.

  • Fact Table Relationships
    Describes the relationships among the fact tables stored in the data warehouse.

  • Relational Schemas
    Introduces the relational schema for the data cube and shows a schema diagram.

  • OLAP Design
    Introduces the design of the online analytical processing (OLAP) for the Team System data warehouse.

See Also

Concepts

Getting Started With Custom Reports for Team System

Other Resources

Team Foundation Server Data Warehouse