Skip to Content
Former Member
Oct 31, 2007 at 03:00 AM

Delete data after reload from cube through process chain in BI 7.0


Hi Experts,

My requirement is to delete existing old request from the cube after reload through process chain in BI 7.0. Cube gets feed from the DSO daily that too full load, due to some transformations we planned to go for full load rather than deltas to cube. Rather than deleting complete data beforehand we thought of loading first and than deleting the old request data from cube so that when users run report they can see the data from old request. Its possible in BW 3.x through process type Delete overlapping request but anyone tell me how can we achieve in BI 7.0. Is there any process type, which will delete old request after full data load to cube? If not how can one solve this issue.

I appreciate your time and help, Good answers will def. awarded with points...