Yuval Mazor - Searching for Zen in Software Development

Writing a Simple TFS Report – Part 4: Publishing the Report

In the last post of this series we completed our report so that it contains all the graphical annotations we wanted.  It is now time to publish it to the server and make it available to our users .  Publishing the Report to the Server Once we have a report running on the local machine, publishing it is the easy part!  1.  Open the report that we worked on throughout the previous parts of the series 2.  From the main ribbon button, choose the Save As menu option.  The...

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

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...

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

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...

Writing A Simple TFS Report– Part 0: Introduction

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...

Retrieving Unit Test Results for Builds in TFS 2010

Have you ever wanted to use the TFS 2010 data warehouse for retrieving the unit test pass/fail count for a specific build?  Maybe you wanted a report showing the number of unit tests that ran during each nightly build last week.  In any case, if you wanted this or something similar, you soon found out an interesting fact – picking out only unit tests from the warehouse is not trivial.  Here is the query for doing this: SELECT BuildName AS 'Build',   COALESCE([Passed],0...