Skip to Content
author's profile photo Former Member
Former Member

Delete a request from cube already rolled up.

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 06:53 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.