Infoset - Left Outer Join

[Former Member]

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 · Accepted solution]

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

[Former Member]

So how can i have all records of A with the B records linked ?

[Former Member]

Hi,

It is difficult but if you need this report you could load a DSO before the infocube and creates the infoset between the DSO and the second infocube.

7. version is the first bw version which allows infocubes in infosets but it doesn't allow your requirement.

i hope it helps.

[Former Member]

thanks for help alec

points are assigned...

Cheers,

Vince.