Skip to Content
avatar image
Former Member

How to Mark join as left outer join in Info set

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 31, 2014 at 07:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded