In physical model you can define Data Warehouse Type for your tables and graphically distinguish the Fact and Dimension tables.


By default, the Data Warehouse options are not available and must be activated in Settings. 
Standard Entity Properties form:


To display Data Warehouse Type options click Settings | Options and in section Physical Model enable the checkbox in group box Form Settings.


To set Data Warehouse Type then choose Dimension or Fact value from the Data Warehouse Type combo box.


Good luck! 

About the Author

Vaclav Frolik

Interests: UX design and graphics, Databases, Product / Project management, Web technologies, Online marketing and Favorites: Music bands: Pearl Jam, Audioslave, RHCP, Midnight Oil, Alter Bridge... Actors: Kevin, Edward, Jack, Jeff and my kids. Actresses: Kim, Jennifer Sports: MTB, Squash, Football (the one played with feet, not hands) Series: IT Crowd, The Big Bang Theory

Start the discussion at