Messages

1

General Board / Build a dimensional data model in EA

« on: April 02, 2013, 10:20:46 pm »

Hi

Just do an evaluation of EA and, so far, I like it, however, one of the things I'd like to use it for is data modelling.

I can see that for a straight forward data model (ie relational; physical or logical/conceptual) it works pretty well. Just wondered if anyone has used it for dimensional modelling?

If I create a fact table, then some dimensions, I was surprised to see the primary keys created in the dimension table didn't appear as foreign keys in the fact table - unless I'm doing something wrong?

Thanks for your help.

2

General Board / Foreign key sync

« on: April 03, 2013, 07:16:12 pm »

Hi

I'm surprised to find that when I associate a table with a Primary Key, with another table I have to manually create the foreign key/primary key association (using right mouse click on the relationship, then Foreign Keys, and selecting the two columns to connect)? And then once the association has been made, if I change the primary key (say the name, or the data type length, or something), the change isn't automatically reflected in the associated foreign keys.

Isn't this bread and butter stuff for a modelling tool? Or have I missed a setting somewhere?

Thanks for your help.

Martin

3

General Board / Line up column name, column type in datamodels

« on: April 02, 2013, 08:31:53 pm »

Hi

When modelling database tables, is it possible to show the table in a slightly more columar style, so all the column names line up, all the datatypes line up; like a grid. Erwin, ER/Studio, etc. do this, I was just hoping EA could as it's quite a neat way to view the table definition.

Thanks in advance.

4

General Board / Re: Data Model HTML Documentation

« on: April 02, 2013, 08:24:27 pm »

Thanks for the replies. Didn't give me quite the results I was looking for, but still an improvment over the default layout. I will carry on playing with it.

5

General Board / Data Model HTML Documentation

« on: March 01, 2013, 05:12:02 am »

Hi there

I am just trialling EA at the moment and have a quick question regarding the HTML documentation that can be generated.

I have a data model, which I have mostly reverse engineered from my Oracle database. I have tidied up the layout, put some nice coloured boundaries in, added some comments, etc. etc. Then I have generated some HTML documentation so others can reference it.

However, the HTML doc isn't particularly Data Model friendly. Lots of talk of 'Public static' this, and 'Stereotype' that. Is there anyway to supress this? You know, make it a bit more user friendly as a report - remove redundant terms and concepts, etc.?

I realise this is a UML modelling tool, but I would still hope that it can be used for straight forward data modelling, if required.

Thanks in advance.
M