Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to access WORKITEMS_SNAPSHOT ENUMERATIONS Enumerations Table in Birt?

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


0 votes



One answer

Permanent link
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!

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 481

Question asked: May 21 '14, 4:11 p.m.

Question was seen: 4,423 times

Last updated: Apr 09 '16, 8:05 a.m.

Confirmation Cancel Confirm