Answering questions with the cube

I know I just posted about this, but as I was reading my mail, I ran across a conversation between an internal customer and Jimmy.  I found the questions and the fact that we can answer most of them with cube to be of interest.  Hope you agree:

1) List of developers and hours charged to projects per month.  Hours will be collected in WI.

This is very similar to Demo 3 in my blog.

2) List of developers and some measure of output – lines of code? Function point?

Take a look at demo 6 & 7.  You can replace Changeset or Build with [Date] to measure code churn over time.

3) List of developers and number of defects created with code they wrote

I don’t think you can do this out of the box.  In V1 you can associate changesets to work items, but there’s no distinction between “Caused By” and “Fix By”

4) List of developers and number of defects they marked as resolved and the defect was not resolved

Take a look at demo 4 & 5.  You can query the cube for resolved (state = resolved) rate and reactivation (previous state = closed or resolved, state = active) rate, their difference would give you what you want.  Unfortunately this is only a rough estimate since you can assign the bug to someone who didn’t resolve the bug when you reactivate.  To get the exact count would require complex MDX.  Let me know if you need help with this.

Comments (2)
  1. Tom says:

    Speaking about Case 1: If Task has been reassigned than Cumulative Completed Work values will not show up for old AssignedTo person. How do I overcome this problem?

  2. This is a great question…and one that I don’t have a great answer to.  Fundamentally, work is associated with a work item, not with a resource.  If it’s important to report on work by resource, the best way to do it would be to create a new work item instead of reassigning the old one when you need to change ownership of a partially completed item.  

    I’ve passed this scenario on to the project team so that they can consider how to address it in future releases.



Comments are closed.

Skip to main content