Author Topic: Reporting Traceability  (Read 380 times)

Graham_Moir

  • EA User
  • **
  • Posts: 717
  • Karma: +8/-9
    • View Profile
Reporting Traceability
« on: March 07, 2019, 10:49:09 pm »

This topic has come up before - how do you get the very useful information reported via the traceability window in to a report?   I just did a search and there have been a few threads on this over the years, usually voicing frustration that it's not supported out of the box with a standard template. 

Well I've been away, and was just wondering whether there has been any progress with this?  Or does someone have an example template to achieve it?

Thanks
   

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9387
  • Karma: +258/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Reporting Traceability
« Reply #1 on: March 07, 2019, 11:59:58 pm »
We do it using an SQL fragment.

Geert

Graham_Moir

  • EA User
  • **
  • Posts: 717
  • Karma: +8/-9
    • View Profile
Re: Reporting Traceability
« Reply #2 on: March 08, 2019, 12:26:21 am »
We do it using an SQL fragment.

Geert

Is it possible to share that Geert?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9387
  • Karma: +258/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Reporting Traceability
« Reply #3 on: March 08, 2019, 07:16:11 pm »
We have a few of those traceability fragments, but they are all pretty specific
Here's an example of a fragment that shows the requirements referenced by the use case using a «trace» link
Code: [Select]
select uc.Name as SourceName, 'Use Case' as SourceType, 'trace' as ConnectorType,
ro.Name as TargetName,
'Application Requirement' as TargetType
from t_object uc
inner join t_package p on p.Package_ID = uc.Package_ID
inner join t_connector c on c.Start_Object_ID = uc.Object_ID
                                         and c.Connector_Type = 'Abstraction'
                                         and c.Stereotype = 'trace'
inner join t_object ro on ro.Object_ID = c.End_Object_ID
and ro.Object_Type = 'Requirement'                                 
where
uc.Object_Type = 'UseCase'
and uc.Object_ID = #OBJECTID#
union
select 'N/A' as SourceName, 'N/A' as SourceType, 'N/A' as ConnectorType, 'N/A' as TargetName, 'N/A' as TargetType
where not exists
(
select uc.Object_ID from t_object uc
inner join t_package p on p.Package_ID = uc.Package_ID
inner join t_connector c on c.Start_Object_ID = uc.Object_ID
and c.Connector_Type = 'Abstraction'
and c.Stereotype = 'trace'
inner join t_object ro on ro.Object_ID = c.End_Object_ID
and ro.Object_Type = 'Requirement'                         
where
uc.Object_Type = 'UseCase'
and uc.Object_ID = #OBJECTID#
)
order by SourceName, TargetType, TargetName
the results go into a table on the template:
Application Requirements
custom >
Source type   Source name   Relationship   Target type   Target name
{SourceType}   {SourceName}   {ConnectorType}   {TargetType}   {TargetName}
< custom


Geert

Graham_Moir

  • EA User
  • **
  • Posts: 717
  • Karma: +8/-9
    • View Profile
Re: Reporting Traceability
« Reply #4 on: March 09, 2019, 01:53:50 am »
Thank you Geert !