- 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.
Define data model cardinalities in CPM4
+7Hi,
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 )
+2Hi Lucas,
also in CPM4 it should be possible to solve it by swapping the foreign key in the Data Model. If that doesnt help, maybe you actually have a 1:N/N:1 relationship in your data? Did you make sure that you actually have a 1:1?
Best
David
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.