I've just reverse engineered a Star Schema from our Data Warehouse and was wondering whether any of the Layout options properly catered for this? I've checked the pre-sets, and none seem to.
Specifically, is it possible to define the central Fact Table in a Physical Model and have DA automatically layout the dimension tables around it in a star?
And of so, does this extend to Snowflaked dimensions?
Also, some of our dimensions are used in multiple roles, so hopefully the diagram can create aliases - but that might be hoping for too much.
Any help will be appreciated - we really don't want to manually layout a star design.
Pinned topic Formatting a Reverse Engineered Data Warehouse Star Schema
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-11T22:49:15Z at 2013-02-11T22:49:15Z by dtc
dtc 120000NKV263 Posts
Re: Formatting a Reverse Engineered Data Warehouse Star Schema2013-02-11T16:00:11ZThis is the accepted answer. This is the accepted answer.Please do the following:
(1) In Data Project Explorer select the model, right click, and select "Use Dimensional Notation".
(2) Open the model, right click, and select "Discover Facts and Dimensions".
(3) Expand the model. You should see tables annotated with dimensional notation such as Fact, Dimension, etc.
(4) Select Diagrams, right click, and select "New Dimensional Overview Diagram" to create a dimensional overview diagram.
The dimensional notation and diagram work for star schema, snowflake schema and starflake schema. Please see the online help for more information.
mgibson 2700002RPC20 Posts
Re: Formatting a Reverse Engineered Data Warehouse Star Schema2013-02-11T22:04:25ZThis is the accepted answer. This is the accepted answer.
- dtc 120000NKV2
Thanks for the assistance. It didn't seem to recognise all of the dimensions using the automated process - it identified the Fact table just fine, but the final diagram only included 4 dimension tables, where the model actually has many more.
initially it thought there were more than one fact table and related the other dimensions to those, so I manually changed these designations.
Once I updated the dimensional notation, including which were 'outrigger' snowflaked tables, it did a much better job.
What a great feature of the product.
Thanks for your help.
dtc 120000NKV263 Posts
Re: Formatting a Reverse Engineered Data Warehouse Star Schema2013-02-11T22:49:15ZThis is the accepted answer. This is the accepted answer.
- mgibson 2700002RPC