Reporting on user in History

Question

I am trying to do a simple report that given a date range and user, will give me a list of all work items (or even just the number) that user has been assigned to in that date range. Since the history has the data, I thought this would be easy but I don't see how to retreave the information.
I have gone through the "Creating and Customizing TFS Reports", and thought I had found a way to at least get the number using the State change Count but it appears to be only counting state changes while assigned to the user - and that is not what I am looking for.
Could someone give me a clue for where to start?

Answer 1

I also tried to make a report with this kind of information, and started using the SSAS cube, but because of the architecture of the cube and my little knowlegde of MDX, I used the relational warehouse database TfsWarehouse to solve my problem.

This post (http://www.ewaldhofman.nl/post/2009/10/03/Update-Time-sheet.aspx) shows what I did.

---

Ewald - Please remember to mark the replies as answers if they help.


Blog: www.ewaldhofman.nl

Answer 2

Hi westfisher,

If you want to get a list of workitem assigned to a user in a date range, you can use Work Item History Cube.

In the query designer, selete Work Item History Cube, then select Cumulative Count as mesaure,  Woritem.ID,WorkItem.Title, Assigned To.Alias as dimension.

Make dimension "Date.Date" as an Range(Includive) parameters.

Best Regards,
Ruiz

 

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi