Custom Attribute of type deliverable is not accessible in Report Builder (Jazz Reporting Service)
Tried to leave a comment on this old ticket but thought it best to create a new one as it doesn't look like it is getting picked up: https://jazz.net/forum/questions/66526/type-deliverable-cant-be-sorted-in-query-results?page=1&focusedAnswerId=232312#232312
We also have this problem with Jazz Reporting Service in 5.0.2 and also Report Builder in 6.0.2. I am an admin and have tried to refresh the data source. We are actually trying to include the attribute as part of the query. The attribute is not available for display or for queries.
We also have this problem with Jazz Reporting Service in 5.0.2 and also Report Builder in 6.0.2. I am an admin and have tried to refresh the data source. We are actually trying to include the attribute as part of the query. The attribute is not available for display or for queries.
Accepted answer
Hi Sian,
Information regarding the custom CLM attributes are kept in the CALM schema of the Data Warehouse ( *_EXT tables), for example RICALM.EXECWORKITEM_INT_EXT. Not all custom attribute types are populated to data warehouse though. Custom attribute of Type Deliverable is not available in data warehouse so not accessible in Report Builder.
Hope this helps explained the behaviour.
Information regarding the custom CLM attributes are kept in the CALM schema of the Data Warehouse ( *_EXT tables), for example RICALM.EXECWORKITEM_INT_EXT. Not all custom attribute types are populated to data warehouse though. Custom attribute of Type Deliverable is not available in data warehouse so not accessible in Report Builder.
Hope this helps explained the behaviour.
Comments
that's a shame, our custom attribute is for our target release which means the reporting tool will not really work for us.
There is an Request For Enhancement (RFE) available for it on IBM RFE Community:
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=86801
You can Vote for it to be considered and implemented in future release.