Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Infoset - Left Outer Join

Hello guys,

I have two cubes A and B in an infoset I.

These cubes ares joined by a common characteristic.

In the best case i would have :

- all records of A and B linked (so in a same line)

- all other records of A not joined with B

- all other records of B not joined with A.

At worst i would see :

- all records of A and B linked (so in a same line)

- and all other records of A

So i try to use Left Outer Join with ON-condition.

In selected objects i put "left outer join" for A.

In Global properties i mark "lft outer : add filter value to on-condition".

But i've got the following errors :

- "Incomplete ON conditions in an outer join"

- "Invalid ON condition for left outer join" (cube A)

I hope you can help me,

points will be assigned.

Best cheers,

Vince.

Former Member
Former Member replied

Hi ,

An InfoCube cannot be a right operand of a left outer join due to performance issues.

In your case you have two infocubes and it isn't possible to do a left outer join.

Regards

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question