cancel
Showing results for 
Search instead for 
Did you mean: 

Process chain running on schedule or "on" demand

former_member206720
Participant
0 Kudos

Team:

I have a process to load main Cubes content into a mirror image cube known as History cube. We intent to have only 2 month of data in the main cube. We do not have BWA or Hana. The PC has  two branches, namely decision based running  on the first Saturday of the Month and on demand. I have some issues with the latter, there will be an InfoObject in which the user can write in the master data table "Y". This indicates the PC should run via the second branch. This section will be used in the event the first branch failed during the weekend and the customer support guys need to run the PC in manual mode. It is envisaged there will be a ABAP program reading the InfoObject searching for the entry "Y" if so the PC should continue doing the load.

From here, I have a couple of questions how can I test today the day I am running is Saturday and it is the firs of the month? and secondly, What kind of event should I use to make the PC work efficiently?

RAP

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member206720
Participant
0 Kudos

Suman: Million thanks for the doco. The decision tree has been completed. The question is how can I test for the first saturday of a given month when the current date does not fulfill the conditions? any idea?

former_member182470
Active Contributor
0 Kudos

Hi Raul,

You are welcome . Great to know that you have finished the decision taking mechanism.

To test the first saturday, you just change your condition to today(Monday). If it works for Monday, then obviously it will work on first saturday. Hope you got the trick..

Regards,

Suman

former_member185177
Contributor
0 Kudos

Hi Raul,

Means that you can assume the first Saturday of the given month should come between 1st to 7th date.

so you can use the DATE_COMPUTE_DAY function module and check where you will get the value "6". i.e, "Saturday".

Hope it resolves your issue.

Regards,

Krishna Chaitanya.

former_member206720
Participant
0 Kudos

Krishna: Thank you for your advice. I am using this formula in the decision tree DATE_WEEKDAY1( Current Date ) = 6. This will determine the day is a Saturday. Now the second decision will determine the first weekend on the month like this SUBSTRING( Current Date, 6, 2 ) <= 7.  These are standard SAP formulas. Unfortunately, I do not know how to test them or to determine what are the programs used by SAP to run those formulas, Any idea?

former_member182470
Active Contributor
0 Kudos

Missed my reply?

former_member206720
Participant
0 Kudos

Suman: I did not miss your point at all and I was happy with your reply. What, I would like to know is the FM(s) that run those formulas. That my friend is the point

former_member182470
Active Contributor
0 Kudos

You can make your main chain to take a decision to run on first Saturday , otherwise to run with the second branch with the below document. Check this document whether you can achieve without master data table intervention..

http://scn.sap.com/docs/DOC-11206

Former Member
0 Kudos

Nice Doc suman. Thanks.

Regards,

Venu

former_member182470
Active Contributor
0 Kudos

Thank you venu Gopal. You have to wish the actual author too.

Former Member
0 Kudos

Yes Suman Infact, I have gone to the actual thread (where the author posted this blog) to wish the actual author too, I saw the actual posted date over there , it looks very long back .. then I just simply gave my LIKE to that blog.. Thanks.

Regards,

Venu