Leveraging SAP HANA to Enhance SAP Business Planning and Consolidation’s Capabilities

  • by Sheldon Edelstein, Director of Business Development, SAP Platform Solution Group
  • October 15, 2014
SAP Business Planning and Consolidation (BPC) 10.1, along with its host environments (SAP Business Warehouse [SAP BW] and SAP HANA) provide abundant design choices to meet today’s business planning needs. See a comparison between the various models available in BPC to facilitate appropriate model selection based on business priorities. The potential to enhance BPC capabilities by using SAP BW MultiProviders and virtual providers to facilitate virtualized information access to data not readily available to BPC natively is explored in detail. SAP BPC’s capabilities are extended by showcasing the various HANA function libraries that can interact with BPC data. In addition, techniques for accessing data residing in external repositories and allowing access to that data by BPC through the use of HANA table views, HANA virtual tables, and HANA Smart Data Access are also explored.
Learning Objectives

By reading this article, you will learn:

  • The basic differences between the SAP BPC standard and embedded models
  • How to identify key components of BPC and SAP BW integration
  • How to identify key components of  BPC and SAP HANA integration
  • About the techniques for merging non-SAP BW data with SAP BPC data
Key Concept

SAP Business Planning and Consolidation (BPC) 10.1 works together with SAP Business Warehouse (SAP BW) and SAP HANA to deliver state-of-the-art planning and consolidation functionality. BPC 10.1 is able to deliver high value by providing model selection based on business requirements, as well as through its deep integration with supporting SAP BW and SAP HANA layers.

The Business Planning and Consolidation (BPC) 10.1 application running within a host SAP Business Warehouse (SAP BW) and an SAP HANA database provides numerous opportunities for efficient operations. The BPC application allows tailored selection of modeling paradigms to allow the best match to business requirements. The standard model allows for disengagement of the data model from the non-planning SAP BW community. The embedded model allows for significant reductions in data replication. Both models are provisioned with in-memory optimized function capabilities for fast calculations.

The SAP BW layer provides a portfolio of delivered integration content that simplifies access to SAP and non-SAP systems. Through the use of MultiProviders and virtual providers, BPC can easily consume information directly stored within SAP HANA.

SAP HANA provides a wide variety of techniques to efficiently process BPC/SAP BW information (i.e., predictive functions generating BPC forecasts). Data from external sources can be easily accessed using SAP Smart Data Access (SDA), SAP Data Services, and SAP Landscape Transformation (SLT) processes. This information can easily be virtualized into BPC/SAP BW for consumption or the information can be merged directly within the SAP HANA model.

Sheldon Edelstein

Sheldon Edelstein is a director within the SAP Platform Solutions Group specializing in SAP HANA, SAP HANA Accelerators, SAP Business Warehouse (BW), and SAP Business Planning and Consolidation (BPC). He has over 10 years of experience at SAP and currently focuses on business development opportunities across a wide array of industries and product solutions. Formerly an SAP Platinum Consultant and SAP RIG –Regional Implementation Group—Specialist, Sheldon has either directly implemented or provided architectural guidance for numerous large-scale projects. Currently, his primary area of focus is HANA, but previously he specialized in BW-IP (Integrated Planning), BW-BPS (Business Planning and Simulation), and SAP BPC. Sheldon is an active presenter at numerous events, a contributor to the SAP Customer Network (SCN), writes blogs on a variety of SAP topics, and is an author of many guides on SAP Service Marketplace for use by the extended SAP community.

See more by this author


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.