DW and new States
Hi,
We have recently added a few more Work Item types to the Project Area configuration. We have also created a new set of Work Item States. And it is brilliant!
However, there had to be, I am having problems with building report templates for the new work items.
The new "State"s do not appear to be in the STATE table, so I cannot join the STATE table with the LIVE_WORKITEM_COUNT table.
On the work item records we see "scenarioworkflow.state.s13". I worked out that we need to add the project area id + s in front of the state id. However, we don't see any of our new records in the STATE file, only the standard ones.
What am I missing. Do we need to extend the DW process to include the new states?
Cheers,
Michael
We have recently added a few more Work Item types to the Project Area configuration. We have also created a new set of Work Item States. And it is brilliant!
However, there had to be, I am having problems with building report templates for the new work items.
The new "State"s do not appear to be in the STATE table, so I cannot join the STATE table with the LIVE_WORKITEM_COUNT table.
On the work item records we see "scenarioworkflow.state.s13". I worked out that we need to add the project area id + s in front of the state id. However, we don't see any of our new records in the STATE file, only the standard ones.
What am I missing. Do we need to extend the DW process to include the new states?
Cheers,
Michael
9 answers
i force dw snapshot updates to see the current burndown. its accessible via the web UI under the reports section.
im doing the force because our server backup routine sometimes overlap the midnight schedule. we can move it but its the only feasible downtime schedule for us since we are a globally distributed team.
ciao!
im doing the force because our server backup routine sometimes overlap the midnight schedule. we can move it but its the only feasible downtime schedule for us since we are a globally distributed team.
ciao!