Skip to Content
Former Member
Jul 20, 2005 at 07:39 PM

Mimmicking a Non-equi-join


I'm trying to do something that sounds simple in theory but not sure how to implement in BW. Basicly I have 1) A Material Master that contains all of our Materials and 2) A Bill of Material ODS that contains all BOMS. I want a list of all Materials that are NOT found in the Bill of Material ODS.

I thought maybe I could create an InfoSet that combines the BOM ODS with the 0Material InfoObject but I can't find a setting for non-equi-join. I can find inner-join and left-outer-join but not a non-equi-join. Any ideas on how to go about this??