Messages

1

General Board / Re: ER Diagrams: hide PK and FK

« on: March 06, 2024, 02:36:12 pm »

Thanks. Unticking various boxes, including the ones you mentioned, have helped.

After digging around further based on your instructions, I found how to hide the FK's and PK's

Right click diagram pane
Properties
Elements Tab
"Show Compartments" area
Unitck "Operations"

2

General Board / ER Diagrams: hide PK and FK

« on: March 06, 2024, 10:06:19 am »

Hi, along the lines of this post
https://sparxsystems.com/forums/smf/index.php?topic=25130.0

I'd like to unclutter my ER diagrams by hiding FK's and PK's. Is there any way to do that?

For example I've built an Er diagram and specified primary key and set up some "associations", which automatically creates Foreign Keys.

All my tables have a footer section with FK's and PK's listed, but I want to hide these. Is there any way to do it? I've been through the Diagram properties menu but can't find anything to hide them.

If I delete the FK behind the scenes, it removes cardinality icons

3

General Board / Re: Kimbal Star Schema modelling

« on: February 05, 2024, 11:36:17 am »

Thanks for that feedback. With regards to C (the columns not being ordered), I just removed and readded the two stereotypes. Strangely I now found "table" in the "none" category. So now instead of these stereotypes in the property page

dimension
EAUML::table


I have these

table
dimension


as long as "table" comes first then column ordering works. It seems like I just need to click in the right order

4

General Board / Re: Kimbal Star Schema modelling

« on: February 02, 2024, 05:51:34 pm »

Thanks for your response.

I was hoping there was an already built MDG for me but it looks like I need to create my own.

I have been through the profile creation process once without success (I couldn't find any of the stereotypes that I created). Will the Profile creation process allow me to "inherit" all table features as well as filter in the Matrix view?
 
Regardless I'll try again

5

General Board / Kimball Star Schema modelling

« on: February 02, 2024, 04:55:19 pm »

HI,

I am working on a star schema physical database model in Sparx EA

I'd like to tag tables as "Fact" or "Dimension", then I'd like to utilise this with a few features.

Stereotypes look promising for this. I've created two "stereotypes" from the "UML Types" button in the Configure/Reference Data menu called "Fact" and "Dimension" with base class = "class"

Then I've gone to the table in my model and added the new stereotype to the table. Now the stereotype is both "fact" and "EAUML::table"

My objectives are:

A. Make the tables visually different - DONE

B. In the "Matrix" view I'd like facts in rows and dimensions in columns (this gives me a Kimball enterprise bus matrix), however there doesn't seem to be a way to filter on stereotype for rows and columns in this view. If I could get "fact" and "dimension" in the "Type" drop down list this would work.

C. Also I've noticed that now I've added the extra stereotype, the column order in the table is no longer honoured

D. Without extending the scope of this question too much, it would also be great if I could pluck a fact straight out of the toolbox.

Can anyone assist with items B and C?

I've read some help files around D but it seems quite complex