The idea is to have a more compact view of your project.
full screen example : https://bl.ocks.org/raflemmens/raw/7e57fa84e09671fd10b38c6a09d992ce/
This shows the entire etl project based on a timextender repository. Now you can see the complexity and show it to non technical people as well.
You could also add a box next to the graph showing search results or paths.
How it works:
- search for a table
- Trace direct connections and fade out non related
- trace direct sources from your selection and fade out non related
- trace direct destinations from your selection and fade out non related
- trace all connections (full path) and mark them red
- trace all connections going to the source and mark them
- trace all connections goig to the destinations
- trace all connection and remove non related elements
- trace all source connections and remove non related elements
- trace all destination connections and remove non related elements
- Blue (staging) : color shading refers to tables, views and custom tables
- Green (dwh): color shading referes to tables, views
- Orange : dimensions
- Yellow : cubes
How to activate/deactivate an element
- Click on a dot to select, double click again to deselect.
- scroll to zoom
- hold left button on the white area and move your mouse to postion the image on the canvas
- If you use option 7, 8 or 9 you need to refresh the page to get the orignal view (haven't implemented a reset for that yet).
So this is a basic relation diagram based on table relations and not yet on field relations.
You can have a faster way to show relations, impact and search a bit faster than currently is possible in timextender.