Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: peto on September 21, 2020, 09:59:53 pm
-
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?
-
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
-
Depends.
If you reverse engineer your Datawarehouse there is an option to create diagrams when importing.
Alternatively you can write a JavaScript to automate
-
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.
-
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 :-)