Using Insight, how do I extract an RRC requirement's related requirements?
2 answers
how do you create the "Specifies/Specified By" links?
The only reference I've found for this type of link is in in the context of an integration between RRC and Focal Point.
If that is the case, do you have the ETL collecting the data from Focal Point as well?
Best Regards,
Francesco Chiossi
Comments
@fchiossi
Hello Francesco,
This was just an example of a link type. Lets just assume that I have two artifacts that are linked together and I want to extract them in an Insight report. I can do the same for two RTC work items, but I can't find out how to do it for RRC artifacts.
The ETL is the IBM standard ETL configuration for CLM that comes for Insight.
Regard,s
Andrew
I did a quick test in query studio and drag and dropped the following items:
- Operational Data Store > Requirement Area > Requirement > Requirement ID
- Operational Data Store > Requirement Area > Requirement > Reference ID
- Operational Data Store > Requirement Area > Requirement > Name
- Operational Data Store > Requirement Area > Requirement Related Requirements > Requirement ID
- Operational Data Store > Requirement Area > Requirement Related Requirements > Reference ID
-
Operational Data Store > Requirement Area > Requirement Related Requirements > Link Type
Best Regards,
Francesco Chiossi
Comments
@fchiossi
Hello Francesco,
This is great, but my Insight package doesn't have the "Link Type" column under the "Requirement Related Requirements" table. Does this mean it is configured incorrectly? I am using Insight 1.1.1 with Report Studio 10.1.1.
Maybe it's a permission issue? Under the "Requirement Related Requests" table I see the "Link Type" column...
Regards,
Andrew
Hello Andrew,
I did my test in RRDI 2.0.4 integrated with CLM 4.0.4.
It's possible that the ETL/Data model has been updated to include the link type information in a release successive to yours.
Best Regards,
Francesco Chiossi
In addition to that:
- from which version of CLM are you collecting the data?
-
If you have data in the [RIODS].[REQUIREMENT_HIERARCHY] table, [LINK_TYPE] column I would suggest to try downloading again the data model from your CLM server and import it in Insight.
The manual procedure to import the data model was described in the old info center for CLM:
Importing the data models and reports on Rational Reporting for Development Intelligence
http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/topic/com.ibm.rational.rcpr.help.doc/topics/t_import_data_model_package.html
Pay particular attention to point 7 to check all the folders, or the import will fail.
@fchiossi
Hello Francesco,
Thank you for your valuable input and the links. I am using CLM 4.0.0.1. Is the information that I am using supported in the model?
Regards,
Andrew