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.

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

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.

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