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.