Messages

1

General Board / Unticking Primary Key flag leaves behind "empty" constraint

« on: January 13, 2016, 12:44:39 am »

Hi,

when setting an attribute of a database table as a primary key, EA automatically generates a primary key constraint under "Constraints" of that table. The attribute is selected in the "Columns" property of the constraint.

But when I untick the primary key flag, the attribute is removed from the "Columns" property of the constraint (which is now empty).

I'd rather expect that the constraint is removed then.

Why does this not happen? I have an inconsistent constraint now, having no columns. Wouldn't it make more sense to automatically remove a primary key constraint, when the last column is removed from it?

This bothers me for a long time

TIA
Andre

2

General Board / EA12 Tagged Values on Table Columns

« on: May 07, 2015, 02:51:56 am »

Hi,

using EA 12.0.1212 I cannot add and edit tagged values on table columns directly in the "Columns and Constraints" dialog anymore.

Can that behaviour be changed so I can set tagged values in that dialog? Currently I can only edit those in the separate Tagged Values view pane, which is hindering me when adding many new columns in a row. I store a lot of metadata for each column structured in specific tagged values (instead of unstructured all in the description field).

TIA
Andre

3

General Board / Re: EA 12: Import BPMN20 from other tools

« on: February 14, 2015, 03:32:23 am »

Excellent! Thanks for replying!

4

General Board / EA 12: Import BPMN20 from other tools

« on: February 09, 2015, 09:06:04 pm »

Hi,

with EA 12 will it be possible to import BPMN20 workflows from other tools, like Activiti Diagram Editor?

In EA 10 this is not possible at all. I asked for EA 11 some time ago and received the reply, that it was not possible. (http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1396355622)

Has this changed now?

TIA
Andre

5

General Board / Re: Extend table metaclass

« on: February 10, 2015, 04:14:11 am »

In EA 11.1 this seems to work now to a certain extent.

In EA 10 I can change the stereotype of an table attribute. This seems not to be possible anymore in EA 11.1.

But there are more things I do not understand here. But I will open up new questions for that.

6

General Board / (solved) Extend table metaclass

« on: February 09, 2015, 09:36:55 pm »

Hi,

I want to create my own specific MTG for a DWH environment, having stereotypes for dimensions, facts, source and so on.

Creating an MTG as such works. I have my own stereotypes in a toolbox and can add them to diagrams.

But extending the table metaclass does seem to break some things.

While it is still possible to assign a database to an instance of my dimension stereotype, which extends UML::table in the MTG, I cannot set a data type (like NUMBER or varchar2) for the columns I add to the dimension instance.

If I cannot set a data type for a column on a table, I cannot define foreign keys on it.

Also, under tagged values of the dimension, I cannot set DBVERSION and OWNER. I can set a TABLESPACE, though.

See the source code for the MTG below.

Is it not possible, what I'm trying to do? Or am I doing something wrong?

TIA,
Andre

Code: [Select]

<MDG.Technology version="1.0">
  <Documentation id="DWHMODELSCAI" name="DWH Model Technology" version="1.0" notes="Reference Model to define the structure of a DWH" infoURI="http://www.scai.de/"/>
  <UMLProfiles>
    <UMLProfile profiletype="uml2">
      <Documentation id="CD5F51F6-3" name="DWH" version="1.0" notes="DWH"/>
      <Content>
        <Stereotypes>
          <Stereotype name="Dimension" metatype="Dimension" notes="" cx="139" cy="70" bgcolor="-1" fontcolor="-1" bordercolor="-1" borderwidth="-1" hideicon="0">
            <AppliesTo>
              <Apply type="Table">
                <Property name="_Tag" value="1"/>
                <Property name="_TagInh" value="1"/>
              </Apply>
            </AppliesTo>
          </Stereotype>
        </Stereotypes>
        <TaggedValueTypes/>
      </Content>
    </UMLProfile>
  </UMLProfiles>
  <TaggedValueTypes>
    <RefData version="1.0" exporter="EA.25">
      <DataSet name="Property Types" table="t_propertytypes" filter="Property='#Property#'"/>
    </RefData>
  </TaggedValueTypes>
  <DiagramProfile>
    <UMLProfile profiletype="uml2">
      <Documentation id="1B130986-F" name="DWH" version="1.0" alias="DWH" notes="DWH"/>
      <Content>
        <Stereotypes>
          <Stereotype name="dwhModel" notes="" cx="90" cy="70" bgcolor="-1" fontcolor="-1" bordercolor="-1" borderwidth="-1" hideicon="0">
            <AppliesTo>
              <Apply type="Diagram_Logical">
                <Property name="alias" value="DWHModel"/>
                <Property name="diagramID" value="dwhmodel"/>
                <Property name="toolbox" value="DWH"/>
              </Apply>
            </AppliesTo>
          </Stereotype>
        </Stereotypes>
        <TaggedValueTypes/>
      </Content>
    </UMLProfile>
  </DiagramProfile>
  <UIToolboxes>
    <UMLProfile profiletype="uml2">
      <Documentation id="CFEA2654-E" name="DWH" version="1.0" notes="DWH"/>
      <Content>
        <Stereotypes>
          <Stereotype name="DWH" notes="Contains DWH Elements" cx="278" cy="174" bgcolor="-1" fontcolor="-1" bordercolor="-1" borderwidth="-1" hideicon="0">
            <AppliesTo>
              <Apply type="ToolboxPage"/>
            </AppliesTo>
            <TaggedValues>
              <Tag name="DWH::Dimension(UML::Table)" type="" description="" unit="" values="" default=""/>
            </TaggedValues>
          </Stereotype>
        </Stereotypes>
        <TaggedValueTypes/>
      </Content>
    </UMLProfile>
  </UIToolboxes>
</MDG.Technology>



7

General Board / Re: Import BPMN 2.0 Import

« on: December 02, 2013, 09:42:10 pm »

Hmm, I'm using the current trial of EA 10 setting it to business and software engineering edition.

I invoke Project|Model Import/Export|Import from XMI.

In that dialog I select my bpmn20.xml and hit Import. It cancels with "Unknown XMI Exporter or Version".

I am not completely sure if my bmpn20.xml file confirms to the spec, but it opens in the Eclipse Activiti Designer and Yaoqiang BPMN Editor.

Any idea?

TIA,
Andre

8

General Board / Import BPMN 2.0 Import

« on: December 02, 2013, 08:47:07 pm »

Hi,

is the ability to import a BPMN 2.0 Process designed in another tool a planned feature? If yes, for which release?

Currently this is not possible.

TIA,
Andrre

9

General Board / Oracle Bitmap Indexes

« on: February 26, 2010, 11:41:13 pm »

Hi!

How can I create Oracle Bitmap Indexes with EA 7.5.

I do not find a setting to make an index a bitmap index.

TIA
Andre

10

General Board / Consistent foreign key names

« on: January 13, 2010, 01:30:43 am »

Hi,
using EA 7.5, what do I have to do to have EA being consistent in the operation / foreign key names?

EA applies a naming convention for new foreign keys / operations between tables, but if I change a table name, EA does not refresh the operation / foreign key name. It remains unchanged. Currently I delete and recreate the foreign key which is no long or mid term option.

stw and online help gave no answer.

TIA!

Regards,
Andre

11

Uml Process / EA 11: Import BPMN20 from other tools

« on: April 01, 2014, 11:33:41 pm »

Hi,

with EA 11 will it be possible to import BPMN20 workflows from other tools, like Activiti Diagram Editor? Currently in EA 10 this is not possible at all.

TIA
Andre