Transitive relelations (Business Rules Management)

[Pawel Zubkiewicz]

Hi,

I'm asking for your suggestions on how to organize management or "create views" (it's hard to name this properly) for elements that have transitive relationships.

My IT system is composed of 15 Modules. Each Module has from 3 to 6 Components.
- Each Component can be assigned to only one module (so it's a tree not a matrix).
- Each component can have many Business Rules assigned to it. Each business rule can be assigned to as many components as you please (so Component - Business Rule relation can be presented as a matrix)

Example




Now I want a nice way of dealing with this, I would prefer more tabular / matrix way of working with those elements than diagram oriented because there is simply to many of them.

I know that I can use Reletionship Matrix (which is great) but I need to have option to filter by transitive relationships. In other words:
I want easy solution to see list all Business Rules assigned to all components that belong to for example Module 1.

Without the need to create every time new diagram and using Insert related elements...
Any suggestions?

[Paolo F Cantoni]

Hi Pawelz,

Just a side note on terminology.  You may care to use the word lattice instead of matrix.  A tree is a matrix with each element having only a single parent.  A lattice is a matrix in which each element may have more than one parent.

Otherwise you have difficulty separating the matrices that are matrices from those that aren't...  

Paolo (SUC - Society for Unambiguous Communication)  

(and yes Uffe, pun intended)  8-)

[Geert Bellekens]

Have you tried the relationship matrix?

I think that does exactly what you describe.

Geert

[Pawel Zubkiewicz]

Have you tried the relationship matrix?
I think that does exactly what you describe.

You mean model search in matrix instead of package selection?

I'm investigating that option. I wrote a custom SQL search to use it there

Code: [Select]

SELECT t_connector.Start_Object_ID
FROM t_object
INNER JOIN t_connector
ON t_connector.End_Object_ID=t_object.Object_ID
WHERE
t_object.Name like 'KA101';(I know it's bad but for testing purpose it's enough).

However when I execute this in matrix no elements are displayed in matrix. I wrote a different query that retrieves only ea_guid of elements, but Matrix still is not populated with those elements. (both queries work ok in Project search window)

Do you know what I should return in SQL query so Matrix would understand?

[Geert Bellekens]

I guess you'll have to use the standard fields for a search:

Code: [Select]

select o.ea_guid AS CLASSGUID,O.object_type AS CLASSTYPE,o.name AS Name
where...
The first two are mandatory, the other free to choose.
Also make sure to use uppercase for the [highlight]AS[/highlight]

Geert

[Pawel Zubkiewicz]

Thanks a lot Geert. Now it works!