Export (0) Print
Expand All

Changes and Additions to the Schema for the Analysis Services Cube

Visual Studio 2010

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

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

    NoteNote

    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:

    Folder structure in OLAP data cube

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

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.

Team System Measure Groups
NoteNote

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.

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. 

Team System Dimensions

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.

Community Additions

ADD
Show:
© 2014 Microsoft