SAP – BPC Course Content

Overview :

SAP BPC (Business Planning and Consolidation) module focuses on management and financial budgeting and consolidation as well as collaboration through reports and scorecards. Another important feature in it is the predictive forecasting based on historical data.

Training Objectives of BPC :

SAP BPC is designed to empower every user without any skills, you can easily gain access to interact with and leverage financial and operational data for timely and effective decision making. It is a robust, multiuser platform which is totally integrated with Microsoft Excel. Initially leveraging off the power of Microsoft SQL Server and Analysis Services there is now another version that uses SAP Netweaver as its back end database.

Target Students / Prerequisites :

Students must have financial knowledge in budgeting and familiar with basic concepts in SAP BI and ABAP and Database Connections.

Introduction :

  • What is EPM, BPC, BI-IP
  • Architecture BPC-MS ,NW
  • Release strategy
  • Terminology

Administration :

  • Creating Applications and Applying Dimensions
  • Architecture of an Application
  • Explain the Tables, Optimization Options and Compression
  • Loading Transaction Data using a FlatFile
  • Creating a Transformation File
  • Creating a conversion file
  • Introduction to Logic/Calculations
  • Loading and Validating Data
  • Working with BPC for Excel
  • Developing Reports
  • Developing Input Schedules
  • BPC Comments
  • Book Publication
  • Working with BPC Web
  • Working with BPC for Word and BPC for PowerPoint
  • Advanced reports using multiple EvDRE
  • Creating Custom Buttons and Assigning Macros
  • Advanced Formatting options using Properties
  • Demonstrate Building Income Statement, Balance Sheet and Trial Balance reports using EVDRE
  • Demonstrate building a report reading data from multiple applications using EVDRE
  • In-depth study on BPC process flows

Planning :

  • Explain the Planning Process
  • Define the planning Model
  • Functional Specifications
  • Seeding the Plan
  • Rolling Forward Forecast
  • Calculations using Script Logic
  • Calculations Using Worksheet Logic
  • Allocations using Script Logic
  • Currency Conversion – Direct and using script logic
  • Competitor Analysis
  • Cost Center planning dry run

Additional :

  • Hot Analysis
  • ParknGo
  • BPC Journals
  • BPC Audit
  • Comments
  • Custom Menu
  • Business Process Flows
  • Lab Exercises
  • Project Exercises

Security Set up :

  • Task Profile
  • Member Access Profiles
  • Users and Teams
  • Work Status Settings
  • Using Standard Data manager Packages
  • Creating Custom Data Manager Packages
  • Automation of Master Data and Transactional Data

Pre- Requisites :

  • SAP BW Knowledge
  • SAP FICO Knowledge
  • Microsoft Excel

BI Performance :

  • Aggregates
  • BI accelerator
  • BI Statistics

Note: The course mainly focus on BPC system training, Planning and budgeting process, BI Concepts, FICO concepts. Or all the topics related to SAP BPC310 NW Version topics.

Courses Duration : 3-4 weeks

1
Main