We are loading data from SAP and non-SAP sources into BW (7.0). We load into PSA's first and then stage a lot of the data in a layer of DSO's before finally moving the data to a reporting layer (DSO and or Cubes).
I have built a chain to purge out data from the PSA's that is older than a month, and now want to also purge out data from the staging DSO's. However, since I am trying to delete older data but not the most recent data it keeps telling me it has to delete the new data requests before it can remove the older ones.
I saw some posts about using the selective deletion functionality, but didn't see any 'delivered' processes to build these into process chains? Also, I was wondering how the system would react since I have the data already populated to another set of infoproviders (for reporting), but by deleting this older data the two layers would no longer be able to be reconciled.
Thanks for any insights!