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.