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)