+44 7459 302492
support@uplatz.com
SAP BPC (Business Planning and Consolidation)
SAP BPC (Business Planning and Consolidation) is an SAP module that enhances and automates the planning & summarized financial reporting processes in an organization. SAP BPC supports planning, cost budgeting and predicting capabilities with management and legal functionality in a single stand-alone application.
SAP BPC is one of the modules available in the SAP system that assists an organization with built-in functionalities for planning, budgeting, estimating, and consolidation. SAP Business Planning and Consolidation tool is a unified platform for finance related processes.
SAP BPC module helps the user with a single point of view for finance and operational data and combined solution which improves performance management process. It delivers in-built functionalities for calculated planning and cost-efficient budgeting. SAP BPC supports all operational and functional tasks involved in an organization and enables automation and restructuring business prediction, planning and consolidation related activities in an organization.
Thus SAP BPC tool is used by organizations for better decision making, minimize inefficiencies, consolidate financial processes, and improve user productivity.
------------------------------------------------------------------------------------------------------------------------------
Uplatz provides this comprehensive training course on SAP BPC module covering every aspect of BPC module along with demonstration of practical scenarios through easy-to-learn videos. Learn the core concepts, configurations, implementation and management of SAP BPC module through these SAP BPC videos. This is self-paced training course on SAP BPC.
------------------------------------------------------------------------------------------------------------------------------
Course Objective
The SAP Business Planning and Consolidation online certification course will make sure the participants learn the steps to create, manage and support the consolidation based on the SAP business planning and consolidation version release for SAP NetWeaver. The participants will also learn consolidation configuration and how to make use of the consolidation central tool.
------------------------------------------------------------------------------------------------------------------------------
Target Audience
· Application Consultants
· SAP Consultants
· Business Process Owners
· Program Managers
· Business Analysts
· Project Managers
· Financial Analysts
· Any individual aspired to make a career in SAP
SAP BPC (Business Planning and Consolidation)
v BPC-BASICS
Ø BPC - BW Overview
Ø BW BPC Integration
Ø Introduction and Architecture Overview
Ø Parameters setting for Environment & Models
Ø Environment Creation
Ø Model Creation and Relationship with Other Models
Ø Dimension Maintenance - Mandatory Dimensions
Ø Dimension Members and Properties
v DATA LOAD & MANIPULATIONS
Ø Data Manager Packages
Ø Advance Scripting in DM Packages
Ø Data Load Via Flat Files
Ø Data Load Via Info Providers
Ø Transformation File - Flat File Load
Ø Transformation File - BW Data Load
Ø Conversion File - Single File
Ø Multiple Conversions in Single File - BW Data Load
v LOGIC - BPC
Ø Script Logic Online Execution
Ø Script Logic Central Execution
Ø Default Logic
v TEMPLATE CREATION & USAGE IN BPC
Ø Use the New Formatting concept of EPM Formatting Sheets
Ø Building Input forms - Excel Based
Ø Building Report forms - Excel Based
Ø Multi Reports - Rolling Forecast With Actual & forecast Dynamically Changing
Ø Important EPM Functions
Ø Spread, Trend & Weight Functions
v BPC - WEB
Ø Library
Ø Workspaces
Ø Business Process F lows
Ø Data Audit configuration & Reports
Ø Activity Audit Configuration
Ø Comments
v LOCKING OF DATA & AUTHORISATION PROCESS
Ø Work Status - Environment Level
Ø Live Demo on Data Entry by user & Locking of Data Manager
Ø Work Status - Application Level
v BPC - BW Related Topics
Ø Data Validation
Ø Back Up & Restore Environment
Ø UJ File Services - To check the BPC Scripting
v MS WORD & POWER POINT
Ø Input Template
Ø Report Template
v CONSOLIDATIONS
Ø Basic Introduction to Consolidation
Ø Models Required for Consolidation
Ø Dimensions required for consolidation
Ø Business Rule Table Maintenance
Ø Global Parameters for Consolidation
Ø Model Level Parameters for Consolidation
v ADVANCED CONSOLIDATION CONCEPTS
Ø Currency Conversion
Ø Balance Carried forward
Ø Inter Company Elimination
Ø Re Classification of Data
Ø Ownership data maintenance - Web Screen
Ø Maintenance of Percentage of ownership data , PCON
Ø Method for Consolidation
Ø Method based Multipliers for Consolidation
v JOURNALS
Ø Journal template - Model Level
Ø Multiple Header Journal
Ø Multiple Value Journals
Ø Re-Opening Of Journal & Parameter Setting
Ø Journal parameter Setting
Ø Balancing Journals - By Amount / Entity / Currency
Ø Journal Reporting
Ø Posting/UnPosting Of Journals
Ø Locking the Journals
Ø BPC Users Maintenance
Ø Teams
Ø Data Access Profile Creation
Ø Assignment of Security to Users/ Teams
Ø Demo on Security - Live Example
v TRANSPORTS
Ø Object Level transport
v PLANNING DEMO
Ø Comprehensive Planning
The SAP certified Application Associate – Business planning and consolidation online certification exam verifies the knowledge in the area of SAP Business Planning and Consolidation 10.1 and 11.0. It validates that the Associate Consultant has a sound knowledge and understanding of SAP Business Planning and Consolidation in SAP Business Planning and Consolidation 10.1, and SAP Business Planning and Consolidation, version for SAP BW/4HANA. (BPC Embedded version 11.0). Based on that knowledge, the successful Associate is able to apply those acquired skills to perform a variety of appropriate implementation, customization and maintenance related tasks within a project team and contribute positively to the success of a project under the guidance of senior project team members.
A typical Associate - SAP Business Planning and Consolidation 10.1/11.0 consultant would have a maximum of three years experience in the field but project experience should not be prerequisite for a competent and well trained candidate to pass this exam.
The SAP BPC online certification course ensures the participants can apply the necessary skills to implement, customize and maintain within a real-time BPC project.
------------------------------------------------------------------------------------------------------------------------------
The SAP BPC online certification course open a wide range of job opportunities owing to SAP BPC module’s planning, management and reporting capabilities. The leading companies globally hire SAP BPC consultants because of the value provided through end-to-end automated planning services available in BPC.
The following are the prominent job titles in SAP BPC area:
· SAP BPC Administrator
· SAP BPC Consultant
· SAP BPC Lead Manager
· SAP BPC Professional
· SAP BPC Associate
An SAP BPC consultant draws an average salary starting from $98,510 to $187,572 per year based on skills, experience and seniority level. Since most of the top organizations have BPC module implemented in order to achieve financial consolidation and streamlining of business processes, as such SAP BPC consultants are in huge demand across the sectors globally.
------------------------------------------------------------------------------------------------------------------------------
Interview Questions
------------------------------------------------------------------------------------------------------------------------------
1. What is the full form of SAP BPC?
SAP Business Planning and Consolidation
2. Explain EPM?
SAP Enterprise Performance Management or EPM enables an organization to accelerate its financial and operational management. SAP EPM supports multi functions related to SAP business planning and consolidation such as budgeting, supply chain management and reporting.
3. List out the two versions of SAP BPC?
· SAP BPC NetWeaver
· SAP BPC MS
4. What are the benefits of using SAP BPC?
· Star schema for efficient reporting
· Compatible with common database and does not depend on specific DB
· BW accelerator support feature to handle large data set
5. What are the advantages of using BPC MS?
The advantages of using BPC MS are:
· Users can create their own rules in BPC system to perform certain functionalities
· Users can perform certain functions to meet some extensive business requirements
6. List out the key components in BPC architecture?
· Requirement – SAP NetWeaver ABAP version 7.3
· Database – SAP NetWeaver version 7.3 and above
· Operating system – Any supportive version of SAP NetWeaver and database engine
7. Define Drill down?
Drill down is used to drill down on data member within dimensions. The user can drill down on data members in a worksheet.
8. What are the available options in Drill Through?
· Hierarchy validation
· BW attribute modification
· Data member updation
9. Explain the steps to process a dimension?
To process a dimension follow the below steps:
· Validate hierarchy
· Update data member within BW
· BW attribute modify run
10. Where the user can make use of the java script?
Conversion file
11. Does NetWeaver support VB script?
No, NetWeaver does not support VB script.
12. Which logic is saved in the database?
Script Logic is saved in the database.
13. What is needed to use dimension member formula?
Formula property is used to make use of dimension member formula.
14. What are the design models available in SAP BPC to meet the business requirements?
· Standard model
· Embedded model
15. What is the benefit of transformation file?
Transformation file is for mapping of fields from BW to BPC and the output is an excel file format.
16. Name different sections in a transformation file?
The three sections available in a transformation file are:
· Options - has general settings
· Mapping - is for assigning dimension in BPC system with the help of source column in BW info object
· Conversion - has the link of other excel sheets to apply conversion
------------------------------------------------------------------------------------------------------------------------------
