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