Col 1 and Col 2 are the two columns in the OLAP table I'm attempting to generate.
Where Col 1 from Table A can have 0 or many values associated from Col 2 of Table B.
The cardinality of Tables A and B is (1:N).
Currently in place-
Values in Col 1 of Table A that have no value associated with Col 2 of Table B are excluded from the OLAP table.
What I hope to accomplish-
Values in Col 1 should be shown, and values that have nothing related with Col 2 of Table B should have (Null/-) displayed in front of them.
The Join Functionality of Celonis does Left Outer Join, and considers the (N) side table (Table B) on the Left Side implicitly, while I want it to be the other way round.
Thank You!
Regards,
Priyank