![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Reporting on Data Fows Topic Summary: Attempting to report on one way data flows t(to create explorer relationship report Created On: 17-Sep-2008 14:50 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I have a number of system architecture diagrams, each with applications and one way data flows between them.
I would then like to create an explorer diagram showing all the data flows between all the applications. I am trying to develop the report that I can paste into an explorer object report which shows all the data flows between applications. The report logic is Definitions where Type = Application Define Symbols where Type=Application Connect Symbols where Type= Data Flow Connect Symbols where Type=Application Defined by Definitions where Type=Application However, I get a report that shows both directions of the Data Flow i.e. if there are three Data Flows on the diagram I need three lines in the report showing App1 > App2 App2 > App3 App3 >App4 But what I get is a report that shows both directions ie. App1 > App2 App2>App1 App2 > App3 App3>App2 App3 >App4 App4>app3 Any help would be appreciated Thanks Ted Carroll |
|
![]() |
|
![]() |
|
I'm not sure if you can do that or not but assuming not you can work around it with a little usrprops tailoring and some VBA
Tailor the data flow symbol to have named fields for the start and end points. These can be easily populated using VBA based on the RELCONSTART and RELCONEND relationships. You will now have named fields to report which should be a lot easier. |
|
![]() |
|
![]() |
|
Peter
I was hoping that the Start and End relationships were part of the standard properties that are related to a symbol, but clearly they are not. I have not used VBA with SA so I guess this is something I need to look into... Thanks for your help. Ted |
|
![]() |
|
![]() |
|
I think I was a bit hasty in my first reply. The code segment that you are after should look a bit like this:
WHERE Class = Symbol WHERE Type = "Data Flow" JOIN WHERE "RELATION NUMBER" = 9, 7 ........ While Report Writer only gives one option for "Connects" it clearly populates the code with two relationship types. 9 is RELENDAT and 7 is RELSTARTAT (you can look the numbers up in the VBA manual). RELCONSTART (6) and RELCONEND (8) are the relationships from the node symbol to the line symbol. |
|
![]() |
|
![]() |
|
Yes that has cracked it - by restricting the relation to 6 and 9 if gives me what I was looking for - see Report code below. This works well in the Explorer Relationship report. The only problem is that where there is a relationship in both directions, the arrow only points one way (although it does add a text label, presumably to indicate this.)
See code below... SELECT "Name" LEGEND "Source" LEGENDFONT Font4 WHERE Class = Definition WHERE "Type Number" = 309 JOIN WHERE RELATION = "defines" JOIN WHERE Class = Symbol WHERE "Type Number" = 461 JOIN WHERE "RELATION NUMBER" = 6 JOIN WHERE Class = Symbol WHERE "Type Number" = 459, 459 JOIN WHERE "RELATION NUMBER" = 9 JOIN WHERE Class = Symbol WHERE "Type Number" = 461, 461, 461, 461 JOIN WHERE RELATION = "defined by" JOIN SELECT "Name" LEGENDFONT Font4 WHERE Class = Definition WHERE "Type Number" = 309, 309, 309, 309 |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.