Got a question? Call 1800 853 276   |   

BPC450 – SAP Embedded Business Planning and Consolidation for SAP BW/4HANA

  • Length 5 days
  • Price $6600 inc GST
Course overview
View dates &
book now
  • Register interest

Why study this course

In this five-day instructor-led training course, participants will learn all of the key administration, configuration, implementation, planning, and reporting skills that apply to the SAP Business Planning and Consolidation, version for SAP NetWeaver and version for SAP BW/4HANA. 10.1 vs. 11.0 differences will be covered in detail.

You will learn how SAP Business Warehouse, SAP HANA, Business Planning and Consolidation, Analysis for Excel 2.5, and Integrated Planning can be used to provide a one-stop-shop for all planning requirements including manual and automatic planning, local providers, local characteristics, local hierarchies, maintaining master data from the BPC Web Client and creating master data on the fly. You will use a version of the BPC11.0 web client as well as the BW Modeling perspective in HANA Studio.

Participants will learn how to model advanced DataStore Objects, CompositeProviders for basic and advanced planning scenarios for the Embedded model to meet requirements such as data loads, manual input planning, characteristic relations, commenting and merging SAP and external data.

You will learn how to meet all business calculation requirements by using BW Queries, Analysis for 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 and Analysis for Excel, you will learn how to connect to the server, create planning applications, perform ad hoc planning, create style sheets, integrate planning functions, apply advanced techniques that include VBA, and use SAP functions. You will learn how to create advanced BW Queries, work with variables and hierarchies.

You will learn how to control planning processes with work status and business process flows, security, and how to transport new objects. You will manage work status and also launch activities from Analysis for Excel.

This course is based on software release:

  • SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA

  • Analysis for Office 2.5 (including the latest EPM features as of 12/2017)

This course is relevant for the following SAP Business Planning and Consolidation (SAP BPC) applications:

  • SAP BPC, version for SAP NetWeaver (BPC Embedded version 10.1)

  • SAP BPC, version for SAP BW/4HANA (BPC Embedded version 11.0)

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

This course will prepare you to:

  • Position SAP Business Planning and Consolidation, version for SAP NetWeaver: Embedded Model

  • Model BW and Integrated Planning objects with SAP HANA

  • Plan and report in Analysis for Office version for Excel

  • Use business process flows and work status for planning scenarios

  • Design BPC Embedded using best practices in a comprehensive end-to-end setting


Develop your SAP empowered employees with DDLS. Getting the right skills in place maximises the chance of project success and removes risk. DDLS provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. DDLS can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

  • Project Team Members

  • System Administrators

  • Advanced Business Analysts

  • Application Consultants

  • Business Process Owners / Team Leads / Power Users

  • Program/Project Managers

  • Trainers

  • Solution/System Architects

Course subjects

Overview of BPC11.0 Embedded

  • Positioning BPC11.0, Discussing Key Terms and Components

  • Describing BPC Implemention Options

  • Introducing SAP HANA

  • Introducing BW and How it is Used for Planning

Planning with BPC11.0 Embedded

  • Configuring advanced DataStore Objects for Planning

  • Designing Data Acquisition Solutions for Planning Scenarios

  • Designing CompositeProviders for Planning

  • Designing Aggregation Levels

  • Configuring Basic Planning Functions

  • Creating Reporting and Planning Queries

  • Using Inverse Formulas

  • Using the Planning Buffer

Using the BPC11.0 Web Client

  • Learning About the BPC11.0 Web Client Features

  • Modeling BPC Environments and Models

  • Maintaining BW Master Data

BPC11.0 Embedded Local Planning Scenarios

  • Configuring Stand Alone Local Providers

  • Configuring Integrated Local Providers

  • Integrating Local into Global Data

BPC11.0 Embedded Advanced Planning

  • Configuring Direct Input advanced DataStore Objects Planning

  • Setting Up Characteristic Relations

  • Creating Direct Input advanced DSO Planning Functions

  • Positioning Fox Code

  • Configuring Top Down Distribution

  • Configuring Planning Filters

  • Designing Planning Sequences

  • Loading Flat Files with Planning Functions

  • Optimizing Planning Activities including AMDPs

  • Master Data on the Fly

Analysis for Excel and Lumira Designer Edition

  • Positioning Analysis for Office

  • Learning Analysis Planning and Reporting Features

  • Using Analysis for Ad Hoc Planning and Reporting

  • Planning with Design Studio

BPC11.0 Process Control, Administration, and Recap

  • Administering Work Status

  • Administering Data Audit

  • Administering Compression and Delta Merge

  • Positioning and Designing Business Process Flows

  • Reviewing the Key Features



  • Sound knowledge of BW concepts and user interfaces (BW310 or BW310H equivalent knowledge)


  • none


DDLS offers certification and training through our partnership with SAP Inc. This arrangement requires DDLS to provide your details to SAP Inc for course and exam registration purposes.

Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.