Work Item Category Tables

You can query for categories of work items by using the FactWorkItemToCategory and DimWorkItemCategory tables. You can organize the results of other work item queries by category if you join these tables with the DimWorkItem by using FactWorkItemToCategory.WorkItemTypeName = DimWorkItem.System_WorkItemType.

For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Analyzing Work Item and Test Case Data Using the Work Item Perspective.

FactWorkItemToCategory is associated with the following dimension tables:

• DimWorkItem

• DimWorkItemCategory

See Also

Concepts

Analyzing Work Item and Test Case Data Using the Work Item Perspective

What's New for Reporting for Visual Studio ALM

Generating Reports Using the Relational Warehouse Database for Visual Studio ALM

Other Resources

Grouping Work Item Types into Categories