PG

Given object definitions as rows and columns in a Spreadsheet (lovingly hand-crafted or retrieved via Query), is there any way to show attributes of the connections between them (when that connection is unique if existent)? The IS_CONNECTED_BY/QUERY_IS_CONNECTED spreadsheet formulas can only answer the question if there is a connection.

Alternatively, for a similar Matrix, can an attribute value of their connection be shown rather than just the existence of a connection? 

Use case: in information models, we have Entity Types which may share ERM Attribute objects connected to each ET object via is describing for (78), is primary key for (80), is foreign key for (79) connections. I want to get a table with Entity Types as columns, ERM Attributes as rows, with an X if they have a connection of any of these types, and that connection has a boolean attribute Mandatory with value equal to true. 

It would be nice not to have to go the report route. 

by M. Zschuckelt
Posted on Wed, 02/23/2022 - 09:18

Hello Pontus,

indeed queries are the way to go. You can define the connection as a query step in your query definition. Then you can pull that into the result spreadsheet and use the techniques to display attributes for that connection just the same as you do for objects in the query path.

In the example shown above you can pull the "carries out" step into your result spreadsheet and use the subsequent column for attributes of that connection type.

In the definition of the query you can choose, if you want incoming, outgoing or both directions of connections of a certain type.

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock