For a project in CPM4 I need to configure the cardinalities in a 1-1 table relationship. Unfortunately, Celonis detects the wrong table (for my use case) as the parent table, making the desired calculations impossible. Is there an option / trick similar to what David described in the answer of the first question in Process Data Model (relationship activity - case table )
- On the edge, it shows how you have configured the join. If you click on the edge, you will see that you have configured Activities as the 1-side of the Join, and Cases as the N-side of the join. I would suggest to use the Swap Tables option in the Foreign key settings to configure it in the correct way. Then, the cardinalities will be shown as you expect.
I already tried redefining the key and swapping the left and right hand table (and reloaded the DM), however this didnt make a difference.
Thanks, best regards,
Lucas