Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » VSTS Planning &... » Reporting   (RSS)
Saturday, May 16, 2009 4:15 PM

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
Posted by sunder | 5 Comments
Wednesday, April 29, 2009 8:06 PM

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
Posted by nericson | 2 Comments
Friday, March 20, 2009 11:56 PM

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
Posted by nericson | 2 Comments
Wednesday, May 14, 2008 12:45 PM

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
Posted by Gregg Boer | 3 Comments
Attachment(s): FC High Level Summary of Work.rdl
 
Page view tracker