Skip to Content
0

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

Oct 26, 2016 at 07:49 PM

105

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Oct 26, 2016 at 08:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 07, 2016 at 08:56 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 07, 2016 at 09:08 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 07, 2016 at 11:44 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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!"

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

Thanks for the input Vadim...

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 08, 2016 at 05:05 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded