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
Describes the fact tables contained in the Team System relational database.
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.
Introduces the relational schema for the data cube and shows a schema diagram.
Introduces the design of the online analytical processing (OLAP) for the Team System data warehouse.