Using SAP BPC 10.1, Version for NetWeaver for Real-Time Integrated Planning Without Any Data Duplication

  • by Pravin Datar, Director, SAP BusinessObjects Planning and Consolidations Solution Management
  • March 3, 2015
Learn how to configure SAP’s Business Planning and Consolidation (BPC) 10.1, version for NetWeaver with SAP HANA for planning using any SAP or non-SAP data as reference data for BPC planning functions in real time, without any data duplication or replication.
Learning Objectives

Reading this article, you will learn:

  • The features of the SAP BPC 10.1, version for NetWeaver embedded model
  • How to configure Smart Data Access with an external database
  • How to configure SAP Business Warehouse (SAP BW) to consume external data in planning applications
Key Concept

The SAP HANA system handles data such as local tables on the database. Using automatic data type conversion, you can map data types from databases connected via SAP HANA Smart Data Access to SAP HANA data types.

SAP’s Business Planning and Consolidation (BPC), version for NetWeaver 10.1 became generally available in Q2 2014. With this release of BPC, SAP offers two model types, standard and embedded, that can be deployed to meet your business needs.

The architecture and functionality of the standard model type is very similar to BPC 10.0, version for NetWeaver, whereas the embedded model type is similar to the modeling paradigm of SAP BW Integrated Planning (BW-IP) and Planning Applications Kit (PAK) where master and transactional data from the entire host EDW environment is accessible by the application.

The embedded model allows easy access to all data within the host BW, as well as other data sources accessible by SAP BW, including big data. The embedded model in BPC 10.1, version for NetWeaver uses SAP HANA as the primary database and therefore can easily leverage the features and functions of SAP HANA to extend the scope of planning functionality offered by BPC. I explain how you can use the embedded model to easily access the non-BW data within the SAP HANA database, as well as go beyond data contained within SAP HANA by leveraging the Smart Data Access (SDA) feature of SAP HANA to use external data in planning applications within BPC 10.1, version for NetWeaver.

This is a potential game changer in more ways than one. First, users can easily extend their reach to any internal or external, SAP or non-SAP data accessible by SDA, to use it in the embedded planning models. Second, this data is real-time data and therefore increases the agility of the planning application. Third, all this data management can be done without any data duplication or replication since SDA creates only virtual tables without storing any physical data.

Features of the BPC 10.1, Version for NetWeaver Embedded Model

Both standard and embedded models can be used in the SAP Enterprise Performance Management (EPM) web client, EPM web reporting, and mobile reporting in similar ways. Both models make use of business process flows, work status, process chains, and granular transports in similar ways. Both support SAP NetWeaver authorizations and customizing using ABAP.

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


11/7/2016 3:38:30 PM
Pravin Datar

SDA is currently supported for read access only. You can write back from SDA, but it won’t be supported. I recommend using SDA only for read access.

11/7/2016 2:56:30 PM
Aaron Benner

Pravin, great article on using SDA with IP.
Can SDA also be used to write back from BW-HANA into an external database? We have this requirement to write back real-time and wish to avoid using OpenHub.

Please log in to post a comment.

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