• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

SAP BPC - BI/BW Training

70 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
SAP BPC - BI/BW Training course and certification
23 Learners

About this Course
SAP BPC (Business Planning and Consolidation) is an important module under SAP EPM portfolio and is integrated on a unified platform for financial processes. 
BPC supports business planning, consolidation, and financial reporting.

SAP BPC: This course is designed to cover all topics under BPC comprehensively.
It is an instructor-led online course with lifetime access to session recordings, tutor-notes, practice on the server, preparation for SAP BPC certification, and access to Uplatz Training Hub.

SAP BI/BW: This allows for data to be translated into highly useful information, helping to understand the business better and enabling timely and fact based decision making, ultimately leading to remarkable results for the organization.
The SAP BI in conjunction with SAP Business Objects forms one of the best reporting tools currently available in the ERP industry.

SAP BPC - BI/BW Training

Course Details & Curriculum

1 Overview of Enterprise Performance Management

1.1 EPM Solutions and the Software tools

1.2 Introduction to Concepts in Planning, Budgeting, Forecasting and Consolidation

1.3 Introduction to Scenario Based Planing


2 Overview of SAP Business Planning and Consolidation

2.1 SAP BPC: Business User-Owned and managed

2.2 Unified Planning and Consolidation

2.3 SAP BPC for Netweaver Architecture

2.4 Introduction to SAP Netweaver BW Objects

2.5 Introduction to SAP BPC Objects


3 Designing a Model with SAP BPC

3.1 Case Study

3.2 Designing the Data Model in SAP Netweaver BW

3.3 Building the Model in SAP BPC

3.3.1 Environment Management

3.3.2 Dimension Management

3.3.3 Designing Models

3.3.4 Designing Security Model

3.4 Consulting Issues


4 Loading, Scheduling and Managing Data in SAP BPC

4.1 Loading Data from Source system to cube in SAP Netweaver BW

4.2 Loading Data from SAP Netwearver BW to SAP BPC

4.2.1 Creation of Transformation and Conversion File

4.2.2 Data Manager packages

4.2.3 Process Chains

4.2.4 Loading Master data from flat file into a dimension

4.2.5 Loading Master data from InfoObject into a dimension

4.2.6 Loading Hierarchy from an InfoObject into BPC dimension

4.2.7 Loading transaction Data from an Infocube into SAP BPC Model

4.2.8 Copying Data inside BPC Model

Consulting Issues


5 Reporting, Planning and Analysis in SAP BPC

5.1 Reporting and Analysis in SAP BPC

5.1.1 Introduction to SAP EPM Add-In interface for Excel

5.1.2 Creating Reports

5.1.3 Developing reports using dynamic templates

5.1.4 Developing reports using EPM Functions

5.1.5 Developing reports using EPM RetrieveData Functions

5.1.6 Develping Rolling Forecast reprot




1. SAP Introduction: 

•History of SAP

•Evolution of ERP

•ERP Packages

•SAP R/3 System – ERP Backbone

•SAP R/3 Modules – SD, MM, FI

•Types of all other ERP Packages in Market

•Advantages of SAP ERP Compared to other ERP Packages

•SAP R/3 (or) ECC Reporting

•Limitations of SAP R/3 (or) ECC Reporting.


2. SAP Case Study:


3. SAP Data warehousing: 

•Introduction to Data warehousing

•Fundamentals of Data warehouse

•Definition of Data Warehousing

•Key functions of Data Warehousing

•Applications & Types of SAP

•Difference between OLTP vs OLAP

•Types of Data in SAP

•Multi Dimensional Modelling

•Star Schema and Extended Star Schema


4. SAP BW/BI Introduction:

•Introduction to SAP BW/BI

•History of SAP BW/BI

•Necessity of SAP BW/BI


5. SAP BW/BI Architecture: 

•Source System & Target System

•Source system connections

•Data Modelling, Extraction & Loading

•Data Reporting


6. SAP BW Data Modelling: 

oData Warehousing Workbench

oInfo Obects & Types of Info Objects

oInfo Area4. Info Object Catalog

•Application Component6. Activation of Business Content

•Master data & Transaction data

•Data Source, Info Source

•Data transfer methods for SAP Systems (PSA and IDOC)

•Info cube


•Info Set

•Info Provider

•Multi Provider




•Info Package

•Open Hub Destination

•Transfer Rules

•Update Rules




7. SAP BW Data Extraction: 

•Application Specific Extractors(BW Content Extractors & Customer Generated Extractors)

•Cross Application Specific Extractors ( Generic Extractors)

•LIS Extrction

•LO Extraction

•COPA Extraction

•Data Extraction using other tools

•BW Data Source Enhancement

•SAP BW Data Loading & Scheduling – 3 Hours

•Introduction to Process Chains

•Process Chains in SAP BW/BI

•Types of Views in Process Chains

•Process Chain Creation

•Process Chain Monitoring


8. BW Data Reporting: 

•Bex Query Designer

•Bex Analyzer

•Bex WAD

•Restricted & Calculated Key figure


•Rows & Columns

•Free & Filter Characteristics

•Types of Variables

•Conditions & Exceptions


9. SAP BW Real Time/Project Scenarios: 

•Production Support Issues

•Implementation Project Issues

•Migration/Up gradation Project Issues

•Tickets Handling

•Batch Jobs Monitoring

•Ticketing Tool Tracker.

•SAP BW Clients & Projects Discussions:

•Importance of SAP BW Projects in Market

•Type of Domain Industries & Clients using SAP BW/BI


10. SAP BW Data Transportation: 

•System Landscape

•Transportation Landscape

•Overview of Transports

•Objects Collection in Transports

•Sequence of Transports Migration

•Transports Collection & Setting

•Transport Issues


11. SAP BW Performance Tuning Techniques: 




•PSA Tabe Deletions

•BI Accelerators


12. SAP Knowledge Sharing Sessions: 

•SAP OSS Notes

•SAP Marketplace

•SAP Developer Forum


•SAP Issues Forum

Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us