Showing results for 
Search instead for 
Did you mean: 

How to Mark join as left outer join in Info set

0 Kudos

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,

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

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.



Active Contributor
0 Kudos

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,