On 6/28/2010 3:13 AM, Ana Lopez wrote:

Hi,

I would like to create a new BIRT custom report that shows a list of
work items and their related work items (i.e, parent work items and
their related child work items). How can I navigate through these
relationship in the RTC datawarehouse model?

Thanks,

Ana

Ana,

There is a video and sample report that might help.

http://jazz.net/library/video/285

james
RTC Reports Team Lead

Many thanks for the sample report. I have followed it and I have been
able to create a BIRT report that given the WI ID as a parameter I can
get all related WIs and works fine.

Problem is that I would need to give the WI summary as input parameter
instead of the WI ID. I have checked the LINKS table and the issue is
that only the WI ID is available. Could I create a "pre-parameter
processing" (I don't know how to call it) to get first the WI ID based
on summary and work item type for example, and later use the sample
report? How could I "join" the "pre-parameter processing" to the report
to get first the WI ID based on summary and work item type input values?

Thanks,

Ana


On 28/06/2010 14:07, James Moody wrote:

On 6/28/2010 3:13 AM, Ana Lopez wrote:
Hi,

I would like to create a new BIRT custom report that shows a list of
work items and their related work items (i.e, parent work items and
their related child work items). How can I navigate through these
relationship in the RTC datawarehouse model?

Thanks,

Ana

Ana,

There is a video and sample report that might help.

http://jazz.net/library/video/285

james
RTC Reports Team Lead

Ana,

Maybe I misunderstand but I don't think you need to do pre-parameter
processing. Either (a) the Summary parameter is free-form text (you type
it in) or (b) it gets its choices from a data set on (say)
LIVE_WORKITEM_CNT. In the latter case, just use WI_ITEMID as the "value"
of the parameter, and SUMMARY as the "label" of the parameter. In the
former case, when the report runs you just do a lookup using the
LIVE_WORKITEM_CNT, passing in the Summary parameter as a data set
parameter and using RESULT_SET_SIZE of 1, and select WI_ITEMID. In
either case, you now have the WI_ITEMID. Then pass the WI_ITEMID as a
parameter to the LINKS table, with the appropriate link type as well.

Does this help?

james
RTC Reports Team Lead


On 6/28/2010 9:24 AM, Ana Lopez wrote:

Many thanks for the sample report. I have followed it and I have been
able to create a BIRT report that given the WI ID as a parameter I can
get all related WIs and works fine.

Problem is that I would need to give the WI summary as input parameter
instead of the WI ID. I have checked the LINKS table and the issue is
that only the WI ID is available. Could I create a "pre-parameter
processing" (I don't know how to call it) to get first the WI ID based
on summary and work item type for example, and later use the sample
report? How could I "join" the "pre-parameter processing" to the report
to get first the WI ID based on summary and work item type input values?

Thanks,

Ana


On 28/06/2010 14:07, James Moody wrote:
On 6/28/2010 3:13 AM, Ana Lopez wrote:
Hi,

I would like to create a new BIRT custom report that shows a list of
work items and their related work items (i.e, parent work items and
their related child work items). How can I navigate through these
relationship in the RTC datawarehouse model?

Thanks,

Ana

Ana,

There is a video and sample report that might help.

http://jazz.net/library/video/285

james
RTC Reports Team Lead