Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Sunshine

Pages: [1] 2 3 ... 48
General Board / Re: Are spammers the main users of this forum?
« on: December 08, 2018, 04:22:38 pm »
Bit of a silly question because clearly they're not

Suggestions and Requests / Re: Reporting Spam
« on: December 06, 2018, 11:13:09 am »
Clearly you are typing too fast  :)

Generally yes you can add attributes using tagged values. Three ways to do this add them manually one at a time.  Write a script to add them automatically. Create and MDG that extends the stereotype and adds the tagged values.

Here is a trick. When translating an object type from one to another try creating that target object type first, then retrieving those values so get to know what values you need. Write the code to put those values you've retrieved into your code to translate the object types. Saves a guess work along with a lot of time and energy.

General Board / APQC Process Model
« on: November 17, 2018, 06:51:14 am »
APQC is a process framework for the full enterprise.
APQC's Process Classification Framework (PCF) is the most used process framework in the world. It creates a common language for organizations to communicate and define work processes comprehensively and without redundancies. Organizations are using it to support benchmarking, manage content, and perform other important performance management activities.

For those who have requested it via PM I've published APQC process model on Git hub.

It utilises a custom Enterprise Architecture MDG that is also located there so you need to copy that into a folder and reference it via the MDG dialog set up in Sparx EA to get a proper view of the diagrams.
You also need to change preferences to show both alias and name to see both the ID and name. The ID is in the alias.

To access the metrics you need to enable the metrics window and you will see them when you click on certain process elements.
Enjoy  :)

General Board / Re: How to create a "click-through" object in a diagram
« on: November 17, 2018, 05:56:48 am »
Child diagram is the thing you want.

Bugs and Issues / Re: Mysql model changed
« on: November 16, 2018, 11:52:32 am »
Kind of looks like the parent_ID or package_ID in the table t_object may have been corrupted in someway.

General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 02:55:18 pm »
Backing up before resetting the IDs is a good move. Exporting to XMI will work to a point as it will export the model elements and their connectors along with the diagrams. But it won't include other stuff like alternative images or model defined stereotypes etc. Can you not just backup the SQL server? You should have at least a daily backup on that SQL server surely.  Alternatively a transfer to eapx or feap file would be more complete back up. You could try the reset ID on the eapx file then transfer back to SQL Server as an alternative course of action.

Didn't think Reset ID's would take that long. Pretty sure when I did it a while ago it only took about 10 min for a few hundred thousand elements.
Not sure about whether its one transaction but if something does go wrong you've got your backup.

General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 06:55:19 am »
I change from .eap to SQL Server for more stable behavior. It turns out to be true.

However, now I got a problem that I cannot overcome:
When transfering from SQL Server to a local .eap I get "Unrecognized database format" if I try to open the .eap file. And it is true: I expect a size of ~100MByte and get 12kB as the size of the exported .eap-File.
I've gotten that error and its to do with eap and eapx where the latter is Jet V4.0 engine and the former V3.5. The older versions of Sparx used to open both even if it was named eap. However you seem to get that error now when opening a Jet 4 db when its got the extension eap. Found by renaming it to eapx it worked ok.
When doing Check Integrity/Project Integrity on the model in SQL Server I am left with one problem: Invalid Realization Stereotype. ITEM: . ACTION: Updated Applies To.

Any time I try to Recover/Clean I get a SQL Server failure Violation of PRIMARY KEY constraint 'pk_stereotypes'. Cannot insert duplicate key in object 'dbo.t_stereotypes'. The duplicate key value is (realization, realize).

What would be the next steps to solve that problem? How can I find the stereotype that caused it?
Sounds like the primary keys have gotten into a bit of tiz. Try reset IDs - the next option down from project integrity

General Board / Re: Kanban MDG not listed in version 12.1
« on: November 14, 2018, 09:20:44 am »
Yep its confusing reading the wrong version of the manual. Done that before.
I can second that advice to upgrading as KP recommends. Difference is I don't work for Sparx Systems nor do I get any commission so its kind of independent advice if that's what you are after.

Lets face the licence costs for upgrading Sparx EA isn't going to break the bank and you've probably spent that amount of money in the time you took to figure our your problem.

Bugs and Issues / Re: Document generation: change orientation
« on: November 14, 2018, 09:15:57 am »
Agree with Skiwi that the document generation isn't useless, on the contrary its very powerful and a lot better than many other tools I could mention. Like many things there are tricks and tips to working with tools like this and an investment in time to make it work does pay off. I know it can be a bit frustrating when climbing the learning curve but stick with it for a little longer.

I've generated 100+ page Solution/Enterprise architect documents that include pages of A4 portrait and A3 Landscape for diagrams with no problems. I just spent some time learning how to work within the constraints of the tool. Its no different to every other software whether its MS Excel, Word or Sparx Enterprise Architect.

As Skiwi says you need a different template with different page set up and orientation to make it work. The reason is the page size and orientation are controlled via the printer set up on the template which limits the fact you can't change this within the template between sections like in MS Word.

To achieve generating one document with different orientations and paper sizes then you should use virtual document with master/model documents.  You need to ensure the  headers and footers are set correctly in the master template which the master document references. See tag values for that.
The set up is like this;

Master with template defining headers and footers
  • Model Doc referencing package with template set up for A3 landspace for diagrams
  • Model Doc reference package with template set up for A4 for details on the diagram elements. Usually name and description as a minimum.
For further information on virtual docs see this url

If you still struggle then some people prefer EADocX

I have know people to use the reporting built into MS Access when dealing with eap and eapx files or SQL Reporting Services if they have SQL database.  Although not sure how they got on with diagrams using those tools. It all depends on skill set what people have and want to use.

General Board / Re: Shape script control by external switch
« on: November 12, 2018, 05:56:08 pm »
If you're wanting to change that notation for all elements on the diagram, I would be creating customized diagram types, then checking diagram.mdgtype within your shape scripts. This means the modeler has the choice of whether the extra notation is shown or not.
Yeah thats a good idea too.

Yes there were problems with the relationships in the ArchiMate V3.0 spec. Probably because they tried to define the metamodel without a tool - sigh  :(. I suspect the authors of the spec ended up having mental fatigue defining the relationship tables and ended up publishing V3.0 without the necessary vigour they should have done. But hey they are human and everyone has bad days.

However after publishing I understand that there were some articles pointing out those errors by Gerben Wierda and a few others lead to V3.01 of the ArchiMate Spec which addressed most of those issues. Not saying they got it perfect mind.

So I guess the question is does the ArchiMate MDG take into account those changes in V3.01. I suspect perhaps not given this thread.
The simple solution would be to revise the ArchMate MDG to comply with V3.01 then things might work a little better.

General Board / Re: Customer Journeys in EA
« on: November 11, 2018, 01:52:46 pm »
Hi Sunshine,  for Value Chain, do you merely mean "chains of business function/processes"?  There is no occurrence of the term "Value Chain" in the ArchiMate 3.0 spec.  We're looking at implementing Porter-style Value Chains in out MDG, so I'm interested in others' experiences.

The existing EA "Value Chain" mechanism, is a starting point but needs some conceptual "jiggering" to make it work correctly with other elements.

Good question. Over the years I've implemented value chains using archimate in various forms.
Initially I used functions and processes. Recently in the last year or so I've added value stream to my MDG and used those to in conjunction with business capabilities to create value chains based on blog from Marc Lankhorst, Henk Jonkers and Adina Aldea at BizzDesign
There is another blog about value mapping
Still experimenting with it at present to see if it all makes sense to the business folk.
A little while ago I imported the APQC v7.1 model but ended up creating two new element types to try and match their terminology of Category, Group, process, Activity and Task at the various levels. I mapped Process to ArchiMate and Activity and Task to BPMN elements.
Using the APQC framework to model the whole enterprise. Replaced some of the unique specialised stuff with what my organisation does from our operations manual and it seems to be hanging together although its a lot of work and still not finished.
Not sure if there is a right answer for all of this.
I'd be interested in what you are doing.
Happy to share the APQC model but its mapped to my EA MDG and you would have to translate it to your MDG. Easy enough with a script or SQL statement

Pages: [1] 2 3 ... 48