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 ... 34
1
:) its helpful, thanks @ Sunshine
karma points welcome  ;)

2
I use the phase field and the filter to include one or more filters. So I might have a number of elements with phase 1.0, 2.0, 3.0 etc then create filters that include phase = '1.0', '2.0', '3.0' and enable one or more filters.
Now there are two patterns I've observed using this
a) Phased approach to implementing some system so that when the last phase is reached everything is included and all the filters enabled.
b) A phased approach to adding some components and retiring others. This requires a slightly different approach where in the phase I include the phases in which the component exists. For example if component A already exists and component B is being add lets say in phase 2 to replace it I might have 3 phases.
Phase 1.0 - component A only
Phase 2.0 - component A and B exist
Phase 3.0 - component B exists and component B has been retired.

Component A phase field = '1.0, 2.0'
Component B phase field = '2.0, 3.0'

I would use a filter that says contains rather than equals a phase value like '3.0'
Hope that helps.
 :)

3
...
There are also diagram filters that can gray out or hide elements based on selection criteria, but I have no idea if these can be made to be applied during document generation...
Enable the filter then generate the doc

4
Upon reflection of the suggestions from various people in previous posts I think if I had the problem I'd use fragment template with a custom script to navigate the relationships. I must admit I'd forgotten about fragment templates with scripts in my original suggestion.

Wonderful sharing ideas in the community to get a better outcomes isn't it? Thats what I love about this community - great people sharing their thoughts and ideas.

5
I've used phase to indicate which phase the requirements should be implemented in. You can then add a filter in the doc gen template to only include requirements, usecases etc for a particular phase. Now the trick is to use the "one of..." option on the element filter so that for phase 2 you include phase 1 as well 2. For example  "1.0,2.0" - can't remember if that is the correction format comma separated values or whether its semi-colons or something else but I think you get the idea.

6
As far as I know the only way to get that nesting using the built in doc gen is to structure your model that way. So a feature contained a requirement etc. If that's not how your want to structure your model the other options are;

a) To write some specialized SQL query along with some reporting. So if you are using eap files as your repository which is basically MS Access you can try writing MS Access SQL and using those in a MS Access Report. Or similarly if you are using MS SQL you can use SQL Server reporting services.  I'm sure there will be options for the other database supported too.

b) I've once seen someone do is by leveraging the built-in scripting and use jscript to create a rtf file. I think they did come a cropper when there was a cyclic set of relationships in the model and ended up  with infinite loop blowing the thing up.

8
General Board / Re: What is Sparx and for what purposes it should be used
« on: October 05, 2017, 01:15:58 pm »
Thank you very much for the answer. You mentioned such thing as " For enterprise architecture work I use a customised version of ArchiMate MDG. I have a meta model based on ArchiMate that describes all the elements and relationships along with a catalogue of viewpoints mapped to stakeholders. I based my catalogue of view points on the TOGAF and ArchiMate List."

Could you please show me some screenshots or maybe share the example of your work. It will definitely help me.. I would like to understand and to see how you have organized catalogs and mappings, viewpoints and some example of metamodel.
Sorry pretty much everything I do is for clients is usually confidential so can't share.

However, if you go to www.opengroup.org all the standards on ArchiMate meta model and view points are there. Similarly for TOGAF. Also Marc Lankhurst the main author of ArchiMate works for bizzdesign and he has a blog with some good stuff on using ArchiMate etc http://blog.bizzdesign.com/
Another place to check out is https://www.orbussoftware.com/ as they provide some posters for viewpoints and metamodel.

The extensions I've added to the ArchiMate metamodel are mainly attributes. For example an I've added to application component attributes like Annual Support Cost, Security Classification, etc to help manage the applications.

How I organise the Sparx Model for enterprise architecture is something like this. As Glassboy says its in align TOGAF. I mainly follow ArchiMate as thats the language I use in combo with UML and BPMN. There is some work going on to align the ArchiMate and TOGAF to use same metamodel.

Enterprise Architecture Model
          Motivations
                    Catalogues
                    Diagrams
          Strategy
                    Catalogues
                    Diagrams
          Business
                    Catalogues
                    Diagrams
          Application and Data
                    Catalogues
                    Diagrams
          Technology
                    Catalogues
                    Diagrams
          Implementation and Migration
                    Catalogues
                    Diagrams

Document Generation
          Subject A
                    Model Doc X
                    Model Doc Y
          Subject B
                    Model Doc Z

I keep the doc gen separate from the main model so I can generate the enterprise architecture model as HTML making it available to everyone in the organisation. I keep the diagrams separate from the catalogs of objects to make sharing of the objects easier. The downside when you create new objects on a diagram they are stored in the same package as the diagram and you have to lift and shift them into the catalog package.

Like I said before the learning curve is massive for both Enterprise Architecture Discipline and the Sparx EA tool so you really need to bring in some experts. My colleagues call me an expert but I still sometimes struggle with some aspects from time to time and I've been using Sparx EA for Enterprise Architecture over a decade now.

9
Always good to get some fresh thoughts.
1. What do you think about adding a true crow's feet notation, where keys are underlined instead of having the key icon as stereotype
1.1 Also if it's not patented, how about adding automatic highlighting of the keys when you hover mouse over a relationship... this is something that Mysqlworkbench does and I find it useful to plan queries and joins
1 - I like the key icon can't say the underlining would get my vote.
1.1 - Yeah may be.

2. You can drag attributes (non-keys) from a table (or Class) to another in Project Explorer, but not in the diagram... it would be useful to be able to move attributes around in diagram as well
2.1 Editing attributes in the diagram by double clicking is buggy too... changes are not saved
2. - There is a feature where you can drag from project browser to element on diagram and it copies it. Not sure if I'd like that moving attributes on the diagram. Kind of feel the UI might become a little tricky to use when trying to select element vs attribute.
2.1 - I've not had this problem but may have just gotten used to the UI over the years.

3. EA (at least Professional) cannot reverse engineer SQL DDL code... I find it useful to move models around and update schemas.  MySQLWorkbench and ERWin can do this
3- Can reverse engineer DB already in corporate edition and above. I usually reverse engineer DB, edit in Sparx EA and generated DDL to create DB.
 
4. No CSV export for attributes is a major feature gap... I have read up on EA limitation to CSV export classifiers only and not their attributes, and I understand the difficulty in implementing this across all UML classifiers, but a table-attribute specific script should be made available by Sparx.  It's very valuable for quick editing-fine tuning-reporting when under time pressure (ERWin is excellent in this respect)
4 - MMh? I struggle to understanding this one. Do you want to make global changes to attributes or run a report? Here is a little trick on global changes; the  eap files are really ms access 97 and you can open it with MS Access and do global changes that way. Using DB skills to save time in changing the DB design - kind of poetic in some way isn't it :). BTW you can use the MS Access Jet 4 too for later versions of MS Access that don't support 97 anymore.  To run reports then look at doc generation. very comprehensive reporting built in already.

If you can't wait for that feature you can write some vbscript/jscript to create your cvs file.

10
Suggestions and Requests / Re: Model Search: More than one Search Term?
« on: October 03, 2017, 12:29:23 pm »
Maybe its because it is in the afternoon and I've just had a big lunch but I'm  missing something here as I thought the query builder provided multiple <search terms>.

11
Bugs and Issues / Re: Suppress Relationships still shows NoteLinks!
« on: October 02, 2017, 08:25:57 pm »
I've notice that too and agree.
The work around I did was to colour the relationship white so when I printed the diagram it didn't show.
The other thing I notice when disabling relationships was that certain shapes that provided the rectangle option which put the name label floating outside of the shape can't be moved when the show relationships box is unticked. For example the business actor in archimate 3 put the name underneath the shape and normally you can move it but when the relationships are not shown then can't move the name label anymore.

12
General Board / Re: What is Sparx and for what purposes it should be used
« on: October 01, 2017, 10:48:43 am »
I've used various tools like Sparx EA for the last 30 years in my profession. I've used Sparx EA for about 12 years now which I've used for the purposes of enterprise architecture, solution architecture, software architecture and engineering. Its probably the best value for money and feature rich tool on the market place today. The tool provides all the core features for enterprise architecture with the ability to draw diagrams, manage objects and relationships aided by matrices and lists all stored in database. The database can be from one of many mainstream vendors such as MS Access, MS SQL, Oracle etc. Sparx EA also has a very rich document generation ability too. It can be configured and customised and its use is only limited by your imagination. Yes it very feature rich and so the learning curve can be very steep and a bit overwhelming to the inexperienced.

So first of all if you want to use Sparx EA to store and manage Enterprise Architecture of a business you need two things. An expert in Enterprise Architecture and an expert in Sparx EA. They could be the same person or two individuals. If you are lacking these then start looking as trying to learn both is probably a learning curve most mortals would find hard to climb for the short duration of a project.

Second like any problem you need to break it down. Who needs to use the tool and for what purpose? A use case model can help. During this discovery phase you should ask what Enterprise Architecture Framework are you going to base your work upon?
 TOGAF, DODAF, ArchiMate and Zachman to name but a few. Other questions to ask are what viewpoints and elements will the stakeholders need and what data should those elements have to be useful to the stakeholders. Then prototype each use case in the tool to see how you would do it.

For enterprise architecture work I use a customised version of ArchiMate MDG (added extra features and attributes to the elements) and follow the Archimate V3.01 standard along with TOGAF V9.1. I also use various books like Enterprise Architecture At Work by Marc Lankhorst et al to guide me.

I have a meta model based on ArchiMate that describes all the elements and relationships along with a catalogue of viewpoints mapped to stakeholders. I based my catalogue of view points on the TOGAF and ArchiMate List.

These all allow me to cover everything in the enterprise from strategy, motivations for change, current states of business, data, application and infrastructure as well as future states and roadmaps to guide the organisation there.

So to re-iterate if you don't have the knowledge and experience in both methodology and tool then you need to find someone to help in one or both of these areas otherwise you will be doomed to fail.

Finally from the words of Mark Twain - Apologies for writing such a long response for I did not have time to write a shorter one.

Hope that helps and good luck with your endeavour.
 :)

13
General Board / Re: Roadmap legend filter
« on: September 22, 2017, 11:08:55 am »
Have you tried ticking the "use legend for phase colours" at the bottom of the roadmap options dialog?
Right click diagram background and from context menu select roadmap options to get that dialog.
Hope that helps

15
Automation Interface, Add-Ins and Tools / Re: Modification status of Package
« on: September 12, 2017, 10:08:06 am »
Unclear on what you mean as according to the user guide both element and package have modified field. If you look at the properties via the Sparx EA UI you'll also see the modified field. If you look at the tables t_object and t_package they have a field called modified too.

See the user guide for more info;
http://sparxsystems.com/enterprise_architect_user_guide/13.5/automation/element2.html
http://sparxsystems.com/enterprise_architect_user_guide/13.5/automation/package_2.html

The only thing I can think of is that you are possibly using the the wrong object type in your code so perhaps give that another check.

Hope that helps. :)

Pages: [1] 2 3 ... 34