on 2007 Jul 11 5:55 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
68 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.