I have just finished a sample Warehouse Adapter that demonstrates how to customize the Warehouse and Analysis databases. This is a fairly simple sample, but should help out anyone considering customizing the Warehouse. Take a look: http://code.msdn...

Quite a while ago I added a blog post about using compensating records to get Work Item data as of a specific data from the Warehouse. TFS Warehouse Work Item Tracking Compensating Records In TFS 2010 we have added a new field, Revised Date, that...

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

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

I am a Developer for Visual Studio Team Foundation Server at Microsoft on the Reporting or BII team (it depends who you ask) and thought I would start a blog. I know there are lots of questions about Reporting on TFS data out there - hopefully I can address...

There is a lot of ways to get data out of the TFS Reporting Warehouse and into a report. Things like Excel and Reporting Services RDL Reports work well for people. Typically people use these tools to pull data from the Cube and display it in a consumable...