Changes and Additions to the Schema for the Analysis Services Cube

If you have customized reports that you want to continue to use with your upgraded team project, you will need to update these reports to accommodate changes made to the schema. This topic describes the changes and additions that have been made to the schema for the SQL Server Analysis Services database with the release of Visual Studio Team Foundation Server 2010.

For more information about the Analysis Services database, see Perspectives and Measure Groups Provided in the Analysis Services Cube for Team System.

In this topic

• Summary of Changes and Additions

• Changes and Additions Made to Measure Groups

• Changes and Additions Made to Dimensions

Summary of Changes and Additions

The Analysis Services cube is now more usable, with increased query performance, improved translation, and load performance. The changes and additions introduced with the current schema came about due to changes in the infrastructure within Team Foundation Server, to enable reporting across team projects and team project collections, and to improve usability and performance of the database. All reportable data from all team projects that are defined in all team project collections for a deployment of Team Foundation Server is written to a single relational data warehouse. Data from that warehouse is then processed and written to the Analysis Services cube. Collecting data into a single data warehouse supports reporting across project collections.

Summary of Changes

Changes to the schema are summarized as follows:

• Many date and person-name fields that were top-level dimensions are now attributes of the Test Case and Work Item dimensions. A top-level Date dimension remains that you can use to build trend reports that combine measures from multiple measure groups like work items and test results.

• The Area and Iteration dimensions have been redesigned as attributes of the Test Case and Work Item dimensions as true hierarchies and are 14 levels deep similar to that provided by the Work Item Tracking (WIT) operational store.

• Some measure groups have been renamed to make them more meaningful. The following table provides a mapping of the name changes.

  Previous name	New name
  Code Coverage from Build	Build Coverage
  Build	Build Details
  Code Coverage from Run	Run Coverage
  Test Result	Test

• Several dimensions have been renamed to make them more meaningful and provide context, especially when looking at the entire list. The following table provides a mapping of the name changes.

  Previous name	New name
  Changeset	Version Control Changeset
  Filename	Version Control File
  Flavor	Build Flavor
  Platform	Build Platform
  Result	Test Result
  Run	Test Run
  Source Project	Build Source Project File

• Many measures have been renamed to make them more meaningful and provide context. For a summary of all measures, see Perspectives and Measure Groups Provided in the Analysis Services Cube for Team System. Some examples of measures that have been renamed are as follows:

  • In general, the names of measures that were pre-pended with the label Cumulative have been renamed. The Cumulative label is either dropped or the Trend label appended. For example, Cumulative Completed Work is now Completed Work, and Cumulative Result Count is now Result Count Trend.

  • The measure Count for the Build Coverage measure group is now labeled Build Coverage Count.

• The following test-related dimensions are now attributes: Outcome, Run By, Owner.

• The dimensions that began with "Related" are now attributes available from the Linked Test Case and Linked Work Item dimensions.

• Measure groups and dimensions associated with load testing have been removed.

Summary of Additions

Additions to the schema are summarized as follows:

• The following new measure groups and dimensions are introduced to support enhancements to work item tracking:

  Measure groups	Dimensions
  Linked Current Work Item Linked Current Work Item Test Case Work Item to Category Work Item to Tree Work Item With Result	Test Case Work Item Changeset Work Item Category Work Item Link Type Work Item Linked Work Item Tree

  Note

  The Linked Current Work Item and Linked Current Work Item Test Case measure groups have no measures associated with them. They are not meant to be directly used.

  The Test Case dimension provides a built-in filter of test cases which is a new work item type introduced with the current release.

  Work item types can now be grouped into categories. For example, the Bug category can find or report on types of work items that are labeled Bug, Defect, or Code Defect. The Work Item Category dimension enables cross-project reporting across different work item types that belong to the same category.

  The Analysis Services cube now supports work item hierarchy and linking. You can generate reports based on single hop links using the Linked Work Item dimension, and reports based on a tree hierarchy using the Work Item Tree dimension.

• The following new dimensions are introduced to support enhancements made to managing test efforts and to support Microsoft Test Manager:

  • Test Case

  • Test Configuration

  • Test Plan

  • Test Suite

• Area Path and Iteration Path are now available as attributes in the Test Case and Work Item dimensions. You can use these attributes to display a flat text string of the path in reports.

• To support usability, display folders have been added to the Test Case and Work Item dimensions. Fields are grouped under folders based on the reference names assigned to each field. Dimension attributes are organized into folders that are based on the reporting reference name that is assigned in the work item type definition. The following types of mapping occur:

  • Intrinsic or fields that have the "System" prefix are listed under the Work Item dimension.

  • Other fields are put under dimensions whose names correspond to the prefixes in their reference names. For example, fields that have the "Microsoft.VSTS.Common" prefix are listed under the folder that is labeled "Microsoft.VSTS.Common."

  For example, work item fields are listed under the Work Item dimension, as the following illustration shows:

  

  For more information, see Adding and Modifying Work Item Fields to Support Reporting.

Changes and Additions Made to Measure Groups

In the current schema version, new measure groups have been introduced, some previous measure groups have been renamed, and a few measure groups have been removed. The following illustration shows the measure groups that are provided in the current schema for Team Foundation.

