WebI over InfoSet in BOBIP 4.1.sp2
I need help to understand the limitations of the WebI over Infoset. We have an infoset built using left outer join to the infocube and DSO. BEx query works fine, even with the range prompts that are not Date types. WebI doesn't. Changed prompts to use multiselects - still doesn't work. Looks like it dropped the Where clause all together from the WebI query. Runs forever filling the temp memory space on the DB side very quickly. Or maybe it creates a Cartesian product. Any help is greatly appreciated.