Cognos Report Studio - LInked Requirement Schema?
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?
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
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:
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
Comments