Note

The Current Work Item, Linked Current Work Item, and Linked Current Work Item Test Case measure groups have no measures associated with them. They are not meant to be directly used.

The following table indicates the changes made to previous measure groups that have been renamed:

Name assigned in previous schema versions	Name assigned in the current schema version	Change introduced	Notes
	Build Changeset	New	Supports reports that are focused on builds and version control changesets. Includes a cumulative count of version control changesets within builds.
Code Coverage from Build	Build Coverage	Renamed	Supports reports that are focused on the extent to which the code was covered by tests that were performed against the build.
Build	Build Details	Renamed	Supports reports that are focused on the status, quality, and duration of builds.
Build Project	Build Project	No change	Supports reports that are focused on builds and build source project files.
Code Churn	Code Churn	No change	Supports reports that are focused on the number of file versions that are stored in Team Foundation version control and the extent to which the code has changed.
Current Work Item	Current Work Item	Redesigned	Use the Work Item measure group. No measures are associated with the Current Work Item measure group. It is not meant to be directly used.
	Date	New	Supports filtering reports by date fields, such as Activated Date and Changed Date.
	Linked Current Work Item	New	Use the Work Item measure group. No measures are associated with the Linked Current Work Item measure group. It is not meant to be directly used.
	Linked Current Work Item Test Case	New	Use the Work Item measure group. No measures are associated with the Linked Current Work Item Test Case measure group. It is not meant to be directly used.
	Numeric	New	Supports filtering reports by numeric fields.
Code Coverage from Run	Run Coverage	Renamed	Supports reports that are focused on the extent to which the code was covered by tests in a test run.
Test Result	Test	Renamed	Provides metrics about test runs and test results. Test results are tracked over time and can be analyzed by their outcome, the build they were testing, the type of test, and other dimensions. The Test Case Count measure has been added.
Work Item	Work Item	Redesigned	Provides metrics and detailed information about work items, including historical information that enables total work item counts to be analyzed over time or as of a current date. You use this measure group to generate trend reports and reports based on other measures that have been assigned to work item fields. For more information, see Adding and Modifying Work Item Fields to Support Reporting.
	Work Item Changeset	New	Supports reports that are focused on details that relate to work items and changesets.
	Work Item To Category	New	Supports reports that contain work items that are found by their associated category. You use categories to associate similar types of work items that are labeled differently. For more information about categories, see Grouping Work Item Types into Categories.
	Work Item To Tree	New	Contains a count of work items under a tree node and fields that support reporting on work items and tree types. For more information about the tree link type, see Working with Link Types.
	Work Item With Result	New	Supports reports that contain work items and test results. Contains a count of work items that are linked to a test result and fields that support reporting on work items and their associated test results.
Load Test Counter Load Test Results Load Test Summary Load Test Transaction		Removed	These measure groups and their associated dimensions are no longer supported.
Work Item History		Removed	You now use the Work Item measure group and include the Date measure to show historical trends.

Changes and Additions Made to Dimensions

In the current schema version, dimensions have been introduced, renamed, or removed. The following illustration shows the dimensions that are provided in the current schema for Team Foundation. 

Some dimensions are used in more than one measure group. For example, the Date, Team Project, Person, Area, and Iteration dimensions are shared by all measure groups.

The following table indicates the changes made to the schema dimensions. For more information, see Perspectives and Measure Groups Provided in the Analysis Services Cube for Team System.

Grouping	Name used in previous schema	Name used in current schema	Change introduced	Description
Assembly	Assembly	Assembly	No change	Name of the test assembly for which statistics were generated.
Build	Build	Build	No change	Number or name used to uniquely identify the build.
	Build Quality	Build Quality	No change	The current quality of the build. For more information, see Rate the Quality of a Completed Build.
	Build Status	Build Status	No change	The updated status as the build proceeds.
	Flavor	Build Flavor	Renamed	The build configuration. For more information, see Understanding Team Foundation Build Configuration Files.
	Platform	Build Platform	Renamed	The hardware platform for which the build was made (for example, x86 or Any CPU).
	Source Project	Build Source Project File	Renamed	The extension of the name of the source file.
