Skip to Content
0
Aug 11, 2016 at 12:54 AM

Data Lookup/compare in BEX designer not RRI

34 Views

Hi All,

I have following fields in my Bex query .

CustomerID,Signed Date, Create Date, End date , End Reason.

I have created selections and formula using a key figure so that I have all the records that are created or signed in a selected date range , which is working fine.

Now, I want to exclude customer that are transferred from the above data set to have the actual list of the customers. My functional logic to identify so is - to get the records ended in the same date range ( End date range same as above) with the end reason Transferred . If customer ID of this list matches above that record/s should be excluded .

Basically its data set 1 minus data set 2 . Will I able to achieve above with one BEX query. So that I can use it in BOBJ.

As my end reporting tool is BOBJ(4.0) I cannot use RRI or replacement path variable list as it is not supported. We don't want to create universes over Bex queries and do query A minus query B at BOBJ level. No CMOD as well.

Any help or suggestions are really appreciated.

Thanks,

Raja