Skip to Content
avatar image
Former Member

SAP BPC NW 10.0 - Destination App - Does it sends records with zero values

We have a destination app script that sends the data from headcount model to reporting model. But before the script runs in headcount model, we clear the data area in reporting model. Wondering whether destination app sends data with amount as 0 for an intersection of the data. If it does, I am guessing we may not need to run the clear.

Assume the previous destination app run had an amount in the intersection of members, in the next subsequent run the amount is zero in the same intersection of members, if the destination app push 0 amount, we may be avoid the clear that we run before destination app. Do you know whether the destination app script pushes 0 amount?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Oct 26, 2016 at 08:30 PM

    "Wondering whether destination app sends data with amount as 0 for an intersection of the data." - empty records will not send zeros!

    You will need to run script to clear records in destination model. And to run this script you will need to implement RUNLOGIC_PH badi. This is the only correct way!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2016 at 08:56 PM

    Thanks. While optimizing, we do not remove zero records, so if the destination app script sends 0 records from source model to destination mode, I am guessing we don't have to do the clear in the destination model. I did a test and seems to be working, want to make sure I am not missing anything here...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2016 at 09:08 PM

    Incorrect idea not to remove zero records, it will affect performance!

    And in some cases, when you decide to delete some master data record you will have to perform zero elimination anyway...

    Are you 100% sure that you will never delete some member?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2016 at 11:44 PM

    Currently members are not deleted if they are used and have any data...

    Know your point on the zero record removal and the performance...........

    Just want to make sure with the current set up, I don't miss anything.. looks like not...

    Thanks...

    Add comment
    10|10000 characters needed characters exceeded

    • The key word is "currently"! It happen sometimes.

      There are number of other cases when you need to perform zero elimination (clear some incorrect data etc...)

      My recommendation is the same "You will need to run script to clear records in destination model. And to run this script you will need to implement RUNLOGIC_PH badi. This is the only correct way!"

  • avatar image
    Former Member
    Dec 08, 2016 at 02:22 PM

    Thanks for the input Vadim...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2016 at 05:05 PM

    If you agree with my arguments please accept the answer and close the discussion

    Add comment
    10|10000 characters needed characters exceeded