Date	Date	Date	No change	Supports filtering by date.
Date fields	Activated Date Closed Date Created Date Resolved Date Finish Date Start Date	Activated Date Closed Date Created Date Resolved Date Finish Date Start Date WorkItem.Activated Date WorkItem.Closed Date WorkItem.Created Date WorkItem.Resolved Date WorkItem.Finish Date WorkItem.Start Date	Attribute	These data dimensions are now attributes of the Test Case and Work Item dimensions.
Link relationships	Related Area Related Assigned To Related Changed By Related Date Related Iteration Related Found In Related Integration Build Related Activated Date Related Closed Date Related Resolved Date Related Finish Date Related Start Date Related Created Date Related Team Project Related Work Item		Replaced	Dimensions starting with ‘Related…’ are now available under the Linked Work Item dimension, or as attributes under the Work Item Linked dimension.
Load testing	Agent Machine Counter ID (Load Test Counters) Load Test Scenario Load Test Transaction Machine Page Summary (Load Test) Scenario		Removed	All dimensions and measure groups associated with load testing are no longer supported.
Product hierarchies	Team Project	Team Project	No change	Supports filtering of reports based on the names of team projects and project collections. Supports generating reports that include data from multiple team projects.
Product hierarchies	Area Iteration	Area Hierarchy Area Path Iteration Hierarchy Iteration Path WorkItem.Area Hierarchy WorkItem.Area Path WorkItem.Iteration Hierarchy WorkItem.Iteration Path	Attributes Redesigned	The Area and Iteration dimensions have been redesigned as attributes of the Test Case and Work Item dimensions. The hierarchies provide support for 14 levels.
Test		Test Case	New	Container for the information that is defined for test cases. Contains the attributes of work item fields that are captured for the test case type of work item and that have been assigned as reportable. For more information, see How to: Create a Manual Test Case.
		Test Configuration	New	Container for the information that is defined for test configurations. For more information, see How to: Create Test Configurations.
		Test Plan	New	Container for the information that is defined for test plans. For more information, see How to: Create a Test Plan.
		Test Suite	New	Container for the information that is defined for test suites. For more information, see How to: Create and Manage Test Suites.
Test result	Category		Redesigned	The Category dimension is no longer supported. This dimension was used to capture a parent-child hierarchy of test results categorized according to the test list in which they were run. Test efforts are now defined using test plans, test suites, and test cases. See also the Test Suite dimension.
	Finished Date	Completed Date	Attribute Renamed	The finish date of the test run that generated the result is now the Completed Date attribute of the Test Run dimension.
	Outcome	Outcome	Attribute	The outcome of the test, for example, Passed, Failed, or Inconclusive, is now an attribute of the Test Result dimension.
	Owner		Attribute, Renamed	The author or current owner of the test has been replaced with the following attributes: Test Plan Owner attribute of the Test Plan dimension Test Result Executed By attribute of the Test Result dimension Test Result Owner attribute of the Test Result dimension
	Result	Test Result	Renamed	Container for the information that is captured for test results, including the outcome, the resolution state, and the failure type. For more information, see How to: View Test Results Using Microsoft Test Manager.
	Test Result Area Test Result Date Test Result Iteration Test Result Team Project		Attributes, Replaced	The associated dimensions are now attributes of the Test Case and Test Plan dimensions.
Test run	Run	Test Run	Renamed	Container for the information that is captured for test runs. For more information, see How to: Analyze Test Runs Using Microsoft Test Manager.
	Run By	Test Run Owner	Attribute, Renamed	The name of the person or account under which the test was run is now the Test Run Owner attribute of the Test Run dimension.
Version control	Checked In By	Checked In By	Attribute	The name of the person who checked in code modifications is now an attribute of the Version Control Changeset dimension.
	Changeset	Version Control Changeset	Renamed	Container for the information that is defined for a changeset that was checked into version control. This information includes the ID, who checked in the changeset, the description, and any policy override comments. For more information, see Working with Changesets.
	Filename	Version Control File	Renamed	A hierarchy of the directories and files in the version control database.
Work item	Assigned To Changed By Created By	Assigned To Changed By Created By WorkItem.Assigned To WorkItem.Changed By WorkItem.Created By	Attributes	These person-name fields are now attributes of the Test Case and Work Item dimensions.
	Found In	Found In WorkItem.Found In	Attributes, Renamed	The build in which the bug was found is now an attribute of the Test Case and Work Item dimensions. Each attribute is located under the Microsoft.VSTS.Build folder under each dimension.
	Integration Build	Integration Build WorkItem. Integration Build	Attributes	The build in which the bug was fixed is now an attribute of the Test Case and Work Item dimensions. Each attribute is located under the Microsoft.VSTS.Build folder under each dimension.
	Work Item	Work Item	Redesigned	Container for the information that is defined for work items. Contains the attributes of work item fields that have been assigned as reportable. For more information, see Adding and Modifying Work Item Fields to Support Reporting.
	Work Item History Area Work Item History Date Work Item History Iteration Work Item History Team Project	Work Item	Redesigned	The Work Item dimension now supports reporting on the history of work items.
		Work Item Category	New	Container for the information that is defined for categories of work items. You use categories to associate similar types of work items that are labeled differently. For more information about categories, see Grouping Work Item Types into Categories.
		Work Item Link Type	New	Container for the information that is defined for link types. For more information, see Working with Link Types.
		Work Item Linked	New	Container for the information that is defined for work items that are linked. These attributes support generating reports of work items that are related with one-hop links. For more information, see View and Modify Work Items in a Direct Links View.
		Work Item Tree	New	Container for the information that is defined for work items that are related using tree-topology link types, such as parent-child links. These attributes support generating reports of work items that are related with a nested set of links. For more information, see View and Modify Work Items in a Tree View.

See Also

Concepts

What's New for Reporting for Visual Studio ALM

Adding and Modifying Work Item Fields to Support Reporting

Locating Reports After the Upgrade to Team Foundation Server 2010

What's New for Reporting for Visual Studio ALM

Updating an Upgraded Team Project to Access New Features