Course announcements

  • Participants of this class will learn all of the key administration, configuration, and planning skills that apply to the SAP Business Planning and Consolidation, version for SAP NetWeaver: Embedded Model. * You will learn how BW, SAP HANA, Business Planning and Consolidation, Analysis for Office 2.1, and Integrated Planning can be used to provide a one stop shop for all planning requirements including local providers, local characteristics, and maintaining master data from the BPC Web Client.
  • Participants will learn how to model InfoCubes, Data Store Objects, Advanced Data Store Objects, MultiProviders and Composite Providers for standard and advanced planning scenarios for the Embedded model to meet requirements such as commenting and merging SAP and external data.
  • You will learn how to meet all business calculation requirements by using Excel options, standard planning functions such as top down distribution, FOX coding including rolling forecast, and ABAP Managed Database Procedures (AMDP) for example.
  • In the Design Studio, EPM add-in and Analysis for Office, you will learn how to connect to the server, create planning workbooks, how to integrate planning functions, how to apply advanced techniques that include VBA, and how to use advanced EPM and SAP functions.


  • Learn how to position SAP Business Planning and Consolidation, Version for SAP NetWeaver: Embedded Model
  • Learn how to model BW and Integrated Planning objects with SAP HANA
  • Plan and Report in the Excel Interface of the EPM add-in
  • Plan and Report in Analysis for Office version for Excel
  • Use business process flows and work status for planning scenarios


  • Application Consultant
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Developer
  • Developer Consultant
  • Enterprise Architect
  • Solution Architect
  • System Administrator
  • System Architect
  • Technology Consultant
  • Trainer



  • Sound knowledge of the content that is covered in BW310 – Data Warehousing course, especially working with the Data Warehousing Workbench


  • Experience with SAP Integrated Planning

Course based on software release

  • SAP Business Planning and Consolidation, version for SAP NetWeaver 10.1 sps8, powered by SAP HANA
  • SAP Business Warehouse 7.5 sps2
  • Analysis for Office 2.2
  • Design Studio 1.6
  • Enterprise Performance Management add-in for Office, sp25 equivalent
  • SAP HANA sps11 Revision 102.3


  • Overview of the Embedded Solution
    • Positioning Embedded
    • Introducing SAP HANA
    • Introducing BW
  • BPC Embedded Components
    • Configuring Real Time InfoCubes and related Planning Components
    • Configuring Direct Input Data Store Objects for Planning
    • Configuring Direct Input Data Store Objects for Price, Comment and Attribute Planning
    • Configuring Advanced Data Store Objects for Planning
    • Configuring MultiProviders and Composite Providers for Planning
    • Creating Planning Queries
    • Modeling Environments and Models
    • Configuring Local Providers
    • Managing Local Master Data
  • Integrated Planning
    • Reviewing Functionality, Architecture, and User Interface
    • Reviewing Characteristic Relationships, Aggregaton Levels, Filters, Functions, Sequences
    • Creating DSO Planning Functions
    • Positioning Fox Code
    • Using ABAP Managed Database Procedures (AMDP) and the Planning Application Kit (PAK)
  • BPC Embedded Administration
    • Administering Work Status, Data Audit, and Security
    • Administering BW Planning: Transports, Compression and Delta Merge
  • The EPM add-in
    • Connecting to the EPM add-in
    • Using the EPM Ribbon and Context
    • Using the EPM Pane for Planning Functions
    • Formatting
    • Using EPM Functons and Local Member Formulas
    • Using VBA and APIs
    • Sharing Report Axis, Linking Reports, Generating Worksheets, Multi Reporting
  • The Business Intelligence Platform
    • Positioning Analysis for Office
    • Learning Analysis General Features
    • Learning Analysis Planning Features
    • Planning with Design Studio
  • Embedded Business Process Flows (BPF)
    • Positioning Business Process Flows
    • Configurating Business Process Flows
    • Using BPFs
  • Web Reporting and Planning
    • Learning About the BPC Web Client Features