Skip to main content
SUBMITTED

Improve relation diagram

Related products:TimeXtender Data Integration
  • June 27, 2024
  • 2 replies
  • 25 views

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8

Hi,

when looking at your MDW relations it is often useful to use the Relation Diagram, for instance from a Fact table, to see what tables are linked together.

Usually you are interested in the tables linked to the table you are looking at as well as what field(s) are used to form the relation. In the current Relation Diagram, all tables are fully expanded and there is no indicator on what fields form the relation.

My suggestion would be to add (at least) two improvements:

  • collapse related tables by default - I want the table I am generating the diagram from expanded, all others collapsed. See the screenshot below for an example. Add a setting to influence this.
  • add a visual indicator to fields involved in the relation. Ideally I would like to see the collapsed tables show only the keys fields. Add a setting to influence whether relation key fields should always be shown, all fields should be shown, or fully collapsed.

 

 

2 replies

bas.hopstaken
TimeXtender Xpert
Forum|alt.badge.img+5
  • TimeXtender Xpert
  • June 28, 2024

It would be great if we can create a Relation Diagram in the Semantic Layer as well. 


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • Author
  • TimeXtender Xpert
  • June 28, 2024

Hi,

 

yes - definitely - I upvoted your old Idea. For others, please upvote this one as well:

 It was also on some of the longlists I have pushed to TX directly over the years.