Do we refer to the end to end relationship between the Table B (1) and Table A2 (Case Table - N), by ignoring the intermediate tables (Table A)?
Page 1 / 1
An indirect 1:N relationship means, in the case of this figure, that Table B and Table A2 have records that have a 1:N relationship via another table.
The intermediate Table A is referenced by the PU function in PQL to perform an aggregation between Table B and Table A2.
Here is the useful learning material for your reference.
https://academy.celonis.com/learn/learning-path/build-analyses-advanced
The intermediate Table A is referenced by the PU function in PQL to perform an aggregation between Table B and Table A2.
Here is the useful learning material for your reference.
https://academy.celonis.com/learn/learning-path/build-analyses-advanced
An indirect 1:N relationship means, in the case of this figure, that Table B and Table A2 have records that have a 1:N relationship via another table.
The intermediate Table A is referenced by the PU function in PQL to perform an aggregation between Table B and Table A2.
Here is the useful learning material for your reference.
https://academy.celonis.com/learn/learning-path/build-analyses-advanced
The intermediate Table A is referenced by the PU function in PQL to perform an aggregation between Table B and Table A2.
Here is the useful learning material for your reference.
https://academy.celonis.com/learn/learning-path/build-analyses-advanced
Hi Shimmen, Thank you
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.