Relationship matrix for Nested model

[aguevara]

I have a model which contains other models.

One of the models has all my actors while the other models (several) contain the Use Cases.

I would like to create a relationship matrix that has the Actors as the source AND the Use Cases as the target.

Each of the models has a "Requirements/Use Cases package".

I would like to only include the Use Cases packages and NOT the entire set of artifacts in all the models.

Is there any way to create it using the Relationship matrix functionality?

Perhaps the best way to do it would be via a SQL query, has anyone done this before? if so, please share any thoughts or SQL queries you may have.

Thanks.

[Geert Bellekens]

You can also simply limit the types in the relationship matrix. (e.g. source only Actors, target only Use Cases)
But an SQL Search query would work too.

Geert

[aguevara]

Thanks for the prompt response.

The issue is that the Use Cases are in multiple models so I am not sure how I could "limit it to only Use Cases". That is, I have Use Cases packages in several models.

Have you done it using SQL queries? please share any thoughts you may have.

Thanks again.

[Geert Bellekens]

When you mean different models I assume different root packages?
You can't to matrices over different repositories.

With (SQL) Search queries you just have to make a search for Use Cases and another for Actors.

See here for some examples:
https://bellekens.com/2011/01/14/harvesting-the-power-of-eas-sql-searches/

Geert

[aguevara]

Correct, different root packages.

I think it would be best to go with the SQL query option. I typically write my own, but need to be better versed in the DB schema/entity relationship diagram for EA.

Thanks.

[Geert Bellekens]

If you are just looking for use cases or actors that is very simple:

Actors:

Code: [Select]

select o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.Name
from t_object o
where o.Object_Type = 'Actor'
Use Cases:

Code: [Select]

select o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.Name
from t_object o
where o.Object_Type = 'UseCase'

Geert

[aguevara]

Thanks Geert. I will have to look at it and modify it to list the Actors and the use cases that they are associated with.