on 2007 Sep 20 5:00 AM
Hi ,
I need to write a simple routine in my Update Routine (BW 3.5) whereby only updated the data to the cube if the field 0COUNTRY='GB'
The rest should not be loaded.
Please advice
Hi,
Try this one in your start routine.
fill the internal tables "MONITOR" and/or "MONITOR_RECNO",
to make monitor entries
DELETE DATA_PACKAGE WHERE COUNTRY NE 'GB'.
if abort is not equal zero, the update process will be canceled
ABORT = 0.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Praveen,
I actually need a range to exclude,
So the code should be Country NOT EQUAL to GB, FR, RU
Can you please update the code below and send me back
[code]$$ begin of routine - insert your code only below this line -
fill the internal table "MONITOR", to make monitor entries
DELETE DATA_PACKAGE WHERE 0COUNTRY NE 'GB'.
result value of the routine
RESULT = .
if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
if abort is not equal zero, the update process will be canceled
ABORT = 0.[/code]
Hi Chris,
If you want to load only one country information (eg: Country = 'GE')
DELETE DATA_PACKAGE WHERE COUNTRY NE 'GE'.
Here you can change 'GE' to any value which you want to load. (GB or GE)
If you want to load multiple countries
DELETE DATA_PACKAGE WHERE COUNTRY NE 'GB' AND 'FR' AND 'RU'.
If you want to add one more country, you can achieve this by adding <b>AND '<country>'</b> at the end.
Cheers
Praveen
yup praveen advice will work fine .....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.