Delete data after reload from cube through process chain in BI 7.0
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...
ABAPing not required to run a chain multiple times a day.
Yes 9.00 am should be set in the start variant as that will trigger the job for the first time in the day and the job you copied to in SM 37 will trigger it again the second time.
Sorry I may not be of any help with Events :(.
Did you click schedule after activating ..if not you have to do that.