Delete a request from cube already rolled up.

[Former Member]

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.

Thank You

[Former Member]

Joe,

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.