On 8/8/2011 4:38 AM, sudhakarf wrote:

Hi
If I have 4 CCM (RTC) Work Item Types (= Request Types) as follows:
A
B
C
D

Type C has a custom attribute called "points"
Type A can have 0..n children of type B
Type B can have 0..n Related Requests of type C or D

Now how can I get a report that show me a list/table with the
following columns/rows:
TypeA.Name totalPlannedWork totalActualWork sum(typeC.points)
sum(Type D)
TypeB.Name TypeB.PlannedWork TypeB.Actual Work TypeC.points
Count(Type D)

note that the report is hierarchical in that the Bs related to each A
are listed below each A, totalPlannedWork is the sum of all the
plannedWork of Bs related to that A, totalActualWork is the sum of
all the actualWork values of Bs related to that A and sum(C.points)
is the sum of the values of the points of Cs related to each A.

Does that make sense?
What queries/joins would I need to set up to get this data?
Thanks!

Hello.
- To report on the parent-child relationship you use the "Request
Related Requests" query subject.
- To report on other request-request relationships you use the new
"Request Related Requests (by Relational Link) query subject.
- To report on hours you divide by 3600, e.g. ../3600
- To create a list report with sums just create a query (by dragging
into a list report object) that shows the parents with the related
children and the hours, group by the parents and add sums via the
Aggregate menu button.
- Points are stored as custom attributes. See this online help page how
you can access custom attribute values (written for RQM, but the same
ideas apply to RTC:
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.reports.doc/topics/qm_t_customatt.html

Hope this helps,
Peter.

Thanks for that.
So I have created (in Query Studio) a list report like you advised, here are the columns I have:
.. .. .. ..

Now this gives me (using my ABCD example) the A, then the children of A and C/D related to A.
So what I need also is one more level down ie. the C/D records related to the B record. That is the hierarchy to show is:

A

   --->B

          ---> C or  D

Thanks

Thanks to All ,

I have problem like this and I need very urgent solution ----::

A (Story for example ) has two or three or four different types of work items types as its children ( Example -- Task , Defect , Resolution as Children ) . These Children of the story has their own children ( Example Task is having -- Defect and TestCase_Effort as children ) AND Defect has Resolution as children . Each Task, Defect , Resolution types of workitem has "Planned workhours" and "ActualWorkHour" . The report should aggregate and roll up to the individual workitem type level for "Planned workhours" and "ActualWorkHour" as well as show individual record with their "Planned workhours" and "ActualWorkHour" . The count should indicate as for example -This story has 4 task , 5 defect , 2 TestCase_Effort and 3 Resolution on the top level of each workitem type and how many of that completed .

Thanks

PKC

Hello.
The same relationships mentioned in my earlier post apply. When you
create an aggregate you can use different functions such as total or count.

Hope this helps,
Peter.

Btw. I suspect that you have a higher change of getting a community
response to specific Report Studio questions in the Insight newsgroup.


On 8/8/2011 5:53 PM, praschau wrote:

sudhakarfwrote:
Thanks for that.
So I have created (in Query Studio) a list report like you advised,
here are the columns I have:
.. .. .. ..

Now this gives me (using my ABCD example) the A, then the children
of A and C/D related to A.
So what I need also is one more level down ie. the C/D records
related to the B record. That is the hierarchy to show is:

A
--->B
---> C or D

Thanks

Thanks to All ,

I have problem like this and I need very urgent solution ----::

A (Story for example ) has two or three or four different types of
work items types as its children ( Example -- Task , Defect ,
Resolution as Children ) . These Children of the story has their own
children ( Example Task is having -- Defect and TestCase_Effort as
children ) AND Defect has Resolution as children . Each Task, Defect
, Resolution types of workitem has "Planned workhours" and
"ActualWorkHour" . The report should aggregate and roll up
to the individual workitem type level for "Planned
workhours" and "ActualWorkHour" as well as show
individual record with their "Planned workhours" and
"ActualWorkHour" . The count should indicate as for
example -This story has 4 task , 5 defect , 2 TestCase_Effort and 3
Resolution on the top level of each workitem type and how many of
that completed .

Thanks

PKC