SAP BPC (Business Planning and Consolidation) is a corporate performance management tool that can help automate and streamline corporate planning and consolidation activities for shorter budget cycles, a faster close, and improved regulatory compliance.  SAP BPC is one such tool that can be utilised for planning and consolidation for a wide range of processes. This is a fully robust and multiple user platform which is integrated with Microsoft excel. This application helps in maintaining the tack of a company's progress through it budgeting and forecasting process. It also runs on different platforms like Microsoft and SAP NetWeaver making it much more easier to use.

By the end of this training you will:
– Acquire the relevant knowledge required to clear the SAP certification exam.
– Understand the core concepts of SAP’s BPC module.
– Be able to apply the knowledge learned to progress in your career as an associate level SAP BPC consultant.


A good bachelor’s degree in any field would be an advantage. Awareness to database technologies and basic software knowledge is advantageous but not a must.

32 Hours

Although there is no guarantee of a job on course completion, we are almost certain that you should be able to find a suitable position within a few weeks after successful completion of the course.

Concepts & The Objects in BPC Administration

- Business Objects Overview and also the Advantages of BO PC
- Business Planning & also the Consolidation for Modeling
- Environment shell
- Terminology
- Environment Management
- Dimension Management
- Creating Models
- Security

SAP EPM 10.0 add-in

- Creating Planning & the Consolidation Connection

EPM Client : Microsoft Office Excel

- Create a Report
- Create a Input Form


- Enable Comments
- Input and Retrieve Comments

Multi-Reporting & also Axis Sharing

- Create a Multi-Reporting Spread Sheet
- Share axis from one report to/with another report


- Dynamic formatting
- Link a formatting sheet to one or several reports
- EPM Function to apply formats

EPM Cell-based formulas

- EPMAxisOverride Cell-based formula
- PMDimensionOverride Cell-based formula
- EPMInsertCellsBeforeAfterBlock Cell-based formula


- Create a Book Template
- Validate the Book Template
- Publish a book to the Web Library
- View the book in the Book Viewer

New Web Client

- Create a Planning and Consolidation Web Report
- Change the Report Behavior
- Add a Chart to Report
- Create a Web Input Form
- Entering Comments via Web
- Creating Document Types and Sub Types

Data Acquisition, Transformation, ECC and BW

- Data Acquisition, Transformations, Packages, and Package Links
- Master Attributes Loading from flat file to BI to BPC
- Master Text Loading from FLAT file to BI to BPC
- Transaction data from FLAT file to BI to BPC
- Master Attributes Loading from FLAT file to BPC Master text Loading from FLAT file to BPC
- Transaction data from FLAT file to BPC (SINGLE KEYFIGURE)
- Transaction data from FLAT file to BPC (MULTIPLE KEYFIGURES)
- Data Retraction BPC to BI and FLAT FILE

Working with Logic Scripts

- Logic Script and Online Execution
- Logic Script and Central Execution
- Logic Script and Allocation
- Logic Script and ABAP Integration
- Dimension Member Formulas

Drill Through New

- Drill Through features
- Create a new Drill Through
- Specify the specific parameters of a Drill Through
- Delete any parameter
- Test Drill Through

Business Process Flows

- How to manage Life Cycle of BPF Instances:
- Create/Start, Suspend, Reset, Archive
- How to manage assignment of Process and Activity
- Instances

Word and Power point Integration

- Explain MS Word Integration with BPC 10.0
- Explain MS PPT Integration with BPC 10.0

BPC 7.5 to BPC 10.0 Migration

- How to migrate BPC 7.5 Reports built with former EV Functions
- How to migrate BPC 7.5
- EVDRE Reports


- Work Status
- Audit
- Work Spaces