It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,862
×403

question asked: Sep 10 '13, 4:36 a.m.
question was seen: 4,453 times
last updated: Sep 24 '13, 9:51 a.m.

Related questions

RRDI: how to report on "Related Artifacts" links?

0
Makson Lee (410●4●42●41) | asked Sep 10 '13, 4:36 a.m.
I guess that all the link data of work item should be in the "Request Relational Link" table, but i just can't find the data about "Related Artifacts" links, am i wrong?

Accepted answer

0
permanent link
Makson Lee (410●4●42●41) | answered Sep 23 '13, 11:47 p.m.
edited Sep 24 '13, 9:51 a.m. by Rosa Naranjo (2.9k●1●17●23)
Work item 280979 had been created, and the answer from developer is,

'RIODS'.'REQUEST_RELATIONAL_LINK' only stores links between Work Items.
Rosa Naranjo selected this answer as the correct answer

3 other answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rosa Naranjo (2.9k●1●17●23) | answered Sep 16 '13, 9:11 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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
Comments
Makson Lee commented Sep 16 '13, 11:30 p.m.

Rosa
I can find parent/child link data in the "Request Relational Link" table, but just can't find the data about "Related Artifacts" links, i am just wonder if this kind of data been excluded from ETL process?

Rosa Naranjo commented Sep 17 '13, 10:25 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

Makson
I'm pretty sure it is since it is key to having those relationships reported on to have traceability reports.  I suggest if you don't see what you need that you open a workitem against Jazz Foundation->Reporting.  Also, check that your ETLs are actually running and not have errors in the data collection jobs page of jts/admin.  We want to make sure that the data collection is actually happening.

Rosa Naranjo commented Sep 17 '13, 10:26 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

One other thing: can you see data for links like implemented by or validated by? those are the relationship data needed to make traceability reports.

0
permanent link
Rosa Naranjo (2.9k●1●17●23) | answered Sep 17 '13, 10:33 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.
0
permanent link
Makson Lee (410●4●42●41) | answered Sep 18 '13, 2:47 a.m.
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.

Your answer

Register or to post 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.