SAP Analytics
Thought Leadership

When considering tradeoffs between performance, ease of maintenance, and integration with platform functionality, choosing the “language” to author business rules in BPC is a key decision. Of the many options available to BPC administrators & developers, BPC Script Logic is often selected as a reasonable compromise to access the power of database calculations without the high bar of outright code development. Promising a good balance between functionality, maintainability and performance, Script Logic is a set of functions that simplify the calculations most often needed in EPM processes.

BPC script logic provides powerful and flexible functionality, but if you don’t have previous SQL or coding experience, it may seem unapproachable.

I was recently asked about reporting Bank Balances and Overdrafts in BPC, particularly when the status can vary from month to month. The initial discussion concerned reporting a Bank Account balance as a Short Term Asset - Cash balance or a Short Term Liability - Overdraft but it led on to some more complex scenarios.

If you are using BPC for financial reporting and consolidation this is an issue almost every client has so its worthy of considering the options.

I was recently working at an organisation where the BPC implementation had developed over time with input
 from a number of third party sources. There were no problems with functionality but, like most clients, they would appreciate any changes which could produce an improvement in performance. Clearly, a variety of skillsets, approaches, and quality standards had produced a challenging situation for this client, and they asked our team to make suggestions.