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