Finding Missing Traceability

[Nick Tipper]

Hi,

Anybody know of a good way to look for missing traceability.  I've got my requirements mapped to other model elements as 'realized by' / 'implements' relationships.  I can show all these in the Relationship Matrix but what i want to do is filter the mattrix to only show requirements that don't have a realization connector.

TIA

Nick

[Geert Bellekens]

Nick,

Probably best to use SQL search.
See http://geertbellekens.wordpress.com/2011/01/14/harvesting-the-power-of-eas-sql-searches/
for examples.

Geert

[Nick Tipper]

Thanks Geert,

Looking at this a little harder this morning I have tried a couple approaches this morning.

1. Export the Relationship Matrix to Excel then add a column to COUNTA and filter on the 0s. - Solved my immediate issue but not really the answer.

2.  Query the model database using Access.  Created a new db and imported the tables from the .eap.  Got the answer i needed but again I'm no longer working in the model.

Using Access to build queries helped me as I could explore the model tables and build queries graphically and then with a bit of tweaking stick the SQL back into EA with your tip of using CLASSGUID and CLASSTYPE.

Brilliant, thanks again

Nick