I need some input regarding the following scenario in our P system:
1- Last week daily data loads to cube are rolled up in aggregates.
2- Sat and Sunday loads brough into PSA only
3- Monday load to cube is rolled up in aggregates.
Problem: Unable to further process loads in #2 to cube since their IDs are smaller than the one in #3.
Unable to delete request in #3 in Cube's manage view because it is rolled up. To be able to do this I must delete aggregates contents which I can not afford to do because it would take 2 days to rebuild.
OSS 633200 says that I could remove request in #3 by reversing it in the monitor.
Before doing the reversing of the request, I want to know the following:
a- Will I be able to process the requests from #2 after the reversal.
b- Will I be able to reconstruct request from #3 after step a is successful.
Tricky situation. The reversal shouldn't be the problem, done that before. Bare in mind that if this is a large request it will take some time to process. The system generates an exact copy of the original request, but then storno. So + gets - and vice versa.
This will probably not solve the ID sequence problem from your psa loads. You could try to mark them as repair full request from psa maintenance->schedule and in the InfoPackage screen -> menu -> scheduler -> repair full request. With this flag the system discards any checks on delta sequence etc. FYI see note 739863.
If you have any questions left: please ask.
If you are satisfied: please say thanks by rewards.
Kind regards, Patrick Rieken.