Recently I put my hands on WEBI 4.3 SP4 and started to play with the dataset mode. I noticed an odd behaviour of the left join. By the definition, the left join should return all rows from the primary (‘left’) table.
However when I try to join data to an empty dataset, the output is also empty. Any ideas why? According to my experience I still should get entries from the primary dataset. Please see screenshots below showing the case.
Note 3462675
Left Join in Web Intelligence data mode do not return correct results if keys are duplicated in secondary table (One to many relationship)
Available with Patch .600
We are taking on .700 in week 42
Interesting, I have not noticed this though I have not done complex tests. So generally speaking, the whole left join of the data view feature is broken