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?