Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
General Board / Re: MDG - Calculating a tagged value from other tags
« Last post by ducatiross on November 16, 2017, 11:04:28 pm »
What are you thinking of Uffe - doing something to help the calculation of TVs ? I'm sure there would be interest in that.
22
General Board / Re: Tree walking a model from element to element via relationships
« Last post by ducatiross on November 16, 2017, 11:02:00 pm »
Hi Geert,

There would be an unknown number of hops between the source and target, so scripting sounds like it is unavoidable. Bearing in mind my coding skills are 20 years out of date and I don't know JavaScript, this might be a bit problematic for me !

Thanks for responding.
23
General Board / Re: MDG - Calculating a tagged value from other tags
« Last post by Uffe on November 16, 2017, 11:00:06 pm »
I've had clients ask about this as well. I've done some thinking, and with some limitations it shouldn't be that hard to do.
I could cobble something together within a couple of weeks I think.

Is there interest?
(I've no idea if Sparx are planning to address this.)

/Uffe
24
General Board / Re: Can you use multiple values in <Search Term>
« Last post by Geert Bellekens on November 16, 2017, 10:58:03 pm »
with Search Term:
"rte","bsw"

Should be 'rte','bsw' with single quotes instead of double quotes to be correct SQL syntax.
Some databases don't care, but others will.

Geert
25
General Board / Re: Can you use multiple values in <Search Term>
« Last post by Helmut Ortmann on November 16, 2017, 10:39:08 pm »
Hi Paolo,

try:
select * from t_object where name in (<Search Term>)

with Search Term:
"rte","bsw"

Kind regards,

Helmut
26
If you know exactly the number of hops between your source and target then you could easily do this as an SQL query, which is of course the preferred solution for tabular output.

If you don't then a script solution is required (which will be a LOT slower)

I haven't done anything specific like that, but you would basically have to keep iterating the Element.Connectors in a recursive called function and test the target element for type or stereotype or whatever you make the criteria for your target.
Just make sure you keep a list of visited elements in order to avoid endless loops.

Geert

27
General Board / Tree walking a model from element to element via relationships
« Last post by ducatiross on November 16, 2017, 10:10:45 pm »
Hi everyone,

I've tried for a few hours for searching for this but came up with nothing.

So, is there a method for tree walking a model - starting at one element, then walking up/down the relationships listing the relationship type and element it is linked to in a recursive fashion, perhaps looking for a target element type that could be many relations distant from the original, but linked through a series of other elements ?

This would replicate a similar functionality in BEASI where an ArchiMate model can be automatically drawn using derived relations from one element all the way up to another.

I would use BEASI, but a) I don't want to be forced to use custom ArchiMate elements - it must work with standard ArchiMate elements and b) I want to do this for other models, not just ArchiMate.

I might want to put the output in a diagram showing the starting element, the relation to the next element and so on recursively up the hierarchy of that relationship tree to the final element.

Or, I might just want to list out all the points in the tree in a grid/excel style tabular fashion.

Has anyone done this and if so, could they help me get started on it ?

Thanks in advance.

28
General Board / Re: MDG - Calculating a tagged value from other tags
« Last post by ducatiross on November 16, 2017, 09:44:18 pm »
@Ian - this seems a real gap in EA's functionality and I would whole-heartedly support it. Providing the ability to calculate a TV's value from a user-entered formulae would open up a huge number of reasons to bother enriching EA models. Modelling risk for instance, would need a simple Probability TV (0-5) and Impact TV (0-5) that then results in a Risk x Impact score calculated and saved into another TV. If you could then aggregate these up a model hierarchy so that parent level element scores were the sum of child elements, that would be SO useful.

@TJ - thanks for raising the question. Saved me doing it !

@Sunshine - until Sparx provide this within the toolset natively, I'll try to re-work your code - thanks for posting.

Now, the next item on my hitlist is a method for tree walking a model - starting at one element, then walking up/down the relationships listing the relationship type and element it is linked to in a recursive fashion, perhaps looking for a target element type that could be many relations distant from the original, but linked through a series of other elements.

This would replicate a similar functionality in BEASI where an ArchiMate model can be automatically drawn using derived relations from one element all the way up to another.

I would use BEASI, but a) I don't want to be forced to use custom ArchiMate elements - it must work with standard ArchiMate elements and b) I want to do this for other models, not just ArchiMate.

Anyone got any ideas (ooops -  :-[ I realise I have done a major hijack of this thread - sorry. I'll post it separately 0)
29
General Board / Re: SQL query to get class, description, attribute & tagged values
« Last post by Ravaa on November 16, 2017, 09:31:53 pm »
Thanks Geert, and apologies for late response. I'll work with this and let you know if I have any challenges!
30
Bugs and Issues / Re: attribute order messed up
« Last post by qwerty on November 16, 2017, 08:07:34 pm »
Arrest the usual suspects.

q.
Pages: 1 2 [3] 4 5 ... 10