Teams WIT Tools

Musings on Project Management, Work Item Tracking and Reporting from the TFS team

Browse by Tags

Tagged Content List
  • Blog Post: Reporting in Team Foundation Server 2010: Part 6: Rich SQL Reporting Services Reports

    I started this series with a set of topics and broke the first one down into sub topics to cover the out-of-the-box experience in detail. With my last post , I covered the dashboards portion of the experience. Let’s look at the new SQL Reporting Services (SSRS/RS) reports written in Report Definition...
  • Blog Post: Reporting in Team Foundation Server 2010: Part 5: SharePoint Foundation Dashboard

    In my last post , I covered the topic on creating a team dashboard. Let’s look at the dashboard experience on Windows SharePoint Services / SharePoint Foundation: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint...
  • Blog Post: Reporting in Team Foundation Server 2010 – Part 4: SharePoint Dashboards: Creating a team dashboard

    In my last post , I covered customizing the SharePoint Server dashboard. The next topic is creating a team dashboard: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint Services/SharePoint Foundation dashboard...
  • Blog Post: Reporting in Team Foundation Server 2010 – Part 3: SharePoint Dashboards: SharePoint Server dashboard customization

    In my last post , I covered the out-of-the-box experience with SharePoint Server dashboard. Let’s look at the next item on the list, customizing the dashboard: SharePoint Dashboards SharePoint Server dashboard Out-of-the-box experience Customizing the dashboard Creating a team dashboard Windows SharePoint...
  • Blog Post: Reporting in Team Foundation Server 2010 – Part 2: SharePoint Dashboards: SharePoint Server dashboard

    In my last post , I outlined the out-of-the-box reporting options available in 2010: SharePoint Dashboards Rich SQL Reporting Services (SSRS) Reports Excel Reports from Work Item Queries Let’s walkthrough the dashboard experience when you integrate TFS with SharePoint. I’ll break this topic down a bit...
  • Blog Post: Reporting in Team Foundation Server 2010 – Part 1: Introduction

    This is the first chapter in the series on Reporting in Team Foundation Server (TFS) 2010. In this series, I’ll cover the following topics: Walkthroughs for out-of-the-box experience including customizations Custom report authoring tools and walkthroughs An overview of the reporting architecture Read...
  • Blog Post: Team Foundation Server 2010 - Relational Warehouse and Cube Schema Changes

    Team Foundation Server 2010 is a BIG release for us by all counts. We have made conceptual changes; Brian introduced some of the key concepts in TFS 2010 that includes the concept of Team Project Collections (TPCs). These changes required a lot of infrastructure support that we built from the ground...
  • Blog Post: Previous State and State Change Count

    Today I am going to look at two interesting fields in the Warehouse related to Work Items – Previous State, and State Change Count. The Previous State field stores the state a Work Item was in before it entered its current state. This field is in the [Work Item] table in the relational/dimensional...
  • Blog Post: TFS Warehouse Work Item Tracking Compensating Records

    Compensating Records What are compensating records? First a little background. Whenever a work item is updated a new revision is created. These revisions are moved over to the Warehouse and stored in the various Work Item Dimension and Fact tables. Each revision will be in the Warehouse – however...
  • Blog Post: How Microsoft/DevDiv uses TFS - Chapter 6 (Addendum)

    In my previous post , some people asked how we went about creating the report I talked about. I asked the fellow who created this report internally. Here was his response, which I'm passing on to you. (Thanks Doug!) NOTE: I've also attached the .RDL file he forwarded along. being quote> ...
  • Blog Post: Demo - tutorial: Building a TFS report using Report Designer

    I gave a talk to an internal team sometime last year on building TFS reports. The talk was recorded and I rediscovered that video a few days ago. I did a couple of report-building demos during the talk. Here's one of them:       Ameya Bhatawdekar Program Manager, Team Foundation Server
  • Blog Post: As of Today TFS Cube Report in Excel

    This walk through shows you how to get started using Excel to build a TFS report displaying Cube data relative to today. When you build a report using an Excel Pivot Table often you want to filter that data by a date relative to today. For example you would like to see the number of Active Work Items...
  • Blog Post: FAQ #6: How do I change the frequency that the reporting warehouse updates?

    This tip comes from Markus Hain : The default update frequency is 3600 seconds (1 hour), below are the steps to change the time. 1. Log on to the application tier of Team Foundation Server. 2. Start Internet Explorer. 3. In the Internet Explorer Address box, type http://localhost:8080/Warehouse/v1.0...
  • Blog Post: Radius 90 v2 from 90 degree software has Analysis Services Support!

    Last month, 90 degree software released their Radius 90 v2. The Radius tools are all about making report design and analysis simple. Radius 90 has an easy-to-use Fluent UI style made popular by Office. One of the key additions was the support of Analysis Services -- which means that we can now...
  • Blog Post: New content on creating custom reports

    There is new content on MSDN on building custom reports. Allen Clark has more details about it on his blog post: http://blogs.msdn.com/vstsue/archive/2007/08/29/new-content-available-on-creating-custom-reports.aspx
  • Blog Post: Understanding the TFS Cube

    The initial learning curve for the TFS Cube is pretty steep. It is quite overwhelming to figure out the relationships between the large number of dimensions and measure groups in the TFS cube at first. In this blog entry I will explain some of the most commonly used perspectives and show how you can...
  • Blog Post: TFS Report developer resources

    Mauli, a core reporting team member, has compiled a great reference list of articles, reference documentation, tutorials and blogs for report developers. From: Mauli Shah Hi all, There have been a lot of questions about references for making reports. I’ve been keeping a running list of references...
  • Blog Post: Team Foundation Server Reporting and Visio 2007

    Visio 2007 has some very cool new reporting features. I'm very excited about the the PivotDiagram features in particular. PivotDigrams can be used to slice and dice data just like Pivot Tables in Excel. Here's an example of a Visio report that shows the active and resolved bug and task distribution across...
  • Blog Post: A cool report authoring tool

    In V1, the primary report authoring options are 1/ write SQL Server Reporting Services (SSRS) reports using Visual Studio Report Designer (part of the Business Intelligence Studio – or BIDS) 2/use Excel to connect to the cubes and build reports. Users can use also use Report Builder, a report authoring...
  • Blog Post: Tell us what you think about TFS Reporting

    Reporting is a very powerful feature in TFS. It has a lot of capabilities and can provide some very deep and meaningful insights across the development lifecycle. But, some of our customers aren't using the reporting system to its fullest potential. The reporting team is interested in learning more...
Page 1 of 1 (20 items)