RRDI: RTC "Quality of planning" report
One answer
If you're only interested in the numbers, as opposed to the actual list of work items, then you should be able to use Request Baseline (I think the view is VW_RQST_BASELINE). It's similar to WORKITEM_STATES if you're familiar with the BIRT model. It gives you discrete measurements at each ETL run of work item counts. So it can answer the question of, for example, last Wednesday at midnight (or whenever the ETL ran), how many work items were planned for M5 (or in the open state, or owned by James, or whatever). For completed work items per iteration, the Request table might be able to give you what you want there, if it's as simple as querying for work items planned for an iteration and in the closed state (i.e. if you don't care about proving that it actually got closed during that iteration).
Comments
Thanks James. Re: " i.e. if you don't care about proving that it actually got closed during that iteration" , we do want to be sure that the count is what actually got closed during the iteration. Is there a way to find out when an iteration was actually closed? We also thought of creating a Plan Snapshot when the iteration is done, but I don't think any of the Plan Snapshot information makes into the DW?