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: Wrting Matrix Report
Topic Summary:
Created On: 13-Dec-2005 01:07
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.
 13-Dec-2005 01:07
User is offline View Users Profile Print this message


Tuan Jean Tee

Posts: 7
Joined: 4-Dec-2005

I was trying to create a matrix report for Business Process and its Corresponding Data. I need to find out what is the query for Corresponding Data. see attach code. Thank you.

Edited: 13-Dec-2005 at 05:49 by Tuan Jean Tee
Report this to a Moderator Report this to a Moderator
 13-Dec-2005 20:31
User is offline View Users Profile Print this message


Kevin P. Calandrella

Posts: 52
Joined: 9-Sep-2005

A few things aren't clear to me:

1) By default a Business Process definition doesn't have any related definitions.  Have you customized the Business Process definition with usrprops?

2) Is 'Corresponding Data' a property of the definition?

Here's an example of a matrix report that may help you.  It shows a BPMN Process definition and its related definition types.  If the BPMN Process has at least one reference to the definition type then the row/column intersection gets an X.

REPORT "Matrix - Process & Corresponding Data"
DESCRIPT "MATRIX Report - Process and Corresponding Data"
{   MATRIX 1 {

 VALUE "X"

 ROW Name WIDTH 3.00

 Where Type = "BPMN Process"

 JOIN
 WHERE Relation = "uses"

 JOIN
 COLUMN Type
 WHERE Class = Definition
}   }

This will produce a report like this:

Matrix - Process & Corresponding Data

                             C  P

                             o   r

                             s  o

                             t   c

                                 e

                            D   s

                             r   s

                             i

                             v   S

                             e   t

                             r   e

                                 p

Name

proc1                   X    X

proc2                   X

proc3                        X

This shows that BMPN Process "proc2" does not have a related Process Step definition and "proc3" does not have a related Cost Driver definition.

Report this to a Moderator Report this to a Moderator
 13-Dec-2005 22:39
User is offline View Users Profile Print this message


Tuan Jean Tee

Posts: 7
Joined: 4-Dec-2005

Kevin, Thanks for the quick reply.What I was trying to do is this: In my Business Process, I have a few Data Object which I associate it with a few Entity in the Corresponding Data section. What I wanted to report is: Name Entity1 Entity 2 Process1 X X Process2 X I wanted to find out which data is associated with process. I intented to expand this later to a link between Application and Process. Am I on the right path? Thank you.

Edited: 13-Dec-2005 at 22:40 by Tuan Jean Tee
Report this to a Moderator Report this to a Moderator
 14-Dec-2005 03:09
User is offline View Users Profile Print this message


Kevin P. Calandrella

Posts: 52
Joined: 9-Sep-2005

I think the simplest approach would be to write a report listing each Data Object and the Entities they use.  Here's the report:

REPORT "Data Object uses Entity Report"
ID 63758
{
 SETTING { PAGESIZE -1", 0.00 }
 SETTING { REPORTFORMAT 0 }
 TABULAR 1
 {
  SELECT "Name" LEGEND "Data Object"
  WHERE Class = Definition
  WHERE Type = "Data Object"
  JOIN
  WHERE RELATION = "uses"
  JOIN
  SELECT "Name" LEGEND "Entity"
  WHERE Class = Definition
  WHERE Type = "Entity"
 }
}

Another approach is to build a custom matrix associating Data Objects and Entities.  I'm not sure you can use the 'Corresponding Data' property in a matrix as this is a hetereogeneous listof.  Still you could add a generic listof Entities property to the Data Object definition and use this in the matrix.  This approach is more complicated to setup than the report but a matrix allows you to update the definitions so this may be what you want.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 0 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 0 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.