Append records during Allocation instead of Overwrite in SAP BPC 10.1 on HANA

[vamshib01]

Hello,

I am writing a top down allocation logic where I am trying to allocate a number (adjustment) from one member to base of several members based on the ratio of sales. I am writing this data to a new datasource member so I can keep track of the adjustment value.

For example: I have a sales number for a market as $100,000 that is distributed across all products. I need to bring this value down to $90,000 so I am trying to allocate -$10,000 across all products based on the ratio of the product to the total. My allocation works fine because now I have the original value in one datasource and the adjusted value in another datasource.

My issue is with running a FX Translation package. Initially I had lets say 1 million records which was taking the package around 20 mins to finish. The adjustment records add up 1 more million records taking an additional 20 mins for the FX package to finish with a total of 40 mins. I'm wondering if there is a way I can do an append during allocation instead of overwrite to the same datasource so my number of records are still 1 million. Your thoughts?

[former_member186338 · Accepted solution]

No, this is not possible. Allocation will always overwrite. Append is possible with when/endwhen but it's slow.

P.S. And in general append is dangerous - you can't repeat it...

[vamshib01 · Accepted solution]

Thank you. I agree Append is dangerous. However in this scenario just to minimize the volume of records felt it was my option. My main issue is to bring down the time of running FX package which is taking long because of the increased number of records.

I currently have my FX translation as a logic script. Would converting the script to a BADI be of any use in speeding up the process. There are about 8 million records for lets say FORECAST category for one month that takes 50 mins to finish via logic script. If a BADI was written, can this time be brought down any further? Also can the BADI handle so many records? Is this worth pursuing? Any other approaches I should look into to speed up the process?

[former_member186338 · Accepted solution]

vamshib01

Sorry, what do you mean by: "FX translation as a logic script"??

If you are using statement:

*RUN_PROGRAM CURR_CONVERSION

Then currency conversion is performed using abap program. Custom badi will not run faster...

[vamshib01]

Our FX is a script logic code with WHEN/ENDWHEN and LOOKUP to RATE model.

I'll try the CURR_CONVERSION option. Is setting up the correct properties in the dimension and writing the script logic to call the BADI all I need to do? Should I set up any Business rules in addition to this?

[vamshib01]

Nevermind I figured.