Can we Skip '0' Key figure values while loading data to BPC from BW?

[Former Member]

Hi Experts,

We have set up a DM load that loads data to BPC from BW through a composite provider.

Due to Validation rules set-up in the back-end (UJ_VALIDATION), BPC rejects invalid combinations, but sometimes, the amounts are 0.

These can ideally be ignored, but the package throws a Warning message which confuses the users.

I wanted to know if there is any way to not load 0 amount values in BPC? I already went through some blogs that suggest Start/End routine in BW. But we are directly inputting these values through BW-IP (Input Templates), so i am not sure if this is a possible option.

Any suggestions here, please?

Please let me know if any more information is required

[former_member186338]

Sorry, but can you provide some sample with DM log attached? Not clear what do you want to achieve...

[former_member186338 · Accepted solution]

Look on the old sample here: https://www.sap.com/documents/2015/08/20211f55-557c-0010-82c7-eda71af511fa.html

Your case is simple - just check signeddata value and if zero - don't copy it to exporting table.

Please accept the correct answer.

[Former Member]

HI Vadim,

Ok I have 1 last ques.

Can this be done through a conversion file?

below is my conversion file -

EXTERNAL INTERNAL

and below is my transformation file where I am only loading the keyfigure ZIPA

and below is the source infoprovider.

When I run this, I still get rejected records as 0.

Is there anyway I can make changes to the conversion file to make this work, or is BADI the only option here?

Thanks

[former_member186338]

No, this can't be done using conversion file! That's the reason why I have proposed simple badi!

[former_member186338]

You can simply delete zero records in routine badi configured in transformation file. But are you sure that all zero records has to be removed?

[Former Member]

Hi Vadim,

Yes please. We need to remove all formats of 0's as below -

Please can you provide more details on the routine BADI for reference?

[Former Member]

Hi Vadim,

Please find attached log of DM package. Here the package gives a warning and rejects data, because of invalid combination maintained in UJ_VALIDATION rules, but the amounts are 0.

But this confuses the users thinking data has been rejected, but its just amounts to 0.

We wanted to know if we can avoid loading '0' values all together into BPC.

I hope this clarifies.

[former_member186338]

Sorry, but I have written hundreds of times: Please, NEVER use "Insert File" instead of correct "Insert Image"!!! I will not answer to the posts with "Insert File"

[Former Member]

Hi Vadim,

Sorry here u go

[shasan]

Hi Lavanya,

Hope this helps you with some work around.

0 Key figs