RRDI: how to report on "Related Artifacts" links?
Accepted answer
Work item 280979 had been created, and the answer from developer is,
'RIODS'.'REQUEST_RELATIONAL_LINK' only stores links between Work Items.
'RIODS'.'REQUEST_RELATIONAL_LINK' only stores links between Work Items.
3 other answers
Makson
Have you taken a look at the materials with the CLM 2012 Reporting workshop? https://jazz.net/library/article/1269 There should be an example that builds a traceability report and if not, check the previous reporting workshop from 2011, https://jazz.net/library/article/675
There should also be some out of the box traceability reports that you can examine with RRDI Query Studio and see what is used for the link data.
For other data, you may want to explore the data dictionary for each product area: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html
Have you taken a look at the materials with the CLM 2012 Reporting workshop? https://jazz.net/library/article/1269 There should be an example that builds a traceability report and if not, check the previous reporting workshop from 2011, https://jazz.net/library/article/675
There should also be some out of the box traceability reports that you can examine with RRDI Query Studio and see what is used for the link data.
For other data, you may want to explore the data dictionary for each product area: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html
Comments
I did a search on this forum and found this post: https://jazz.net/forum/questions/60911/rrdi-how-to-report-on-related-artifacts-of-the-same-type
Let me know if that helps.
Let me know if that helps.
Rosa,
I created two links in workitem, one to 'Parent' (com.ibm.team.workitem.linktype.parentworkitem), one to 'Related Artifacts' (com.ibm.team.workitem.linktype.relatedartifact), then i ran the data collection job, after that, with the database explorer tool, i found that only the link to 'Parent' been created in 'REQUEST_RELATIONAL_LINK' table.
If you are sure that this kind of data should be included in the ETL process too, i guess i need to open a workitem for this issue now.
I created two links in workitem, one to 'Parent' (com.ibm.team.workitem.linktype.parentworkitem), one to 'Related Artifacts' (com.ibm.team.workitem.linktype.relatedartifact), then i ran the data collection job, after that, with the database explorer tool, i found that only the link to 'Parent' been created in 'REQUEST_RELATIONAL_LINK' table.
If you are sure that this kind of data should be included in the ETL process too, i guess i need to open a workitem for this issue now.