Messages

1

PCS Frequently Asked Questions / Re: Migration - qeax file to PCS

« on: June 18, 2025, 03:55:32 am »

Fantastic, thanks

2

PCS Frequently Asked Questions / Migration - qeax file to PCS

« on: June 18, 2025, 02:16:07 am »

We have a model in qeax file that we intend to migrate onto Pro Cloud Server

Is transferring to PCS simply a matter of setting up an empty repository and then following the instructions in: https://sparxsystems.com/enterprise_architect_user_guide/17.1/model_exchange/performadatatransfer.html

using file as the Source, and whatever DBMS we have behind PCS as the Target?

Will the model file having 3 root nodes complicate things at all?

3

General Board / Re: How to produce a product breakdown structure in a table

« on: June 16, 2025, 06:38:53 pm »

I am very pleased with it, but I can't take any real credit for it. Co-Pilot gave me the initial query which didn't quite work but had the basic structure right and only needed a small bit of tweaking to make it work in EA. Then Geert provided the last bit of inspiration needed to give the correctly formatted output.

4

General Board / Re: How to produce a product breakdown structure in a table

« on: June 14, 2025, 01:57:08 am »

Geert's suggestion of creating a path / fully qualified name works perfectly

A heavily simplified version of my query is:

Code: [Select]

select * from (

with recursive hierarchy as (
select
parent.Object_ID as ParentID,
parent.name as ParentName,
child.Object_ID as ChildID,
child.name as ChildName,
parent.Object_ID || '.' || child.Object_ID as pth,
'' as indent
from
t_object as parent
join
t_connector as connector on parent.Object_ID = connector.End_Object_ID
join
t_object as child on connector.Start_Object_ID = child.Object_ID
where
parent.Object_ID = #CurrentElementID# and connector.Connector_Type = 'Aggregation'

union all

select
h.ChildID as ParentID,
h.ChildName as ParentName,
child.Object_ID as ChildID,
child.name as ChildName,
h.pth || '.' || child.Object_ID as pth,
h.indent || '-' as indent
from
hierarchy as h
join
t_connector as connector on h.ChildID = connector.End_Object_ID
join
t_object as child on connector.Start_Object_ID = child.Object_ID
where
connector.Connector_Type = 'Aggregation'
)

select
indent || Childname as rowName
from
hierarchy
order by
pth
)

pth (path seems to be a keyword so I avoided it) and indent are the bits I have added to the base recursive query: sorting by pth gets everything in the right order and then concatenating indent onto the front of the Childname gives you the kind of indenting people are used to in PBS tables (I would like to use space not "-" as the indenting character but for some reason that didnt work)

Thanks Geert!

5

General Board / Re: How to produce a product breakdown structure in a table

« on: June 13, 2025, 11:16:03 pm »

I'll give that a go and see what happens

I like the recursive query because I don't have to guess how many levels I will have and I can use it on any object at any level without having to modify it, it's just the output isn't the way I want it 

6

General Board / How to produce a product breakdown structure in a table

« on: June 13, 2025, 01:34:40 am »

I have built a number of system architectures in our EA system model. Each architecture is a hierarchy of objects showing how the system decomposes. Pretty normal stuff. People call these hierarchies product breakdown structures, but all differ on which one is *the* PBS and which ones are other similar views of the system architectures.

Due to working with mechanical engineers I have a need to export various architectures or parts of architectures as PBS tables, they can't cope with diagrams. This is where I am having trouble.

If all the objects in the hierarchy are nested in the project browser then it is easy to make a standard report using the element/child thing in the report template and it comes out with a nice hierarchical list in the report:

If the objects in the hierarchy are linked via some kind of aggregation/composition type relationship, but are not nested in the project browser, I have a working recursive query that can start at any object and give me a table containing all the linked objects beneath it to the bottom of the structure. So I have used this as the basis for a report template and it works fine. HOWEVER... this query and report does not seem to be able to be ordered into the nice hierarchy list I get with the basic report template method. Instead I can choose, in the query, a field to order by, so I can order alphabetically by name, or I can order by the level within the tree etc. None of these give me what I need. I have resorted to outputting to excel and manually reordering the lines into the structure I need.

