on 11-30-2007 8:29 PM
Hello ,
One of my client is upgrading from BW 3.x to 7.0 . I am trying to write this code in filter section of DTP(Data transfer process) n BI 7.0
The old code is like this:
delete DATA_PACKAGE where FC_KEYDATE(4) ne '2007'.
How do I write this in BI 7.0
Thanks for your help,
delete SOURCE_PACKAGE where FC_KEYDATE(4) ne '2007'
Were u looking for this?? change of DATA to SOURCE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If my understanding of the code is right - Records values not equal to 2007 for FC_KEYDATE(4) should not be loaded.
You can do this in DTP filter - Extraction Tab - Filter - Change Selections - Get FC_KEYDATE(4) - Input 2007
Sry if I am mistaken...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.