on 09-22-2013 3:34 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.