Profile picture for user ryan.bittner

I'm looking for a way to depict relationships/connections between objects in a Spreadsheet Model in order to protect them from Reorg destruction.  

I've come across the 'IS_CONNECTED_BY' function and would like to understand how it is used and what it depicts in the Spreadsheet Model.  Also, I've tried using this function but cannot get it to work.  

Any insight or guidance would be well appreciated.

 

Thanks, 

Ryan

by Veronika Ellermann
Posted on Mon, 10/17/2022 - 08:41

Hi Ryan,

To my knowledge speadsheet models are not a good choice for that (just like matrix models). Because objects and their relationships are not expressed in "real" models the objects and their connections are deleted during re-org.

I would create a "dummy" model where I express those objects and their connections. Then you can reuse them in the spreadsheet model and they won't be deleted during re-org. Hope this helps.

Best,

Veronika

0
by Michel Bénard
Posted on Mon, 11/14/2022 - 10:33

In reply to by Vee_ARIS

Hi @veronika

Because objects and their relationships are not expressed in "real" models the objects and their connections are deleted during re-org.

By default, objects and relationships which do not have occurrences in models but who are present in a Matrix model are not deleted during a database reorganization (this behaviour can be changed by changing an evironment variable when executing the reorganization)

0
by Veronika Ellermann
Posted on Tue, 11/22/2022 - 15:28

In reply to by m3b

Hi @Michel, can you tell me which variable that is? :)

0
by Michel Bénard
Posted on Mon, 11/28/2022 - 19:29

In reply to by Vee_ARIS

I think this will delete connexions which exist only as definitions in matrix models (which is not the default behaviour of reorg):

 

reorg dbname CXNDEFS_IN_MATRIX_MODELS

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

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