Messages

1

General Board / Re: Bulk update of elements to new stereotype based on MDG

« on: July 03, 2017, 07:35:43 pm »

Agreed querty - Are you suggesting a manual transition for each element to the new MDG element?  Or can this be automated in some way, on a per stereotype basis?


TJ

2

General Board / Re: Bulk update of elements to new stereotype based on MDG

« on: July 03, 2017, 06:13:07 pm »

Thanks for the suggestion.  Historically I had used the vanilla 'Capability' element from the ArchiMate 3 language, creating a capability map of 15 or so capability elements.  More recently I have created my own MDG which has profile, toolbox and diagrams set.


I've done as suggested and selected the toolbox, right clicked on 'Capability' and re-synchronised.  This didn't work because the historical 'Capability' element is associated to the vanilla ArchiMate 3 language and not to my MDG version.  I want to transition the existing elements with stereotype 'ArchiMate_Capability' to my version called 'Capability'.  Once done the syncronisation steps mentioned should work.


TJ.

3

General Board / Bulk update of elements to new stereotype based on MDG

« on: July 03, 2017, 05:30:14 pm »

Hi,


I've recently created an MDG file which extends the ArchiMate 3 language.  I now want to update my existing elements (say capability element) within a package to my new MDG version of the capability element.  I can make the update manually but this is quite time consuming to go through all elements.  Does anyone know how to automate such a procedure please?


Many thanks in advance,
TJ.

4

General Board / Re: MDG - Calculating a tagged value from other tags

« on: July 03, 2017, 04:18:06 pm »

Excellent thanks for the response and code snippet Sunshine. 


TJ

5

General Board / MDG - Calculating a tagged value from other tags

« on: June 30, 2017, 04:28:45 pm »

Hi all,


[size=78%]Business problem - I've created my own MDG profile which extends the ArchiMate 3 language to include tagged values.  One of the elements extended is 'Capability'.  A capability has different maturity levels across the organisation ranging from 0-5.  I have 3 business units within the organisation.  Each business unit differs in maturity for a given capability.  Unit A has a maturity of 3, unit B is 2 and unit C is 4.  These are all recorded as separate tagged values.[/size]


[/size][size=78%]For executive reporting and decision making I want to be able to report on the lowest maturity level.  Is it possible to create a tagged value in my MDG which calculates the lowest number across all three business units please?  If so, what is the best way to make it work?  Script?[/size]


I can then use the filter option for reporting purposes.


Any help / guidance would be greatly received.


TJ.

6

General Board / Re: EA Sparx crashing - 'A required resource'

« on: April 27, 2017, 05:23:49 pm »

Simon - Thanks.  I've raised a ticket for this to be investigated.


Graham - If (when) the issue gets resolved, I'll post and advise on the course of action taken to see if its of help to you.

7

General Board / Re: Document Generation - BPMN model

« on: April 26, 2017, 06:16:59 pm »

Worked a treat - thanks Simon.

8

General Board / EA Sparx crashing - 'A required resource'

« on: April 26, 2017, 06:16:10 pm »

Hi - I've recently upgraded to version 13 and I'm frequently (every 15-20mins) encountering the following error message 'a required resource' which on clicking 'ok' proceeds to crash my system and close Sparx down.



Log Name:      Application
Source:        Application Error
Date:          26/04/2017 08:42:08
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      Work
Description:
Faulting application name: EA.exe, version: 13.0.0.1310, time stamp: 0x58b89830
Faulting module name: EA.exe, version: 13.0.0.1310, time stamp: 0x58b89830
Exception code: 0x40000015
Fault offset: 0x0155c804
Faulting process id: 0x1408


Has anyone encountered this issue before and if so is there a resolution for it please?


Many thanks in advance.

9

General Board / Document Generation - BPMN model

« on: April 12, 2017, 03:55:43 am »

Problem statement - I've produced a BPMN 2.0 collaboration model and now want to document it using the EA doc generator.  The structure of the package is as follows:
Level 1 - Package Name = BPMN Model
Level 1.1 - Business Process
Level 1.1.1 - Diagram
Level 1.1.2 - Pool
Level 1.1.3 - Pool
Level 1.1.3.1 - Activity
Level 1.1.3.2 - Start event


My report template is only documenting the elements at level 1.1.n, omitting everything below that level



Does anyone know how to recursively document all elements within the package please?


Help will be greatly appreciated.
TJ.

10

Uml Process / Re: Actors Catalogue - SQL query

« on: March 16, 2017, 06:09:35 pm »

Hi Geert,


Apologies for the delay, replaced d.Diagram with d.Package_ID and it works :-).  The SQL that is embedded in my fragment is as follows:



select DISTINCT act.Name AS ActorName, CAST(act.Note AS NVARCHAR(MAX)) as [Description-Formatted]
from t_object act
inner join t_connector c on act.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
inner join t_object uc on uc.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
and uc.Object_Type = 'UseCase'
inner join t_diagramobjects uc_do on uc.Object_ID = uc_do.Object_ID
inner join t_diagram d on uc_do.Diagram_ID = d.Diagram_ID
where d.Package_ID = #PACKAGEID#
and act.Object_Type = 'Actor'


Thanks again for your assistance in getting this to work - greatly appreciated.


Thanks,


TJ.

11

Uml Process / Re: Actors Catalogue - SQL query

« on: March 10, 2017, 03:20:11 am »

Hi Geert,


I've moved the fragment into the package space of the report as directed.  Still not outputting the actors in the document.


Used the SQL scratch pad to identify the Package_ID using the SQL logic:

select * from t_package
where t_package.Name = 'Use Cases'


Identified the package_ID as being 5269


Then ran your fragment query in the SQL Scratch Pad replacing #PACKAGEID# with '5269' which didn't return anything.  SQL script used below:

select act.Name AS ActorName, act.Note as [Description-Formatted]
from t_object act
inner join t_connector c on act.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
inner join t_object uc on uc.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
                              and uc.Object_Type = 'UseCase'
inner join t_diagramobjects uc_do on uc.Object_ID = uc_do.Object_ID
inner join t_diagram d on uc_do.Diagram_ID = d.Diagram_ID
where d.Diagram_ID = '5269'

12

Uml Process / Re: Actors Catalogue - SQL query

« on: March 10, 2017, 02:34:42 am »

Hi Geert,

Unfortunately I am unable to add images to represent what is happening, but will try and explain in textual format (hopefully with more clarity than last time)
The package structure in the Project Browser:

1.Group
1.1 Catalogs
1.1.1 Actors
1.2 Projects
1.2.1 Example Project
1.2.1.1 Use Cases - contains 10 use cases
1.2.1.2 Traceability

I am running a report on package '1.2.1.1 Use Cases'.  The report specification is called 'Use Case Specification' and is structured as follows:


package >
diagram >
{Diagram.DiagramImg}
< diagram
element >
{Template - Use Case Actor Names}
[---Contains element attributes---]
scenario >
Scenarios
structured scenarios >
{Scenario_Structured.Step}   {Scenario_Structured.Action}
exception >
{Exception.Type}:  {Exception.Name} - re-joins the basic path at step {Exception.Join}
< exception   {Scenario_Structured.Uses}
< structured scenarios
< scenario
external requirements >
< external requirements
child elements >
< child elements
< element
child packages >
< child packages
< package

The fragment {Template - Use Case Actor Names} is structured as follows:

custom>
{ActorName}
<custom

The fragment has the following query as specified by Geert.

select act.Name AS ActorName, act.Note as [Description-Formatted]
from t_object act
inner join t_connector c on act.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
inner join t_object uc on uc.Object_ID in (c.Start_Object_ID, c.End_Object_ID)
                              and uc.Object_Type = 'UseCase'
inner join t_diagramobjects uc_do on uc.Object_ID = uc_do.Object_ID
inner join t_diagram d on uc_do.Diagram_ID = d.Diagram_ID
where d.Diagram_ID = #PACKAGEID#
On running the 'Use Case Specification' report on package '1.2.1.1 Use Cases', all use cases are documented, but not the actors associated to the use cases.
I'd even considered creating a virtual document with 2 model documents.  1 model document which reports on the use cases, identifying all actors associated to each use case, removing duplicates and then outputting in a table format recording name and notes.  This is what the sql script is trying to resolve.  The 2nd model document will just concentrate on documenting the details of each use case.

Hopefully this provides additional clarity (hope so anyway).

Many thanks in advance,
TJ

13

Uml Process / Re: Actors Catalogue - SQL query

« on: March 09, 2017, 02:59:14 am »

Hi Geert - Thanks for the response.  I've applied the following, but the report doesn't appear to output the actors yet.  The use cases do have an 'association' to an actor.


I've created a template fragment which has you sql query.  I've created a table in the fragment to output ActorName and Description.Formatted as directed.


I've inserted the fragment in my use case specification report under the tag <diagram


I can confirm that I am using sql server, so it should work.  Any ideas?


Many thanks in advance,


TJ

14

General Board / Re: Report generation - Use Cases and wireframes

« on: March 09, 2017, 02:03:46 am »

Excellent - thanks Jose. 

TJ.

15

Uml Process / Actors Catalogue - SQL query

« on: March 09, 2017, 01:36:09 am »

Hi all,

Problem statement - I am trying to produce an actors catalog which can be generated from EA into Microsoft Word.  The actors catalog is a central folder holding all actors within EA.  Each project (if using use cases) will produce a use case context diagram and re-use the actors available in the central actors catalog.  I want to run a report on the use cases folder, assess all use case elements and identify all actors whom have an association with the uses cases in the said folder, removing duplicates where they exist.  I then want to use the query in my use cases report by means of a fragment.  The result should be a use case report which first details the actors and then the uses cases.

I've tried doing this through sql with no effect, although I think sql is the only way to achieve the desired result.

Would anyone have any ideas on how to achieve the above please?

Help greatly appreciated.

TJ