TFS 2017 | TFS 2015 | TFS 2013
Excel reports, Reporting Services reports, and SharePoint dashboards are only supported for on-premises TFS. For information on what is supported for Team Services, see Dashboards and reports overview.
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 Test cases and work items.
FactWorkItemToCategory is associated with the following dimension tables: