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 - stevesavage

Pages: 1 ... 3 4 [5] 6 7 8
61
General Board / Re: SQL "with clause" for reusing subqueries
« on: August 26, 2013, 11:41:10 pm »
Yes, I'll submit a feature request.
I thought the query would be a simple pass through, I guess EA does some type of syntax checking on the SQL?


62
General Board / Re: SQL "with clause" for reusing subqueries
« on: August 23, 2013, 06:26:18 am »
Hi Helmut, I tested it already with Query builder and it works fine

There was a typo in my last post though:
WITH q04 AS (Select q03.PName, q03.EName, q03.EID, q03.AName, q03.AType From
(Select q02.PName, q02.EName, q02.EID, t_attribute.Name AS AName, t_attribute.Type AS AType From t_attribute JOIN  /* q03: get the attrbutes for the XSD objects */
(Select q01.Name AS PName, t_object.Name AS EName, t_object.Note AS ENote, Object_ID AS EID from t_object JOIN /* q02: get the objects within the XSD packages */
(Select Package_ID, Name From t_package where Parent_ID IN /* q01: get the packages within the XSD Schema */
(Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}') /* the package containing the XSD Schemas */
) q01 ON t_object.Package_ID = q01.Package_ID /* end: q01 */
) q02 ON t_attribute.Object_ID = q02.EID /* end: q02 */
) q03 /* end: q03 */
)
Select * From q04

For now I guess I'll just use SQL Developer to pull the data I need.

63
General Board / SQL "with clause" for reusing subqueries
« on: August 23, 2013, 02:08:00 am »
I'm doing a rather complex query to generate a data dicitonary.
To simplify the query, I'd like to make use of Oracles WITH clause.  Unfortunately this doesnt seem to be supported in the SQL search feature (or the repository.SQLQuery) command.  

I don't know if it's something with my local setup, or somehting with EA.  Any ideas?  

Simple Example:
WITH q01 AS (Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}')
SELECT Package_ID From q01

Info from oracle:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm#i2129904

What I'm trying to do:

WITH q04 AS (Select q03.PName, q03.EName, q03.EID, q03.AName, q03.AType From
(Select q02.PName, q02.EName, q02.EID, t_attribute.Name AS AName, t_attribute.Type AS AType From t_attribute JOIN  /* q03: get the attrbutes for the XSD objects */
(Select q01.Name AS PName, t_object.Name AS EName, t_object.Note AS ENote, Object_ID AS EID from t_object JOIN /* q02: get the objects within the XSD packages */
(Select Package_ID, Name From t_package where Parent_ID IN /* q01: get the packages within the XSD Schema */
(Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}') /* the package containing the XSD Schemas */
) q01 ON t_object.Package_ID = q01.Package_ID /* end: q01 */
) q02 ON t_attribute.Object_ID = q02.EID /* end: q02 */
) q03 /* end: q03 */
)

64
General Board / Re: Different representations of the same element?
« on: June 30, 2012, 12:04:35 am »
Quote
Let's say I create a class Person in my Business Model (CIM) my Functional Analysis Model (PIM) my Technical Analysis Model (PSM) and my Data Model (PSM).
I would then have 4 classes in my repository all with the name Person.
They are however not really the same thing.

Hi Geert, I agree that they aren't always the same thing once you get in to the data model and technical models, but what I found in the business models, that they are often conceptually the same thing.

Example: I have a business role in an archimate diagram called "Reviewer", I have the same role represented by a Swimlane in a BPMN diagram, and again as a class for a conceptual diagram.

What I want to show in the model is that they all represent the same business entity.  What would be different is their relationships to other elements.

When I want to describe a role in a specific context/situation.  I found I use two approaches:
  • The notes feature for relationships
  • The notes for the diagram (view)

Again my main desire is for traceability, especially between roles and the business policies and rules that guide and constrain them.

65
General Board / Re: Different representations of the same element?
« on: June 29, 2012, 11:50:27 pm »
Using the termed by Paolo:

My approach is:
I have a script that creates the typical doppelgangers for the element, links them with a "sameas" relationship, and syncs all the attributes and notes.   The controlling element is the "class" element I use in my conceptual models.

Select the control or a doppelganger, and re-run the script to re-synchronize the doppelgangers with the control (using the sameas relationship), if one of the doppelgangers has been modified since the last sync, show a warning (proceed yes/no).

This allows the user to manually merge changes from the doppelganger into the control element, then re-run the script.

66
General Board / Re: Different representations of the same element?
« on: June 29, 2012, 12:47:14 am »
What I'd love to have is the ability to have "shortcut/symbolic link" elements in EA.

If these "shortcut elements" also let me set the type, and stereotype and associated custom tags, but would otherwise be kept in sync with the target element (notes, name, other attributes), the previous process I described would no longer be needed.

This would also be useful for project management.  I'd be able to have the shortcuts listed in a project package, for readability, report generation, and usability (when creating diagrams for a project, I'd be able group shortcuts for the related elements in one spot)

67
General Board / Different representations of the same element?
« on: June 29, 2012, 12:37:14 am »
Question: how are other people handling what are conceptually the same things in EA when you need to create a separate element for each diagram standard you want to work with.

Background: As we undertake project, we are building up a common catalog of elements for re-use, for example the organizations and roles that make up the business.  

At the moment I've created a shared catalog containing packages for each org/role and then different elements for each diagram standard I need to create.  e.g.

The package "Deputy Minister" contains elements called "Deputy Minister" with the following types/stereotypes:
  • "Business Actor" element for using in Business UC diagrams, a
  • "ArchMate_BusinessRole" element for Archimate diagrams,
  • a "Class" element to use in Conceptual Models, and
  • a "Lane" element to use in BPMN diagrams.

I've create a "sameAs"  stereotype to use with a traceability relationship, all the "alternate" versions traceTo the "class" version used in my Conceptual Models (contains the generic description of the org/role)

To make this less painful, I create an EAscript that given an element of type="Actor", automatically creates the package, and all the alternate versions if they don't already exist.  The "note" in the alternate contains a link to the "class" version of the element.

I'm doing this for traceability
For example, to generate reports that show what IM/IT solutions are used by a specific role or org.
Or to show what org or roles would be impacted by a change.

And clarity, to show that each version is the same thing.

68
General Board / Re: Recursive Query for Package Tree Contents
« on: April 19, 2012, 01:43:48 am »
@Geert, don't know why the SQL version doesn't work. the Oracle version works perfectly.  Is it an EA problem or the default permissions on the server?

A possible work around would be to set a tagged value for all elements in the package to indicate the "root" package, and then only include elements with that tagged value.

69
General Board / Re: Recursive Query for Package Tree Contents
« on: April 19, 2012, 01:40:17 am »
For Oracle the search would be:
select  package_ID from t_package start with ea_guid = '{9F54BF3D-0F7A-4ec7-979C-7001A37FF9FC}' connect by parent_ID = prior Package_ID

Where the ea_guid is the GUID of the parent package.

For SQL you could try (untested):

WITH recursiveQ(Package_ID) AS (SELECT Package_ID FROM t_package AS parent WHERE ea_guid = '{9F54BF3D-0F7A-4ec7-979C-7001A37FF9FC}' UNION ALL SELECT child.Package_ID FROM recursiveQ AS parent, t_package AS child WHERE child.Parent_ID = parent.Package_ID) SELECT Package_ID FROM recursiveQ

Sorry I don't have an SQL server to test this with, the version is based on info found at: http://www.ibm.com/developerworks/data/library/techarticle/dm-0510rielau/

70
General Board / Re: Missing "linked elements panel"
« on: October 12, 2011, 11:04:27 pm »
Thank's for you help, that works perfectly.

71
General Board / Missing "linked elements panel"
« on: October 12, 2011, 12:47:57 am »
I'm trying to use the Team Review Feature, and followed the instructions at http://www.sparxsystems.com/uml_tool_guide/modeling_tool_features/discussionforum.htm and http://www.sparxsystems.com/uml_tool_guide/modeling_tool_features/addingobjectlinks.htm

The instructions assume that the "linked elements panel" will be visible as soon as you create a new topic.  That isn't the case for me, so I'm either missing a step, or there's a bug.

Before I report a bug, I thought I'd check to see if anyone else has the same problem.  I'm using 9.1.909

72
General Board / Re: Creating a Goal Model
« on: March 10, 2010, 02:49:07 am »
I did look at them, but decided I wanted to have the Quantitative and Qualitative Parent Classes to better organize and track the goals.

73
General Board / Re: Creating a Goal Model
« on: March 09, 2010, 08:31:53 am »
Instance of a class.
And that was exactly what I was looking for.  Thanks fwoolz.

I guess I wasn't thinking as a coder.  I was looking for something like
"set attribute value".




74
General Board / Re: Creating a Goal Model
« on: March 09, 2010, 08:18:32 am »
I was beginning to think what I want to do can't be done, which would be very odd.  

But if you look at the deployment model example on page 1302 of the EAUserGuide.pdf, and also at the same diagram in the EAExample model.  They've done exactly what I want to do.  

They create a class called Dell PowerEdge 6650 with the attributes Disks etc., and then create an object from that class that they set the attribute value to 3 x 120GB.

My problem:  I still can't find where they set the attribute values for the object.  

75
General Board / Creating a Goal Model
« on: March 09, 2010, 06:54:49 am »
I'm trying to create a Goal Model in EA.  (see Business Modeling with UML: Business Patterns at Work)

I was able to create the Quantitative and Qualitative Classes, both stereotyped as "Goal".  

For Quantitative I added the typical attributes of: Description, Target, Current, and Unit of Measure.

I've created an object from the Quantitative Class.  But I can't find where I set the attribute values for the object.   Its probably staring me in the face, but so far no luck through experimentation or the online help.


Pages: 1 ... 3 4 [5] 6 7 8