BPC 10 Microsoft Platform, Business Rule VS. Script Logic
Some customers and partners who are using BPC 7.X Microsoft platform may remember my blog that is related with Business Rule Performance.
Here is the URL that I posted before.
Unfortunately, it is not true anymore in BPC 10 Microsoft platform for some cases. In other word, Script logic can be faster than Business Rule in BPC 10 MS.
The reason why Business Rule WAS FASTER than Script logic is the location where the code is running.
In BPC 7.X, the Business Rule was running at the Database server side so all result data could be written by Stored Procedure.
In BPC 10 MS, Development team changed its behavior so all data is written by ‘Send Governor’ where is in the Application server.
Thanks to this, data security and all other audit features will be checked same as input schedule but due to this change, whole performance benefit has gone. Maybe I can say script logic might be faster if you scope it well.
I had created OSS message about this for a customer and the answer that I got from developement was “it has changed as design.”
So if you are using BPC 10 MS and consider using Business Rule instead of Script, please verify performance first because it may be much slower than you expect. Especially, If you are trying to upgrade it from BPC 7.X, you may consider comparing the performance between business rule and newly converted
script logic that has same functionality as business rule.
I hope it will help all BPC MS customers and partners.
Hi James ,
Very informative document.This will help while upgrading BPC 7.5 to BPC 10.