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)?
Question
What does the Indirect 1:N relationship mean ?How can we analyze the Indirect relationship between tables ?
+5An 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
hajime.shimm wrote:
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
Hi Shimmen, Thank you
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.