Skip to Content
Former Member
Sep 09, 2020 at 01:56 AM

SAP Universe Complex Conditional Joins


Hi All,

I am trying to implement the following two complex joins in the universe (data foundation) for some Webi reports. Each join involves 3 tables as shown below.

  1. Inner Join Table1 ON Coalesce(Table2.ID, Table3.ID) = Table1.ID OR Table3.ID = Table1.ID
  2. Left Join Table1 ON Table1.ID = Table2.ID AND Table3.ID > Table1.ID

I entered the second join condition in the SELECT for the join between Table1 and Table2. It resulted in a database error in the Webi report saying it could not bound the second condition. Also, the join lines between the tables in the data foundation seemed strange with an open ended line in the middle.

Any ideas on what would be the best way to implement this in the information design tool keeping performance in mind?