It's all about the answers!

Ask a question

Data Warehouse: Parent - children links from RTC for work items, parent - children links for iterations

Kris Rovell-Rixx (36268) | asked Aug 22 '12, 10:59 a.m.

It seems the data warehose does not capture:

  • RTC parent and children work item attributes.
  • RTC parent - children relationships for iterations

We need those relationships to report the estimates and effort for hierarchies of work items and hierarchies of iterations within a single project and across multiple projects in an automated way.

If I missed something in the data dictionary please point me in the right direction. I know the relationships are in the API. We're hoping to use the existing reporting tool, in this case RRDI which works off of the data warehouse. Using the API would require that we custom build a lot of reporting and automation functionality.

We'd like to be able to answer questions such as how much effort has been accomplished against a particular high-level work item, a work item that might be a parent to many stories and grand-parent to even more tasks. If the data warehouse doesn't maintain information about parent and children relationships for work items, is there another way to derive how much work is represented by a grand-parent work item? We'd like to be able to answer these questions in an automated way across many high-level work items, and across RTC projects.

We also need to be able to know if an iteration is a low level iteration, or a parent for reasons similar to why we need the parent-child relationships of the work items.

Kris Rovell-Rixx commented Aug 23 '12, 9:27 a.m.

I found this link for work item parent-child relationships:

We were able to apply the suggestions to find parent-child work item relationships.

Does anyone know of something similar for iterations?

We're reluctant to use the API as it hits the live database and we can't afford to impact RTC's performance when we gather data for large numbers of project areas. We're trying to do all of our large scale reporting with RRDI where possible.

One answer

permanent link
Kris Rovell-Rixx (36268) | answered Aug 30 '12, 2:23 p.m.
RRDI 2.0, which ships with RTC 4.0, has access to the iteration hierarchy data. The iteration hierarchy data is not available in the RRDI that ships with RTC 3.0.1.
We will look again at extracting the information from the API and if that's not a good choice, we will wait until we can upgrade to RTC 4.0 and RRDI 2.0.

Thanks to everyone who helped us with the answer.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.