Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 17-Sep-2008 14:50
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

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




Report this to a Moderator Report this to a Moderator
 18-Sep-2008 10:37
User is offline View Users Profile Print this message


Peter Crabb-Wyke

Posts: 73
Joined: 3-May-2007

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.
Report this to a Moderator Report this to a Moderator
 18-Sep-2008 12:25
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

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



Report this to a Moderator Report this to a Moderator
 18-Sep-2008 13:25
User is offline View Users Profile Print this message


Peter Crabb-Wyke

Posts: 73
Joined: 3-May-2007

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.
Report this to a Moderator Report this to a Moderator
 18-Sep-2008 14:17
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

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
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.