Tips and Tricks to Check and Manage In-Memory Execution of SAP BPC, Version for NetWeaver, Functions in SAP HANA More Efficiently

  • by Pravin Datar, Director, SAP BusinessObjects Planning and Consolidations Solution Management
  • June 14, 2016
Learn how to check and manage in-memory execution of planning functions in SAP BusinessObjects Planning and Consolidation (BPC) 10.1, version for NetWeaver, using techniques available in SAP BW as well as some useful user parameters. Learn how you can ensure you meet the pre-requisites for the in-memory execution of planning functions as well as some limitations for executing functions in memory.
Learning Objectives

Reading this article, you will learn:

  • How to check the prerequisites for executing planning functions in memory for SAP BusinessObjects Planning and Consolidation (BPC) 10.1, version for NetWeaver
  • How to leverage some SAP BW techniques to optimize in-memory performance of the planning functions
  • How to use user parameters to your advantage to fine-tune and achieve optimum performance of planning functions in SAP BPC 10.1, version for NetWeaver
Key Concept
FOrmula eXtensions (FOX) is the language used to create formula functions in SAP BusinessObjects Planning and Consolidation (BPC) 10.1, version for NetWeaver, embedded model. Formulas define how transactional data should to be processed to generate plan data, and enable the use of extended mathematical functions to calculate plan data. In addition to different calculation functions, which can be used for value assignment in formulas, there is also the option to model complex flow structures with FOX.

SAP BusinessObjects Planning and Consolidation (SAP BPC) 10.1, version for NetWeaver, is the latest generally available version of SAP BPC and is the most optimized version to use with SAP HANA. (For the purposes of this article, when I refer to SAP BPC NetWeaver from this point on, I mean SAP BPC 10.1, version for NetWeaver.) This version offers two model types: standard and embedded. The embedded model type can be used only with SAP HANA, whereas the standard model type can be used with or without SAP HANA (that is, with any other database supported by SAP NetWeaver).

However, regardless of the model type, SAP endeavors to push the calculations and data processing to the SAP HANA layer to leverage its enhanced processing power. As a result, with the current and subsequent Support Package releases, expect to see more SAP BPC NetWeaver functions pushed down to the SAP HANA layer (Figure 1).


Figure 1
In-memory execution of SAP BPC NetWeaver functions in SAP BPC NetWeaver 10.1

Pravin Datar

Pravin Datar works as director in the Enterprise Performance Management (EPM) Solution Management team at the SAP BusinessObjects Division. He has more than 20 years of business experience that includes management consultancy, ERP project management, and SAP SEM, BPC RIG, and EPM solution management. He holds a master’s degree in industrial engineering and an MBA from University of California.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.