It's all about the answers!

Ask a question

Are the descriptions of Live_Workitem_Cnt Wi_Type & State_Name correct?


Andrew Stevens (1482229) | asked Jul 10 '15, 12:36 p.m.
In the Data Warehouse Snapshot Schemas documentation at https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20 it describes the Live_Workitem_Cnt table as having

Wi_Type String The display name for the work item type, as defined in the process specification. For example, "Enhancement".
State_Name String The name of the work item state. The name is defined in the process specification. For example, "Verified"

This doesn't tally with what I'm getting in my report output, though, where I see e.g.  "com.ibm.team.apt.workItemType.story" & "com.ibm.team.apt.story.idea".  These look more like the relevant IDs than the display names, and need to be mapped via the State and Type dimensions to get the desired names.  Which seems to be what the answer to https://jazz.net/forum/questions/60902/rtc-birt-show-work-item-type-name is suggesting too.  Or am I mistaken?

Be the first one to answer this question!


Register or to post your answer.