Hi Experts,
we are now in a process of cleaning a BW system and we are getting from the SAP ECC some CUST_IDs (with an "X" Sign as attribute of this CUST_ID for notifying us that this CUST_ID should be deleted also in the BW System). The problem is that this CUST_ID infoobject is part of keys in several DSOs and Cubes and I am not really sure how can that be deleted. My questions now are as follows:
1. Which is the best option to do this, if this can be done? Does it have to be written a routine in the PSA (however this would only stop from loading the new CUST_IDs with the "X" Sign in the future, but cannot delete the ones that are already loaded in DSOs or Cubes?!)
2. Should I write a routine in the transformations of each BW-Infoprovider, where this InfoObject exists (for ex. in the transformation Infoobject CUST_ID-> SALES_DSO etc.)?
3. Or there is a function module that can do this perhaps?
I know that selective deletion is the best option, however, because we have more than 10000 CustomerIDs, it is very time consuming to do it one by one.
If any other idea, please let me know!
Best,
Regys