on 10-12-2011 12:39 PM
Hi Experts
I want to create a decision node in the process chain which has to trigger only on 16th of every month.
basically i want to load the data from DSO to infocube on 16th of every month.
Kindly suggest how to write a formula in formula builder of decision process and test it.
Thanks & Regards
Jana
Hi,
Assuming you are taking about the 'Decision Between Multiple Alternatives' process type you can use the following formula:
RIGHT( 2, SYST-DATE ) = '16'
This will make the process go green whenever the current date is 16th and red whenever this isn't the case. Please be aware that process chain will stop moving forward depending on how you developed it.
click on the create formula button within the process and then go to expert mode and copy/paste the above (assuming you are on english system)
Hope this helped
C.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If I am not wrong , you are planning to use Decision process step for a local chain.
1. Just include the below formula in the Maintain Variant of Decision step of your Local Chain
for If ---Formula 1 : Current date = 16
for else--- Error
2. Now connect your local chain to the decision step with condition 1 i.e.,formula 1.
3. Schedule your main process chain as per your process.
Let me know if this helps.
Regards
Sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
you can achieve this with 2 options.
1) create PC which has this loading steps and schedule this PC to run on monthly basis(every month 16th)
2) say you have already PC which is running daily and you want to insert this loading step in that PC.
used decision process type, decision process will work based on IF-Else loop.
create condition if sys date is 16 then trigger both else trigger 1.
check below article
Regards,
Venkatesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Janardhan,
Kindly have a look into below link,
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f095592f-42f7-2a10-6ab1-c836a559b48f
Check wheather this helps.
Regards,
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.