Writing a Simple TFS Report–Part 3: Adding the Final Touches

30/12/2011

In the last post of this series, we created a report that visually displayed the data we extracted from the TFS 2010 warehouse.  In this post, we’ll add some additional enhancements to the report in order to increase its effectiveness.  As you recall, we want our report to look like this: While right now our report looks like this: This means we need to add the following enhancements: 1.  Change the report’s title and fields 2.  Make sure that cells which have a reason of Fixed have a green...

Writing a Simple TFS Report – Part 2: Creating the Report

23/12/2011

Welcome back!  In the last part of this series we discussed the actual query needed to extract the data from the TFS relational data warehouse.  In this post, we’ll see how to use this query in order to create an actual report.    Choosing a Report Authoring Tool In order to actually produce our report we need a report authoring tool.  This tool should allow us to design our report in a WYSIWYG manner and specify the query for getting the data.  We would normally choose from the following options: Business...

Writing A Simple TFS Report – Part 1: Getting the Data

16/12/2011

In the last post we saw the final result of what we’re aiming for – the Bug’s Life report.  In this post, we’ll start working on the report by actually extracting the data. The TFS Reporting Data Sources TFS supplies us with two different data sources for reporting needs: The data warehouse – A relational data store that is designed using a snowflake schema and is named Tfs_Warehouse.  By default, this database is updated within 30 minutes of an anything ‘interesting’ happening in TFS.  We query this database using the SQL language. ...
no comments

“IBuildDetail not defined” error in TFS 2010 Build Templates

12/12/2011

Recently I started receiving the following error when trying to edit TFS 2010 build templates on my machine: Type ‘IBuildDetail’ is not defined This was exceptionally weird as TFS was running happily for quite a while.  Turns out the culprit was the Developer Preview edition of Visual Studio 11 that I installed alongside the existing VS2010.  Anyway, in order to solve the problem: 1.  Open your build template (the .xaml file) in code mode.  (From the Source Explorer, right-click the file, choose ‘View With…’ and select ‘XML (Text) Editor’. 2.  Locate the first...
2 comments

Writing A Simple TFS Report– Part 0: Introduction

09/12/2011

In this series of blog posts, I will show how to write a simple report that makes use of the integrated business intelligence (BI) capabilities that are available in TFS 2010.  If you’re unfamiliar with how to use this great feature, this series is for you!  This first post will describe the final “product'” we’d like to construct. What We’re Aiming For Our end result for this series is the aptly-named Bug’s Life report: For each specific bug ID, the report shows us the various states that the bug went through, along with the...
no comments