cancel
Showing results for 
Search instead for 
Did you mean: 

Merge Dimension not considering Left Join in SAP WEBI

0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

kohesco
Active Contributor
0 Kudos

Hi,

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

Grtz

Koen