To increase BPC script logic execution time

[former_member639843]

Hello Experts,

I am new in SAP BPC and looking for some of the links or KBAs which can suggest the best practices to improve BPC script logic execution.

We have a data manger package which executes BPC script logic and takes about 15-20 minutes for execution. I am trying to explore of there is any scope to improve the execution time however not sure where to start with. We are on SAP BPC Netweaver version 10.1.

Regards,

Richa

[former_member186338 · Accepted solution]

Sorry, but there is no magic solution to increase speed of script logic execution! Each particular case have to be analyzed!

1. Perform Lite Optimization with zero elimination regularly

2. Correct scope for calculation

3. Use RUNALLOCTION and business rules if possible

4. Avoid FOR/NEXT loops (using properties etc...)

5. Use parallel execution with RUNLOGIC_PH badi

6. Write custom logic badi to perform some calculations (including HANA based calculations)

7. Use BPC11 if possible (HANA) or 10.1 on HANA

If you want help for some particular script then: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/