Skip to Content
author's profile photo Former Member
Former Member

How to write this Routine in BI 7.0

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 09:09 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 09:08 AM

    delete SOURCE_PACKAGE where FC_KEYDATE(4) ne '2007'

    Were u looking for this?? change of DATA to SOURCE

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.