Skip to Content
0
Oct 29, 2018 at 07:22 PM

Script - Performance

91 Views Last edit Oct 29, 2018 at 07:23 PM 2 rev

Hello Friends,

Env - BPC10.1 on hana

I have a script which mimics fixed amount allocations. The %allocaitons are done using allocation engine script logic as a next steps after fixed amount allocation. The number of records its working with is not very large as we are currently working on shared services allocations only. If we run for the complete shared services functional area, it fails for memory, so we had to slice and run this script for each functional area for shared services, so that we do not run out of memory (even for one month). The script gives correct results.

Now we have a new requirement to do 2 step allocations by including allocations for direct costs too.

Do you advise us to change to a badi, currently our package link has lot of packages as we run the scripts by slice, with the addition of direct cost functions, the slices are going to double.

Its the same for %allocation run using allocation scripts, we have to further slice the selections down and run, due to memory issues.

*SELECT(%Senders%, [ID], SENDER,"[FA]='%FunctionalArea_SET%'")
*XDIM_MEMBERSET TIME = %TimePeriod%
*FOR %Sender% = %Senders%
	*XDIM_MEMBERSET SENDER = %Sender%
	*XDIM_MEMBERSET ACCOUNT = XXXXXXX
	*XDIM_MEMBERSET AUDITTRAIL = AUDIT_DRIVER
	*WHEN CostCenter
	*IS <>%Sender%
		*REC(FACTOR=1, A_ACCOUNT= X, AUDITTRAIL=AUDIT_ALLOCATION)
		*REC(FACTOR=-1, A_ACCOUNT=Y, CostCenter=%Sender%, AUDITTRAIL=AUDIT_ALLOCATION)			
	*ENDWHEN
*NEXT
Thanks for your time
Ed.