How to automate Data model view creation

[peto]

I'm asked to produce a number of views of our Data Warehouse, one for each Fact and it's related Dimensions. Do any have a solution that is able to do this without doing all steps manually?

[horszasz]

I’m sorry, but I don’t think your question is elaborated enough to get an answer on this forum.

What kind of view do you want to create? DB view? Or an EA view? Or a UML diagram? What information source do you want to work from? Is it a database re-engineering task or model transformation task (ore some other)?

If you clarify what the task exactly is, you are more chance to get an answer  

Cheers,
Gergely

[Sunshine]

Depends.
If you reverse engineer your Datawarehouse there is an option to create diagrams when importing.
Alternatively you can write a JavaScript to automate

[skiwi]

I think the question is not how to produce one diagram of the whole kit and caboodle - which as noted happens out of the box,
but have to have a separate diagram containing each fact table in a separate tables with its related dimesion tables.


So the short answer is nope.


I've done this manually for hubs in a data vault.


The question is how to identify the anchor table (e.g. by naming convention) and then spin up multiple diagrams.

[peto]

I think the question is not how to produce one diagram of the whole kit and caboodle - which as noted happens out of the box,
but have to have a separate diagram containing each fact table in a separate tables with its related dimesion tables.


So the short answer is nope.


I've done this manually for hubs in a data vault.


The question is how to identify the anchor table (e.g. by naming convention) and then spin up multiple diagrams.

Ouch - thought so. That is going to be quite a task to update a complete DW with multiple snowflakes. Well thanks for your help :-)