Are the descriptions of Live_Workitem_Cnt Wi_Type & State_Name correct?
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
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?
| 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?