Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Data Sources for Team Foundation Reporting

Team Foundation Server reporting uses two data sources, TfsReportDS and TfsOlapReportDS, for its pre-built reports. Both data sources can be viewed in Report Manager on the team project report site.

  • TfsReportDS points to the relational database TFSWarehouse using the connection type "Microsoft SQL Server." The reports delivered in the MSF process templates use the TfsReportDS connection to retrieve the last warehouse update that appears at the top of the report.

  • TfsOlapReportDS points to the Team System data cube in the analysis services database TFSWarehouse using the connection type "Microsoft SQL Server Analysis Services". All the pre-built reports use the TfsOlapReportDS data source to populate the report.

Because the data cube is designed to improve the efficiency of analyzing and reporting data, you should build your custom reports using the TfsOlapReportDS data source.

Community Additions

© 2015 Microsoft