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 on the Left Side implicitly, while I want it to be the other way round.

Thank You!

Regards,

Priyank