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.
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?