How to access WORKITEMS_SNAPSHOT ENUMERATIONS Enumerations Table in Birt?
Robert Truban (33●8●11)
| asked May 21 '14, 4:11 p.m.
edited May 22 '14, 3:22 a.m. by Ralph Schoon (63.4k●3●36●46)
I have read the tutorials and several other forum posts on this topic, but no matter what I try I can not get the WORKITEMS_SNAPSHOT ENUMERATIONS table/view to return any values in BIRT.
I have used {Current Project Area} and actual ID values for the PROJECT_AREA_ITEMID, which works on other tables, but the enum table will not return values. I have used parameters and actual values in filters. One interesting symptom is that when creating a new data set the ENUMERATIONS table does not show up in the list but if I type it into table name area by hand BIRT shows the four columns the table/view is suppose to have (according to the information I have read). I have the same issue with 2 separate instances of Jazz, one using Oracle and the other DB2. I am not sure if the data warehouse jobs are not setup correctly or what. I am currently using version 4.0.5, but I had the same issue prior to upgrading from 4.0.3. I really need to create some reports that include custom attributes (enums) so if anyone has any ideas or advice on how to troubleshoot this I would certainly appreciate it! Thanks in advance, Rob |
One answer
Have you tried creating the data set as a "Jazz Simple Data Set" rather than the default "Jazz Advanced Data Set" - you will find the table in the drop down then!
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.