![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Wrting Matrix Report Topic Summary: Created On: 13-Dec-2005 01:07 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
A few things aren't clear to me: VALUE "X" ROW Name WIDTH 3.00 Where Type = "BPMN Process" JOIN JOIN 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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.