cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member212723
Participant
0 Kudos

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?

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member186338
Active Contributor
0 Kudos

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

former_member212723
Participant
0 Kudos

Thanks for the input Vadim...

former_member212723
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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!"

former_member186338
Active Contributor
0 Kudos

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?

former_member212723
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

"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!