Requirement:


In a week, process chain should load the records only on specific weekdays ? How to schedule it?

Here in this example, the chain should run only on wednesday  and thursday of a week?


Solution :


Here there is no need of creating an ABAP program or a factory calender. A simple formula in the Process chain will suffice the above requirement.


By this we can minimize the dependency of ABAP. Also we are not going to create a factory calender which is specifically to this particular process chain.


If there is any other chain which needs to be schedule only on Friday and Saturday, again we need to go for creating a factory calender. So instead a simple formula and the Decision Process type will solve this type requirement.


Step by step Navigation:


1. Go to RSPC, click on Create. Give the technical name & Description of the process chain  and click on Continue as highlighted below.

2014-01-17 11_13_16-Process Chain Maintenance Planning View.png

2 . Create a start variant for the process chain. Click on Create. Give the technical name & Description of the Start Variant and click on Continue.

2014-01-17 11_14_17-Process Chain Maintenance Planning View.png

3. Schedule the process chain for daily execution as shown below. Save the variant

2014-01-17 11_16_25-Start Time.png

4. Now the start variant is created. Click on Continue.2014-01-17 11_18_04-Process Chain Maintenance Planning View.png

5. Now drag & drop the Decision process type which is under General services as highlighted below.

2014-01-17 11_18_29-Process Chain Maintenance Modified Version_ PC for Wed & Thur.png

6. After that click on Create

2014-01-17 11_19_07-Process Chain Maintenance Modified Version_ PC for Wed & Thur.png

7. Give the technical name & description for the Decision Process type and Click on Continue.

2014-01-16 11_48_55-Process Chain Maintenance Modified Version_ PC chain test.png

8. The following Screen will appear. Click on Create under Formula column.

2014-01-16 11_53_20-Process Maintenance_ Decision Between Multiple Alternatives.png

9. Here  in this example the chain has to run on every Wednesday and Thursday of a week.

For this purpose, use the system variable ” SYST-FDAYW ”

The formula should look as below:
2014-01-16 11_55_33-Form.png

To schedule for any weekday, you can refer :


SYST-FDAYW 0 Sunday
SYST-FDAYW 1 Monday
SYST-FDAYW 2 Tuesday
SYST-FDAYW 3 Wednesday
SYST-FDAYW 4 Thursday
SYST-FDAYW 5 Friday
SYST-FDAYW 6 Saturday


Then Check the formula and click on Back button (F3).


10.  Following screen will appear. Here we have to specify the event. Click on the search button under the Event column as shown below.

2014-01-16 11_57_44-Process Maintenance_ Decision Between Multiple Alternatives.png

11.  Select the OPTION 02. This will make the chain to execute successfully only on WED and THUR based on the defined formula and click on check and save.
2014-01-16 12_00_28-Event Selection.png

12.  Finally the formula should look as below.

2014-01-16 12_01_01-Process Maintenance_ Decision Between Multiple Alternatives.png

13.  The Process chain is created. You can build the remaining as per your data flow.

2014-01-17 12_27_48-Process Chain Display Active Version_ PC chain test.png

This chain is a daily schedule. But it will run only on Wednesday and Thursday. Remaining days the chain will fail at the Decision Process type. It wont cause any issues.


** Feedback & Suggestions are welcome. Thanks.


— KRPK


To report this post you need to login first.

29 Comments

You must be Logged on to comment or reply to a post.

  1. Shanthi Bhaskar

    Hi Pavan,

    Good one…I have one doubt what if I make start variant with weekly schedule and selecting the dy based on start date…per say if I want to run on every Monday then I can set start date as 20th Jan 2014…then my chain will run every Monday.. On more thing is your chain run every day and some part gets executed once a week..

    Keep posting good info

    SB.

    (0) 
    1. Pavan Kumar K R Post author

      ** It will run on every Monday.

         In this case, it has to run on every Wednesday & Thursday.

      ** Yeah, the chain will run on every day. But the decision Process type makes the rest of the chain to run only on Wednesday & Thursday.

      Thank you Bhaskar

      (0) 
  2. sree hari

    Hi,

    Good Document,

    * We can use this approach for 4 days as well?

    *  the chain will run on every day- does this will leads any performance issues.?

    Regards

    Sree

    (0) 
  3. Shaan S

    Thanks for sharing wonderful document.It’s great help for scheduling Process Chains on specific days..

    I have tried this process in my IDES BI7.3 version, Towards the end once the PC was created I was unable to see event “Option2” ..Can you please let me know  the reason for this specific issue..

    Regards,

    Shaan..

    (0) 
    1. Pavan Kumar K R Post author

      Thank you Shaan.

      When u click on OPTION 1 under EVENT. Search help like button will appear and once u click on, an Event Selection pop up will appear as mention in step 10 where u can select the OPTION 2. 

      (0) 
      1. Shaan S

        Hi Pavan,

        I Was successful till step11, in step11 while I was trying to check the formula, I’m getting error message as “Not all Formulas exist on the Database”..My IDES version has DB2 Database, Doesn’t this formula work on DB2 Database?

        Thanks..

        Shaan

        (0) 
  4. Els Schepers

    Hi,

    I already used this decision process in some chains.  In case the chain runs on other days (so, not on wednesday or thursday as according to your example), the chain ends in error. So, I added an additional process with the execution of a dummy (empty) ABAP program.

    Kind Regards,

    Els

    (0) 
    1. Juan Jose De La Garza Torres

      Hi Els,

      I have the issue of a chain ending in error, because i’m only using one decision option. So i searched “Dummy Process Chain” and i found your post. I will really appreciate if you would tell me which ABAP program you added for this purpose.

      Thanks in advance

      (0) 
    1. Durgamadhab Mishra

      Hi Parthiban Ganesh  …

      Really appreciate you participating in forum and appreciation of good blogs… However Please refrain from creation of a lot of comments without any specific value to add.. I almost saw close to 15 comments that you have created on almost all of them being the same..

      here are some example of comments with in last 30 mins..

      BusinessObjects 4.0 Single Sign On (SSO) with WIN AD

      DSO Overwrite and summation function

      #HowTo use a #SAP #BW query directly as datasource

      This flows in the communication stream and dilutes the value of the forum.. To tell your appreciation just liking the blog or rating is enough..

      There has been already blogs by Matthew Billingham and Jürgen L and other moderators telling this type of behaviour is not appropriate.. like below..

      Endless thanks…

      (0) 
      1. Matthew Billingham

        I appreciate you bringing this to my attention. There are some reasonable discussions in these comments, hidden by “thanks, that was nice”.

        If you like content, but don’t have anything more to say, use the “like” button. A comment isn’t necessary.

        I’ve tidied it up now.

        (0) 
        1. Els Schepers

          Hi Matthew,

          In this case you’re right (if there’s no added value in the message, just like the post), but sometimes I wonder how/why moderators act a certain way. Last week my post (on a BEx issue) was removed because it was not posted in the BEx space under this space (SAP Netweaver BW) here .  I suppose BEx space is a subspace of this one.  Why wasn’t my post moved to the other space ? Moreover, when I read the rules of  the forum this is not listed as “forbidden”.

          I apologize for writing this here, but I don’t know an other way to contact any moderator directly about this.

          Kind Regards,

          Els

          (0) 
          1. Matthew Billingham

            Most likely, it was me who rejected your post.

            It’s not against the rules to post in the wrong space, but moderator action isn’t limited to breaches of rules. If you get a rejection it won’t always because you broke the rules.

            Moving a post takes rather more work than rejecting and asking the poster to repost in the right space. My experience is that if I reject posts in the wrong space, the member posts in the right space in future. If I move it, they often don’t. I find rejections more effective in modifying behaviour than moving the posts. Since I adopted this practice, I’ve found that the flood of BEX postings in the wrong space has reduced to a trickle. I think that benefits everyone.

            The correct place to continue this discussion is in SCN Support space. Unfortunately, I can’t move comment threads!

            (0) 
      2. guest g09

        Durgamadhab Mishra Sorry, i’m not active in SCN these days. So, i’m unaware of any blogs/SCN rules that mentions ‘not to Appreciate’ the blogs/documents.

        Anyway, can anyone please help me with Deactivation of my SCN account?

        Goodbye.

        (0) 
        1. Durgamadhab Mishra

          Hi Parthiban,

          If you read the blog post and the comments what other SCN members suggest there is not to discourage from posting comments… and please do not take anything personal, we all really like and appreciate your valuable contribution  in BI space..

          The intention is just to try and add our own two cents and make SCN as clean with high quality content to help SAP developers and users like us in the long run. All the SCN guideline  are setup only make the forum clean and more useful for all of us..

          (0) 
      3. Anshu Lilhori

        Its for the sake of Pay it forward badge for which one of the Prerequisite is to comment on numerous blogs and documents and earning two badges in 2 days leads to such comments which indeed does not add any value.

        (0) 
  5. Mallikarjun Baramal

    Hi Pavan,

    Very well documented and nicely explained.

    I have one query on this. Should we use the decision step to run the chain specific time in the same day?

    lets us assume we want to run the chain daily at 10:00 am in the morning and at 1:00 pm and 6:00 pm daily. can we use the step decision process and create the formula to run on specific time only?

    Thanks and Regards

    Mallik

    (0) 
  6. Loed Despuig

    Very nice blog Pavan!

    Just want to clarify why did you choose OPTION 2 instead of OPTION 1 in step 11? Will there be difference?

    Also, is it possible for me to make this decision type? I want my process chain to run every MON-FRI only but if the last day of the month is SAT the chain should still run..How will I do this? Is there a formula operator where it can detect the day of the last month?

    Thank you!

    Loed

    (0) 
  7. Prashanth Mullangi

    Hi  Pavan,

    Thanks for the nice presentation,Can you help me in one requirement here,

    I need to schedule a job for EVERY WEDNESDAY OF 3RD WEEK IN A MONTH.

    How to make it..Thanks in advance.

    Prasanth.M

    (0) 

Leave a Reply