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

Regarding process chain

Hi Experts,

I have one scenario , after the end of the month move current month data to previous year and delete current month data using process chains.

can anybody explain please how to do this.

Flow:

DSO - Currentmonth cube -- prvious year

how to implement logic in process chain 2004s

Thanks

Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2007 at 07:12 PM
    75

    I m not sure if I understanding you, but what happened if you configure a process chain with the following flow

    1) Load data from Cube1 to Cube2

    2) If this was done successfully, then delete the data

    Hope this help you

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2007 at 07:25 PM

    Venkat,

    Put all these in same process chain.

    Load data as you mentioned... DSO -- Current Month Cube -->ABAP Program to trigger Event for Month End -> Previous year data Cube --> Delete Current Month Cube Data upon successful of Load to Previous Year Cube...

    If it is end of the month, trigger the Event in ABAP Program.

    hope this helps.

    Nagesh Ganisetti.

    • assign points if it helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Create an ABAP Program. in that check SY-datum value is monthend or not? if it is month end ... execute your Event using BP_EVENT_RAISE FM.

      If it is not month end, data won't go to Cube. you need to do ODS to Cube FULL load. once it comes monthend, you need to delete data from ODS.

      Hope this helps.

      Nagesh Ganisetti.

      • assign points if it helps.

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.