Show Custom Enumeration (Multi Select) of a Work Item in RRDI Report
Hi,
I have created a Custom Enumeration Attribute(Multi Selection) which is a check box selection and created a work item choose multiple options(lets say 2) of enumerations.
I have created a report choosing "Request Medium String Enumeration" where it is showing values as value.literal1 | value.literal2 when choosen 2 values.
How to create a report showing Custom enumeration Multi Selected values of a Workitem.
Any help on this is much appreciated.
Many Thanks in advance!
2 answers
If you are using Rational Insight and can run DataManager against the warehouse, I would run ETL to separate out the literal values and get the enumerated value for each. You would then have a table in the warehouse with a REQUEST_ID and each value. Then in Cognos Report Studio you can use a SQL query to access the table and use it in a report.
Hello Hareesh,
you can check this article for an example of ETL customization:
Customizing IBM Rational Insight: Add requirement description for reporting
https://jazz.net/library/article/1463
Best Regards,
Francesco Chiossi
you can check this article for an example of ETL customization:
Customizing IBM Rational Insight: Add requirement description for reporting
https://jazz.net/library/article/1463
Best Regards,
Francesco Chiossi
Comments
Here is the error related post which am facing when tried to implement the same as in article.
ERROR
Any help on this is much appreciated.
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 11 '15, 12:33 p.m.Which version of RTC are you running?
Hareesh Jairaj
Mar 12 '15, 12:35 a.m.Its 5.0.2