How does one report on enumerated custom attributes in RTC with Insight
I can not find the data for enumerated lists that is for multi-select custom attributes in the data warehouse. I can find and create reports for enumerated types but not the enumerated list type. I have run the RTC_WorkitemEnumeration3 (only job I could find to deal with enumerations) manually and none of the attributes for the multi-select enumerations show up in the query.
Is there something I am missing or is this not supported ???
One answer
Hi Dave, please refer to this article.
Comments
I think 4.0.2 and 1.1.1.1 already have this and everything works fine for enumerated type attributes. It only does not work if you make the attribute an enumerated list which allows you to select multiple values.
ahh I missed the "list" and couldn't guess the version. I might give a try and post back if I can figure out.
Comments
VK L
May 10 '13, 11:20 a.m.It will not appear as its not directly tagged to any attribute. Try mapping the enumeration to some temp attribute and then run ETL Job to check if enumeration gets updated.
David Mehaffy
JAZZ DEVELOPER May 10 '13, 4:02 p.m.I have the enumerated list assigned to an attribute and have some workitems using them but we can not find them in the data warehouse - we are using clm 4.0.2 and Insight 1.1.1.1 by the way
VK L
May 11 '13, 2:07 a.m.Multi-select list is formed by assigning the enumeration at the presentation level. So the enumeration does not get detected as a change for the load.
David Mehaffy
JAZZ DEVELOPER May 16 '13, 1:26 p.m.I tried that and it did not work - I guess it is a bug
Luana Santos
Sep 10 '13, 3:59 p.m.David, I found out that the enumeration list values are stored in the query subject "REQUEST_STRING_M_EXT". But they are concatenated on a single string. I'm having trouble to join this with the enumeration query subject to get the description name.