Dimension Tables
Dimension tables store the values that are used in the fact tables. The dimension tables that appear in the Team System warehouse are either created at the time the product is installed or are created at the time the team project is created.
Dimension Tables Created During Setup
The following table shows the dimensions tables stored in the Team System relational database that are created at the time the product is installed and appear in all Team System data warehouses.
| Table | Description |
|---|---|
Area |
Contains one row for each area defined in all team projects on the Team Foundation Server. |
Assembly |
Contains one row for each assembly tested by a team project on the Team Foundation Server. |
Build |
Contains one row for each build defined in all team projects on the Team Foundation Server. |
Build Flavor |
Contains one row for each build flavor defined in all team projects on the Team Foundation Server. |
Build Quality |
Contains one row for each measure of build quality defined in all team projects on the Team Foundation Server. |
Build Status |
Contains one row for each status defined for a build in all team projects on the Team Foundation Server. |
Changeset |
Contains one row for each changeset defined in all team projects on the Team Foundation Server. |
Date |
Contains one row for each date defined in all team projects on the Team Foundation Server. |
File |
Contains one row for each file checked into version control in all team projects on the Team Foundation Server. |
Iteration |
Contains one row for each iteration defined in all team projects on the Team Foundation Server. |
Load Test Counter Dimension |
Contains one row for each load test defined in all team projects on the Team Foundation Server. |
Load Test Page Summary Dimension |
Contains one row for each load test summary defined in all team projects on the Team Foundation Server. |
Load Test Scenario |
Contains one row for each load test scenario defined in all team projects on the Team Foundation Server. |
Load Test Transaction Dimension |
Contains one row for each load test transaction defined in all team projects on the Team Foundation Server. |
Machine |
Contains one row for each computer used by a team project to build a software project. |
Outcome |
Contains one row for each outcome defined in all team projects on the Team Foundation Server. |
Person |
Contains one row for each team project member defined in all team projects on the Team Foundation Server. |
Platform |
Contains one row for each platform defined for a build type in all team projects on the Team Foundation Server. |
Result |
Contains one row for each result defined in all team projects on the Team Foundation Server. |
Run |
Contains one row for each run defined in all team projects on the Team Foundation Server. |
Team Project |
Contains one row for each team project defined on the Team Foundation Server. |
Test Category |
Contains one row for each test category defined in all team projects on the Team Foundation Server. |
Work Item |
Contains one row for each work item defined in all team projects on the Team Foundation Server. |
Team Project Dimension Table
The following table describes the columns in the Team Project dimension table.
| Field | Description |
|---|---|
ID |
Record ID for the table (used internally). |
Project Uri |
The Uniform Resource Identifier (URI), a character string identifying the team project from anywhere on the Internet by type and location. Set in the New Team Project Wizard at the time the team project is created. For more information, see How to: Create a Team Project. |
Team Project |
The name of the team project. |
LastUpdatedTime |
Date and time the record was last inserted or updated. |
DimensionMemberActive |
Value describing whether the dimension member has been fully populated (used internally). |
Area Dimension Table
The following table describes the columns in the Area dimension table.
| Column | Description |
|---|---|
ID |
Identifying number for the record in the table (used internally). |
Area |
The Area in which the work item is classified. |
Area Uri |
The Uniform Resource Identifier used by Team Foundation Server to identify the area. |
Parent Area Uri |
The Uniform Resource Identifier used by Team Foundation Server to identify the parent of the area. |
Area Path |
The fully qualified path of the area. |
Forwarding ID |
An internal ID that indicates the new ID of a node when a change is made to the structure of the hierarchy. |
Parent_ID |
A reference to the key that contains information about this area node in the hierarchy. For example, if the data row represents the file “/a/b/c,” the parent_ID will contain the key value of the row that contains “/a/b.” |
LastUpdatedTime |
Date and time the record was last inserted or updated. |
DimensionMemberActive |
Value describing whether the dimension member has been fully populated (used internally). |
Iteration Dimension Table
The following table describes the columns in the Iteration dimension table.
| Column | Description |
|---|---|
ID |
Identifying number for the record in the table (used internally). |
Iteration |
The Iteration dimension contains a single hierarchy which correlates the measures in the cube according to the iteration classification with which they are associated. The iteration hierarchy is a parent-child dimension that allows for the measures to be summarized or filtered according to their location in the iteration hierarchy. |
Iteration Uri |
The Uniform Resource Identifier used by Team Foundation Server to identify the iteration. |
Parent Iteration Uri |
The Uniform Resource Identifier used by Team Foundation Server to identify the parent of the iteration. |
Iteration Path |
The fully qualified path of the iteration. |
Forwarding ID |
An internal ID that indicates the new ID of a node when a change is made to the structure of the hierarchy. |
Parent_ID |
A reference to the key that contains information about this iteration node in the hierarchy. For example, if the data row represents the file “/a/b/c,” the parent_ID will contain the key value of the row that contains “/a/b.” |
LastUpdatedTime |
Date and time the record was last inserted or updated. |
DimensionMemberActive |
Whether the dimension member has been fully populated (used internally). |
Person Dimension Table
The following table describes the columns in the Person dimension table.
| Field | Description |
|---|---|
ID |
Identifying number for the record in the table (used internally). |
Person |
Display name of the person or group. |
SID |
Security identifier for the person or group that logged on to the network. |
Domain |
The domain to which the user or group belongs. |
Alias |
User name of the person or group. |
E-mail name used to direct messages. |
|
LastUpdatedTime |
Date and time the record was last inserted or updated. |
DimensionMemberActive |
Value describing whether the dimension member has been fully populated (used internally). |
Date Dimension Table
The following table describes the columns in the Date dimension table.
| Field | Description |
|---|---|
ID |
Identifying number for the record in the table (used internally). |
UTCDateTime |
A time instant in Coordinated Universal Time (or Greenwich Mean Time) time zone. UTCDateTime specifies the local time together with the time differential between that time zone and the Prime Meridian. |
Year |
The year in the local time zone setting of the computer on which SQL Server is running. |
YearString |
A string used to represent the year of this row in the date table. The string is localized into the locale of Team Foundation Server. |
Month |
The month in the local time zone setting of the computer on which SQL Server is running. |
MonthString |
A string used to represent the month of this row in the date table. The string is localized into the locale of Team Foundation Server. |
Month of Year |
Numeric representation of the month of the year in the local time zone. |
Week |
The week in the local time zone setting of the computer on which SQL Server is running. |
WeekString |
A string used to represent the week of this row in the date table. The string is localized into the locale of Team Foundation Server |
Week of Year |
Numeric representation of the week of the year in the local time zone. |
Date |
The day component of the local time zone setting of the computer. Does not include the hour, minute, and second components. |
Day of Year |
Numeric representation of the day of the year in the local time zone. |
Day of Month |
Numeric representation of the day of the month in the local time zone. |
Day of Week |
Numeric representation of the day of the week in the local time zone. |
LastUpdatedTime |
Date and time the record was last inserted or updated. |
DimensionMemberActive |
Value describing whether the dimension member has been fully populated (used internally). |