Is it true that JRS reports do not support Custom Attributes?
We are using JRS with RRDI OOTB. I believe that means we are using the Java ETL.
1) Do I assume correctly that the Java ETL only Extracts non-custom attributes and therefore JRS may see those Attributes, but it will see no data in those attributes?
2) If we were to create our own ETL which would include custom fields, would JRS display those Attributes and their values from the DWH?
|
Accepted answer
2 other answers
Hi Robert, the data warehouse stores the custom attributes. Those are exposed to RRDI in the Request Area as Request XXXX Extension. The tables expose the custom attributes as key value pairs.
Comments Rafik, So when I create a report using JRS, does JRS see these Key value pairs as attributes and values and display them in Conditions and Formatted columns the same as other attributes? If not, how would they appear differently to a JRS report creator?
Hi, I did a sample JRS report with JRS 5.0.2 RC1 creating a new enumeration type in RTC for a Work item,i.e, Department (with list values Department1, Department2, Department3) and JRS is able to detect this new attribute as a new column, but if you display the values it does not show "Deparment1", it shows the value id "department.attribute.ibm.com.literal.l1".
@Ana I think you've identified a problem with the display of multi-valued enumerations. If you specify the enumeration as single valued, then the enumeration literal will display properly. We've have a internal work-item tracking the display problem for multi-valued enumeration literals that will be fixed for the next release. It would be possible to fix this using the advanced SQL capability, but then the report is only editable using SQL after that point. So the recommended practice here but would to copy the report (keep the fully generated report around as a reference), put the report into SQL mode, then a fix can be instrumented. Let me know if you're interested and I can post the SQL fix. |
Hello folks,
I have a question regarding how custom RTC attributes are collected by JRS. I created a custom work item type with the following custom attributes (besides other OOTB attributes): 'Stakeholders' custom attribute, represented by the attribute type of 'contributor'. 'Score' custom attribute, represented by the attribute type of 'enumeration', with a list of values from 1 to 10. 'Product' custom attribute, represented by the attribute type of 'enumeration', with a list of products/solutions provided by us. The purpose of this WI type would be to capture the 'score' which should be provided by stakeholders on how they think the product/solution we deliver is doing. Then, a JRS report would calculate the average score for each of the Releases (by using OOTB 'Found In' attribute). The problem I have is the following: On the JRS server, I can see the custom WI type within the list of work item types. However, I cannot see the new three custom attributes associated to that new work item type although I am able to see other custom attributes created quite some time ago for another custom work item types created by us. Can you please let me know if I am missing something? Maybe an specific job that must be run? Maybe missing configuration from the RTC side? Additional info about our development environment: JRS 5.0.2 including DCC component Many thanks in advance, Vicky Comments 1
See the comments in your post: https://jazz.net/forum/questions/186272/jrs-v502-not-filtering-custom-attributes-of-a-custom-work-item-type
|
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.