Author Topic: Relationship Matrix (Read 3970 times)

javadch · « **on:** December 05, 2007, 05:31:44 am »

I established a relationship matrix between use-case and requirements using realization relation. Now i need to know which use-cases don't trace to any requirements and vice versa. Any help is appreciated

thomaskilian · « **Reply #1 on:** December 05, 2007, 06:11:09 am »

Export to CSV and analyze in Excel. Or write a SQL to do the job.

javadch · « **Reply #2 on:** December 07, 2007, 10:12:49 pm »

Thanks Thomas
But would please send me SQL sample to do the job.

thomaskilian · « **Reply #3 on:** December 08, 2007, 01:42:15 am »

I'm afraid I don't have the time for that. The tables of EA are quite simple to understand so I guess with some SQL experience you could do what you want in a short time period.

javadch · « **Reply #4 on:** December 08, 2007, 02:52:12 am »

I found that t_object contains all elements (usecase and requirement) but would you please let me know in which table are the relations (associations, realizations, etc)
Thanks

«Midnight» · « **Reply #5 on:** December 08, 2007, 03:28:36 am »

You'll find the information in the help file under the section titled Extending Enterprise Architect - Software Developers Kit. Find the Object Model section in the Reference part.

The information is woefully incomplete, but there's quite enough for you to find the necessary tables. Pay attention to the various fields that identify the "type" of an item, such as a connector. These will tell you whether you're looking at an association or a realization, etc.

David

javadch · « **Reply #6 on:** December 08, 2007, 05:38:25 am »

Thanks Thomas
I wrote a SQL like following and problem resolved:

SELECT o.Object_ID, o.Name, o.Author, o.Status, o.CreatedDate, o.ModifiedDate, o.Scope
FROM t_object o
WHERE (NOT EXISTS
(SELECT Start_Object_ID
FROM t_connector c
WHERE o.Object_ID = c.Start_Object_ID AND c.Connector_Type = 'Realisation')) AND (Object_Type = 'UseCase')

Graham_Moir · « **Reply #7 on:** December 10, 2007, 04:51:21 am »

I'm missing something here - why doesn't the relationship matrix tell you what you want to know without resorting to SQL ?

thomaskilian · « **Reply #8 on:** December 10, 2007, 05:05:41 am »

Scanning for empty rows or columns can be tedious. SQL can do that in one step and show where no relation is found.

javadch · « **Reply #9 on:** December 10, 2007, 05:07:18 am »

I couldn't found any search mechanism on relationship matrix. Also I think search mechanism of EA is based on single entity selection and no combined nor relation traverse is supported!!!
By the way if you know any conventional method to anser the question it is appreciated if you shre it with me.
Thanks

javadch · « **Reply #10 on:** December 10, 2007, 05:11:05 am »

Thanks David

Sparx Systems Forum

News: