It's all about the answers!

Ask a question

Cognos Report Studio - LInked Requirement Schema?


Tony Kwa (20221) | asked Feb 18 '16, 10:30 p.m.
I am trying to create a report of two requirement types using the "Embeds"  link.

The problem I am facing is - that I can't find any documentation which tells me what the schema is.   I am assuming the data lives in the Operational Data Store Requirement Area.  There is a Requirements table.  And a links table.  "Embeds" is one of the link types.    But how do I build a query between two Requirement Types which is linked by the "Embeds" link?  It does not seem to work like the Extensions schema where there is  a reference to the Requirement ID to each attribute.

Can anybody help?

Accepted answer


permanent link
Francesco Chiossi (5.7k1819) | answered Feb 19 '16, 6:08 a.m.
Hello Tony,

usually if you want to report on any type of link between 2 requirement (A to B) you can use the following approach:
1) Create a list in report studio
2) Drag the following fields to the list:
  • Operational Data Store > Requirement Area > Requirement > Reference ID
  • Operational Data Store > Requirement Area > Requirement > Name
  • Operational Data Store > Requirement Area > Requirement > Any other field you need from the requirement A
  • Operational Data Store > Requirement Area > Requirement Related Requirements > Link Type
  • Operational Data Store > Requirement Area > Requirement Related Requirements > Reference ID
  • Operational Data Store > Requirement Area > Requirement Related Requirements > Name
  • Operational Data Store > Requirement Area > Requirement Related Requirements > Any other field you need from the requirement B

3) You can create a filter in the Link Type to only show the relationship you are interested in (Embeds in your case).


NOTE: RRC 4.0.2 was known to have huge issues with the requirement links in the data warehouse. If you miss links an upgrade to at least version 4.0.7 is highly recommended.

Best Regards,

Francesco Chiossi


Tony Kwa selected this answer as the correct answer

Comments
Tony Kwa commented Feb 28 '16, 9:13 p.m.

Just attempted to create the query from the information above.

The Requirement Related requirements are does not have a Link Type Field!!

IT is possible you made a mistake in listing the relationship schema.  Could you check and provide an update?


Francesco Chiossi commented Feb 29 '16, 3:11 a.m.

Hello Tony,

I did my test in CLM 5.0.2 and the field "Link Type" is there:


It's possible that it was added in a release between your current version and 5.0.2 (I don't have an older CLM version running where to verify this).

Otherwise your data model might not be up to date.
To reload the data model see:

Integrating Rational Report Server with CLM data sources
http://www-01.ibm.com/support/knowledgecenter/SSR27Q_5.0.2/com.ibm.rational.rrdi.admin.doc/topics/t_postinstall_integrate_rrdi_clm.html

Best Regards,

Francesco Chiossi


Tony Kwa commented Feb 29 '16, 9:59 p.m.


Thanks Francesco

Because you specifically mentioned 4.02 - I thought you knew I was on 4.02.

The field is definitely not available in the schema I am look at.

I guess this is a query that is not possible in 4.02 since it is not documented in the schema. AND it i specifically known to have problems.

Your answer


Register or to post your answer.