Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Oct 30, 2019 at 07:05 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2019 at 06:43 AM

    Hi Lavanya,

    Hope this helps you with some work around.

    0 Key figs

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2019 at 08:17 AM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2019 at 08:47 AM

    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


    0-values.jpg (11.0 kB)
    0-conversion.jpg (88.4 kB)
    zipa.jpg (118.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2019 at 07:06 AM
    -1

    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.


    warning.jpg (142.5 kB)
    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.