Book a Demo

Author Topic: Relationship Matrix in Table form  (Read 5843 times)

minna

  • EA User
  • **
  • Posts: 64
  • Karma: +1/-0
    • View Profile
Relationship Matrix in Table form
« on: July 08, 2014, 05:27:24 pm »
Hi,

I have UML Classes connected to each other with Information Flows. Each Information Flow has its own unique name and each has a different combination of Information Items added to the Information Flow.

I can easily create a Relationship Matrix to show the connections between the Classes.

My question is this, is there a way to show all the Information Flows with their unique names and Information Items they contain in a table or something?

The result I am looking for is something like a table. Column one would show the Information Flow name, the next columns would show the two classes it connects to, and the last columns would have all the Information Items contained in that Information Flow.

If there is something like this but it is not a table, that would be great to!

Minna

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship Matrix in Table form
« Reply #1 on: July 08, 2014, 08:03:30 pm »
Hi,

you may write a Query (SQL or Addin) and export the resukts to *.csv. Then you may visualize the results in Excel.

With an Addin you can automize the whole process.

To get conveyed Information Items from a connector is a little bit tricky. This forum contains some threads about how to get them.

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix in Table form
« Reply #2 on: July 08, 2014, 08:17:28 pm »
I'd say a simple SQL would do. You can copy/paste the results if you wish so. With focus on the related element you could also navigate to the according class/element.

q.
« Last Edit: July 08, 2014, 08:17:55 pm by qwerty »

minna

  • EA User
  • **
  • Posts: 64
  • Karma: +1/-0
    • View Profile
Re: Relationship Matrix in Table form
« Reply #3 on: July 08, 2014, 09:32:15 pm »
Thanks, I will try SQL to solve this problem. Is there any documentation on doing a SQL query in EA?

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship Matrix in Table form
« Reply #4 on: July 08, 2014, 11:20:40 pm »
Hi,

try Thomas Kilians ebook InsideEA and/or search in the EA help for SQL AND QUERY.

Ctrl+F and then F1 in EA will also guide you to the EA Search Help.

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)