How do I achieve a proper hierarchy table when things are not nested in the project browser?

7

General Board / Re: Exporting specification view

« on: March 19, 2025, 05:05:45 am »

I found out I could get the same look by using list view and that has a printer icon that let me make a PDF of it

Problem solved!

8

General Board / Exporting specification view

« on: March 19, 2025, 04:41:51 am »

Hi,

I have a diagram in an empty package that shows a bunch of objects pulled in from other places

When I switch the diagram to specification view I get a nice list of those objects and can select which tags etc to show

How do I get that spec view out as a list to paste into an email?

9

General Board / Re: Time Aware Modelling - replaces relationship

« on: February 13, 2025, 12:40:52 am »

Regardless of that, you can still define your "replace" relationship as a stereotype. In the MeaningForwards/MeaningBackwards you can define how this should be listed in the traceability view.

Geert

I'll give this a go, thanks!

10

General Board / Time Aware Modelling - replaces relationship

« on: February 12, 2025, 10:59:04 pm »

When using time aware modelling, you clone an object and EA sets up a connector between the clone and the original. The connector has Type: Abstraction and Stereotype: trace

In the Traceability window this relationship shows up as replaces or replaced by depending on which end the object you are looking at is.

We don't want to use TAM. But we like the replaces/replaced by thing in the traceability window.

I have made an abstraction between two elements and that gives a depends-on relationship in traceability, thats ok

I try to stereotype the abstraction as a trace, but there are many many traces available and they all end up in the field as EAUML::trace not just trace by itself, and the relationship in traceability remains as depends-on

So, my question is: is there a way of making that replaces/replaced by thing happen in traceability without having to use TAM?

11

Automation Interface, Add-Ins and Tools / Can I define a hybrid stateblock in an MDG and have it appear as a single thing?

« on: January 17, 2025, 02:43:26 am »

I suspect the answer is no, having read a few older threads, but this is just to confirm it isn't possible:

In a profile diagram I have created a stereotype called stateblock and used it to extend a state metaclass and a class metaclass, and have generalised it to a sysml block stereotype. With the hope I could then have a hybrid stateblock to use in my model, for reasons.

When I create the mdg and import it I end up with the ability to use a block with type <stateblock> or a state with type <stateblock> but both things are still 100% block or 100% state and not a hybrid object of both types.

Is it possible to create this stateblock type by some other method?

12

Automation Interface, Add-Ins and Tools / Re: derive relationship in sysml is not showing correctly in compartment.notation

« on: December 10, 2024, 01:48:33 am »

Yes I am having the same issue today

It makes no sense grammatically that the thing from which the derivation is being made ends up having the derived from compartment 

It is correct in the traceability inspector though, so I am happy with that. Only the compartment titles need reversing

13

General Board / Re: Extend SysML with MDG Technology in EA

« on: September 27, 2024, 12:34:57 am »

Do you still need to also extend the UML base type, or does specialising a SYSML type work by itself in the latest versions?

14

General Board / Re: Custom report content issue

« on: September 17, 2024, 11:33:25 pm »

Thanks Geert, I accept that this is necessary, but it is implied in the help that it isnt meant to work like this:

For a model element such as a Package, element or Feature, you can select the (default) option of 'Dynamic Content' in
the 'Insert as' field. This adds the object information to the document. The prompt also provides a list from which you can
select a template or template fragment to format that specific information within the document. The list of templates can
be filtered to present only those that are user-defined, or system-provided, or technology-provided, or to show all
available templates. You make your selection by clicking on the appropriate radio button under the list.

15

General Board / Re: Custom report content issue

« on: September 17, 2024, 11:16:52 pm »

The query could be as simple as

Code: [Select]

select o.name as Name
from t_object as o

which when run by itself will find everything in the model, but in a custom document when you drop PackageA on the document and choose the template which contains the fragment that contains that query it also finds everything in the model. It feels like choosing the specific package was pointless because it didn't do anything to constrain the scope of the query underlying the template, I could drop any package onto the main document and then use a specific query to get only the things I want. 🤷‍♂️