It's all about the answers!

Ask a question

Reporting on Estimated vs Actual for Top-Level Items


Simon Fisher (1631710) | asked Jan 21 '10, 5:24 a.m.
JAZZ DEVELOPER
Hi,

I'd like to be able to generate a report containing a table which shows each top-level (epic) work item down the left hand side, and each of my project's sprints along the top. Each table cell will then display the estimated/actual work for a work item from its lower level tasks.

I'm happy to use BIRT to create a custom report - all I'd like to know is the estimate/actual data for low-level tasks stored by the Data Warehouse for each top-level item, or would this involve traversing parent/child links to manually calculate this information?

Thanks,

Simon

One answer



permanent link
James Moody (3.3k24) | answered Jan 21 '10, 2:23 p.m.
JAZZ DEVELOPER
On 1/21/2010 5:38 AM, simfish wrote:
Hi,

I'd like to be able to generate a report containing a table which
shows each top-level (epic) work item down the left hand side, and
each of my project's sprints along the top. Each table cell will
then display the estimated/actual work for a work item from its lower
level tasks.

I'm happy to use BIRT to create a custom report - all I'd like to know
is the estimate/actual data for low-level tasks stored by the Data
Warehouse for each top-level item, or would this involve traversing
parent/child links to manually calculate this information?

Thanks,

Simon


To do the roll-up from children to parents, you'll need to calculate it
manually (i.e. the roll-up is computed, not stored).

We have a sample report called Work Progress which displays a table with
a hierarchy of work items, and does a sort of roll-up of the progress,
this might be a good place for you to start. You can find it here:

https://jazz.net/wiki/bin/view/Main/ReportsCentral

Hope this helps.

james
RTC Reports Team Lead

Your answer


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