Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI For getting hours submitted in child workitems

I have a workitem that have several "child" in the Links section.

In those child I have submitted hours in the time tracking tab.

I want to know if its possible using RRDI (the solution for custom reporting in the new CLM) that I can search how many hours are being submitted for the specific parent link?

For example :

Parent 1
Child 1.a : 2 hours
Child 1.b : 3 hours

Parent 2
Child 2.a : 3 hours
Child 2.b : 8 hours
Child 2.c : 2 hours

And in the report I will like something like :

Parent 1 : 5 hours
Parent 2 : 13 hours

0 votes



One answer

Permanent link
Hello.
Yes, this is possible. Create a query in Report Studio that uses the
"Request Related Requests" query subject and create a Rollup Aggregate
Function on Planned Work of the children to get to the sums for each
parent.

Also see these posts for discussions about hierarchies:
- https://jazz.net/forums/viewtopic.php?p=62233
- https://jazz.net/forums/viewtopic.php?t=18941

Hope this helps,
Peter.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 19 '11, 11:29 a.m.

Question was seen: 5,022 times

Last updated: Sep 19 '11, 11:29 a.m.

Confirmation Cancel Confirm