Share via


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.
  • 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.

External Resources

Working with Online Analytical Processing (OLAP)

See Also

Other Resources

Team Foundation Server Data Warehouse