Share via


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.

Email

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

See Also

Concepts

Fact Table Relationships

Other Resources

Understanding the Structure of the Data Warehouse Cube