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
Comments
Alanna, can you be more specific regarding your statement
(with some exceptions, depending on the type of the attribute)
What Type of attribute is not supported?
I double checked, and it turns out that almost all of the simple (e.g., Boolean, String, Enumeration List) and complex (e.g. Contributor, Iteration, Project Area) types are supported. The one exception is the XXX List types (e..g Project Area List, Contributor List) - these are not stored in the data warehouse.
1 vote
Hi Alanna,
I have "Contributor" type attribute in work_Item but not able to access in JRS. Can you help me out if i am missing something or how can i make this attribute available in JRS.
Hi Naveen,
2 other answers
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".
Do you know any way to show the value name instead of showing the value id?
@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.
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
About the Jazz Reporting Service
Version: 5.0.2
Build ID: JRS_5.0.2-I20141028-2014
CCM & JTS are 5.0.2
Many thanks in advance,
Vicky
Comments
See the comments in your post: https://jazz.net/forum/questions/186272/jrs-v502-not-filtering-custom-attributes-of-a-custom-work-item-type
1 vote