Skip to Content
0

Merge Dimension not considering Left Join in SAP WEBI

Jun 13, 2017 at 06:05 PM

55

avatar image

We are trying to merge two queries by a common dimension and we would like to perform Left Join as query1 data Left Join query2 data. We did this by displaying the merged dimension column from query1 instead of merged dimension itself.

But, the results are produced using inner join instead of Left outer join. If we display merged dimension itself, it is considering Full Outer Join. Can you help us resolve this issue.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jun 15, 2017 at 02:02 PM
0

Hi,

if you use dimensions from query 2 it will be an inner join, set them as detail upon your merged dimension

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded