RRDI and Work item Parent / Child linking
Mark Roberts (120●53●38)
| asked Dec 10 '12, 9:09 a.m.
JAZZ DEVELOPER retagged Dec 13 '12, 11:44 a.m. by Kelly Raposo (46●3)
There are a number of posts on Jazz.net regarding the creation of Parent / Child reports in RRDI. Most simply advise the use of the Request Related Requests table but don't actually advise HOW to do that. Is it possible for someone to generate a simple 'story and it's child tasks / defects' report in RRDI and post it on Jazz.net with some instructions ?
|
5 answers
Hi Mark
I'll document this in more detail and possibly publish on DeveloperWorks. My preferred way to find and utilize Work Item to Work Item links is use of the 'ODS -> Request Area -> Request Relational Link' folder that is exposed through the default Rational reporting package.
If a CCM project had the following work items in place;
The 'ODS -> Request Area -> Request' (R) folder provides the following crucial data;
The 'ODS -> Request Area -> Request Relational Link' (RRL) folder provides the following crucial data;
By using Joins it is possible to find parent work item information (Join Link being 'RRL.Request2 ID' -- 'R.Request ID') and then use another Join to bring into the result query the child work item information (Join Link being 'RRL.Request1 ID' -- 'R.Request ID').
I have exported a few sample reports detailing a both the above scenario and also how > 1 level of relationship can be reported upon using the example of 'Epic -> Story -> Task'. This zip file can be located here.
Hope that helps,
Mark
Comments Mark did you ever publish this on DeveloperWorks? I've been thinking of doing the same thing.
Hi Jackie, I've just finished a review draft of the article which is being peer reviewed. Fingers crossed it should be ready for publishing on developerWorks soon. Let me know of you would like a copy for review.
Thanks, Mark
Hi Jackie, Mark,
as I posted similar question earlier, I finally figured out how to get top level work item parent from any parent-child level, and also, I was thinking about documenting this stuff.
I figured out that I can manage with SQL queries directly on DW database using IBM Data Studio tool where I can deploy different stored procedures, user-defined functions etc etc...and simply, build any sql query and deploy it as a DB2 SQL View to Cognos RRDI portal.
Let me know when this document will be released.
Regards,
This was very helpful... However, is there a way to connect the data warehouse data with the links? I really don't care so much if the links changed, but what I want is, based on the current links, can I get trended data of the children compared to the parent? I know that Agile methodologies is opposed to this, but I have a customer asking for the % complete of stories, based on the child actual work completed, in a burndown type chart. So, I need to get the monthly totals of the child tasks and factor that against the story points for each story... hope this makes sense and someone can help me tie the data together. |
Have you seen this? I found it very useful:
http://www.ibm.com/developerworks/rational/library/custom-reporting-work-item-relationship/
|
i need same about but again like parent child grandchild relationship report
for Work Item
Parent -> Child ->Child of Child
Comments @Yogesh: Mark's recently published article (and sample report) could probably help you in the area. Note that I did not try myself (yet).
Thank you,.....Now I can create Parent -> Child Report..
for Parent ->>> Child ->> Grand Child report not possible ...
Any way to create such reports 3 level report
|
The solution is for RTC version 4.0 and above.
Thank you for the detailed explanation too. v/r James |
Excellent work. very useful.
Is there any other similar articles on RRDI / Insight reporting ? |
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.