Data Warehouse: Parent - children links from RTC for work items, parent - children links for iterations
![]() It seems the data warehose does not capture:
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. |
One answer
![]()
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
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.
Comments
I found this link for work item parent-child relationships: https://jazz.net/forum/questions/61509/parent-child-relationship
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.