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.
External Resources
Working with Online Analytical Processing (OLAP)