Reporting on Estimated vs Actual for Top-Level Items
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
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
On 1/21/2010 5:38 AM, simfish wrote:
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
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