How to Mark join as left outer join in Info set

[former_member195748]

Hi Folks,

I have 2 info cubes in Info set, I need to mark the join as Left outer join.

I have read some blogs where is says that it cant be joined, but one of my colleagues has made left outer join using two cubes.

I want to replicate the same thing into my design.

If i normally connect one IO to another cubes same IO- its a normal join- its not written as left outer join. I want to see left outer join written on my link.

I tried global setting but no use.

Am I missing some setting,

[former_member182516]

Hi Vivek,

Select the Info cube and right click on it and select JOIN type --> Left Outer join.

This is how you can get the Left outer join and which is written on the join.

Regards

KP

[sander_vanwilligen]

Hi Vivek,

Please have a look at SAP Note 577953 - @0S@ InfoSets (BW): Left outer joins.

The answer on question "3. How do I define a left outer join in InfoSet maintenance?" describes how you should proceed.

Best regards,

Sander