Skip to Content
avatar image
Former Member

Merge Dimension not considering Left Join in SAP WEBI

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 15, 2017 at 02:02 PM

    Hi,

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

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded