Skip to Content

How to do an exclusion per source system?

Hi,

Just wanted to know how do you guys exclude a list of particular items per source system data flow?

For example, I have SD, COPA, MM reports in BW coming from different source systems. Then for one (1) system, I wanted to exclude 10 CUSTOMERS. And for another source system I will exclude three (3) SALES ORGANIZATION. How do you guys do it so the system will automatically exclude those list in loading to BW or exclude them from loading in the REPORTING LAYER ADSO of BW?

Yes we can exclude them via DTP. But I'm looking for a way to do it globally and not per transformation of the transactional data. Is there a way to do it?

I'm thinking of having a maintenance table where I can maintain the list of exclusion per source system. But I still need to do a routine to look up the values in the maintenance table. My worry is what if the developer forgot to lookup the excluded values in the maintenance table, then there will be a problem.

Is there any other way to achieve this? What is the best way to achieve this?

Thank you.

Loed

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Oct 29, 2018 at 09:52 AM

    Any help?

    Thanks.

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2018 at 09:03 AM

    You could do it indeed via a maintenance table (ideally an ADSO), but then you need routines to read this table (ADSO). The only other (and better) option, according to me, is to work with DTP filters. At one of my clients they tried combining these two options, which, trust me, overcomplicates things and ends up in a big mess (which I'm trying to solve now).

    Technically you could actually block this in a start routine (which I used to prefer, but disavdice against nowadays).

    Add comment
    10|10000 characters needed characters exceeded