SAP BPC (Business Planning and Consolidation)Learn about Business Forecasting, Planning, Analytical Reporting and Analysis.
Preview SAP BPC (Business Planning and Consolidation) courseView Course Curriculum Price Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate
- 54% Started a new career
BUY THIS COURSE (
USD 17 USD 41)
- 86% Got a pay increase and promotion
Students also bought -
- SAP BPC (basic to advanced)
- 30 Hours
- USD 17
- 199 Learners
- SAP BPC (comprehensive)
- 20 Hours
- GBP 12
- 116 Learners
- SAP BPC Classic
- 40 Hours
- USD 17
- 1720 Learners
SAP Business Planning and Consolidation (BPC) is an important SAP module that helps an organization to run a business successfully through strategic planning, budgeting, reporting, forecasting, financial consolidation.
With SAP BPC you can easily adjust plans and forecasts, speed up budget and closing cycles, and ensure compliance with financial reporting standards. SAP BPC allows you to eliminate the need for multiple planning solutions to help you adapt to dynamic economic conditions and keep pace with the speed of business.
SAP BPC provides a single view of financial & operational data and acts as a unified solution which supports performance management processes. SAP BPC module forms the basis for legal and management consolidations by providing a highly scalable, robust database combined with business process and logic capabilities to form a true Enterprise Performance Management (EPM) platform.
SAP BPC is an integrated solution for an organization that meets their bottom-up and top-down financial and operational planning requirements coupled with forecasting and reporting capabilities. SAP BPC's user interface is tightly integrated with the MS Office suite. Like any other SAP module, BPC module too holds master and transaction data. SAP BPC is divided into two components namely "Administration" and "Reporting".
Key features of SAP BPC module include:
1. In order to run a business successfully for an organization it required to have the important attributes such as financial planning, budgeting and forecasting. SAP BPC provide all these attributes in a single package
2. It offers you a unified planning and consolidation in one product
3. SAP BPC helps to define the financial goal and operational plans with strategic objectives
4. SAP BPC helps to reduce the budget cycle time
5. SAP BPC helps Business users to manage processes, models & reports with little IT dependence
This SAP BPC training by Uplatz provides a comprehensive view of various configuration and implementation steps involved in SAP BPC module and will help you prepare for SAP BPC certification and job interviews.
Course/Topic - SAP BPC course - all lectures
In this lecture session of BPC Terminology and the Objects we learn about technologies of BPC.
In this lecture session we talk about Bi Terminology and Data flow, a basic example of Data flow.
In this lecture session we learn about presentation layer, application layer and database layer and also talk about standard Environment.
In this lecture session we learn about Audit functionality and also talk about different types of audit functionality.
In this lecture we learn about balance carry forward and also cover business rules of BPC.
In this lecture session we learn about session number, report workbook and workbook description.
In this lecture session of BPC Security we learn about how to set up BPC security and also cover the importance of BPC security.
In this lecture session of BPC we learn about consolidation of investment. We also cover all functions of consolidation of investment.
In this session we learn about business planning and consolidation and different types of hierarchy.
In this session of SAP BPC we talk about proportional methods and also cover different types of methods of SAP.
In this lecture session we learn about SAP BPC copy and clear function we also talk about different types of functions in SAP BPC.
In this lecture session we learn about currency Translation and legal consolidation and also talk about the basic model of currency translation.
In this lecture session of SAP BPC we talk about legal consolidation and also talk about logic script of legal consolidation.
In this lecture session we give you an overview of EPM. What is EPM and how EPM works in SAP BPC.
In this session we learn about EPM functions and also cover different types of functions present in SAP EPM.
In this lecture session we learn about EPM user and EPM server and also cover all the techniques of EPM.
In this lecture session of SAP BPC we talk about Journal consolidation central and also cover functions of consolidation central.
In this lecture session we learn about logics. We also talk about member formulas and also cover all types of formulas that are present in logics.
In this lecture session we learn about Logics scripts. We also talk about parts of logics script and all properties of logics script.
In this lecture session we learn about member offset and also cover basic examples of member offset in EMP.
In this lecture session we learn about variables in logic script and also cover different types of variables in Logic script.
In this lecture session we talk about allocation and lookup and also talk about multi model scripting.
In this lecture session we learn about master data load and also cover if we load the master data from BI info object.
In this lecture session we learn how to create transformation files for field to field mapping and validation of conversion files.
In this lecture session we talk about master data load via Bi Info object and also cover all the techniques of master data load.
In this lecture session we learn how we submit the data by using an input form and also cover how the input form looks like.
In this lecture session we learn about transaction of data load from Bi infoprovider and logic script.
In this lecture session we talk about how to create a cash flow statement where the amount of several accounts is copied.
In this lecture session of SAP BPC we talk about how to create a report. We also cover different types of methods of creating reports.
In this lecture session we learn how to check the work status and we also cover the features of work status.
Once you finish your planning and consolidation the finalized data prevents any further changes. We also cover how to maintain work status.
• Business Forecasting
• Analytical Reporting and Analysis
• Budget Planning
• Predictive Analysis and Recommendations
• Improve Compliance
• Business Process Flows and Smooth Collaboration
· 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
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
LOGIC - BPC
· Script Logic Online Execution
· Script Logic Central Execution
· Default Logic
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
BPC - WEB
· Business Process Flows
· Data Audit configuration & Reports
· Activity Audit Configuration
LOCKING OF DATA & AUTHORISATION PROCESS
· Work Status - Environment Level
· Live Demo on Data Entry by user & Locking of Data Manager
· Work Status - Application Level
BPC - BW Related Topics
· Data Validation
· Back-Up & Restore Environment
· UJ File Services - To check the BPC Scripting
MS WORD & POWERPOINT
· Input Template
· Report Template
· 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
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
· 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
· Tasks Profile Creation
· Data Access Profile Creation
· Assignment of Security to Users/ Teams
· Demo on Security - Live Example
· Object Level transport
· Comprehensive Planning
This SAP BPC training course is designed for helping ou clear the SAP Certified Application Associate-SAP Business Planning and Consolidation 10.1 and 11.0 exam. The SAP BPC course content connects with business planning application which is used in many companies.
In SAP BPC Course module the participants can learn to explore the SAP Business planning and consolidation application. In the SAP BO course, the participants will learn about business planning, budgeting, forecasting and cloud deployment. This seems to be an essential learning for all SAP BPC module users.
The SAP BPC Certification is an important benchmark in becoming an expert BPC Consultant as the course covers business rules, architecture, process control. And much more. SAP BPC tutorial helps the participants to learn all the key components of SAP BPC tool thus attaining a unique SAP certification. SAP BPC course offers complete information about SAP BPC application thus making the participant an expert SAP BPC Consultant.
Uplatz online training guarantees the participants to successfully go through the SAP BPC certification provided by SAP. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.
Course Completion Certificate will be awarded by Uplatz upon the succcessful completion of the SAP BPC course training.
The SAP BPC certification exam verifies that the participants possess basic knowledge and can prove their skills in the area of SAP Business objects planning and consolidation. This SAP BPC certification exam validates that the participant has an overall understanding about this consultant profile, and able to implement the knowledge practically in projects.
Below given are the certification details of SAP Certified Application Associate - SAP Business Planning and Consolidation 10.1 and 11.0 exam -
· Certification Level: Associate
· Exam Name: SAP Certified Application Associate-SAP Business Planning and Consolidation 10.1 and 11.0
· Exam Code: C_EPMBPC_11
· Exam Mode: Online
· Total Number of Questions: 80
· Pass Score: 60%
· Time Duration: 180 Minutes
· Exam Price: $550
The SAP BPC Consultant draws an average salary of $103,974 per year depending on the knowledge and hands-on experience. The SAP BPC Consultant job roles are in high demand and make a rewarding career.
The SAP BPC Consultants are recognized across the globe. The increased usage of the SAP Analytics cloud in many companies help the participants to find a job opportunity easily. The leading companies hire SAP BPC Consultant considering the skill of mastering budgeting, forecasting and finance consolidation ability in an organization.
The learners earn most beneficial SAP BPC certification through our expert training and course curriculum. Being SAP BPC certified is definitely valuable credential and adds value to every organization.
The SAP BPC certification is targeted to those participants who are from finance or business background and want to excel as SAP BPC consultant.
The following are the job titles:
· SAP BPC Expert
· SAP BPC Associate
· Finance Consultant
· BPC Finance Consultant
· SAP Finance Consultant/Analyst
The SAP BPC online course provides you a solid footing to help you explore and materialize the career opportunities as SAP BPC Consultant or End User.
#1. What is BPC?
Ans. BPC stands for Business Planning and Consolidation. BPC is used for both Planning and Consolidations, unlike IP, which is used for only planning.
#2. When BPC 7.5 NW is available?
Ans. The 7.5 version is currently in the ramp-up stage and should be available in a few months. I am not sure of the exact month.
#3. What are the two versions available for SAP BPC?
· SAP BPC NetWeaver
· BPC MS
#4. BPC for NW has an aggregation level or not, Is BPC an application on top of SAP-IP?
Ans. BPC and IP have completely different architecture. BPC doesn’t use aggregation levels or filters. BPC and IP have no relation and thus, cannot be compared. BPC uses various script logics, business rules for doing the planning. Manual planning can be done with input schedules. The input schedules are on excel platform and are quite versatile. You can use BPC functionalities along with native excel functionalities for better design of the input schedules.
#5. What about BPC in the consolidation part?
Ans. BPC comes with pre-delivered components for consolidation, which can be leveraged on. There are a few business rules, which make the consolidation process easier.
#6. What is the concept of plan data from BPC?
Ans. The concept of planning is the same as you have in any other tool. The functional side of the planning remains the same. However, the tool differs. The way you configure a planning scenario will be much different than any other planning tool. Unfortunately, it will not be feasible to address this in the forum. You can definitely go through the study materials for a better understanding.
#7. BPC for NW needs to install .NET application server and Web server or not?
Ans. Yes, You can have a look at the installation guide available on the marketplace for detailed requirements.
#8. What are the key benefits of using SAP BPC with NetWeaver?
Star Schema for Exceptional Reporting − SAP BPC uses NW InfoCubes to store the data. The dimension model used is extended Star Schema so it makes BPC with the NW system an exceptional system for reporting.
No Database Dependence Version − BPC NW version is not dependent on database version and can run common databases like DB2, Oracle, SQL Server, etc.
BW Accelerator Support − SAP NetWeaver BW accelerator tool is an additional feature that can be used to enhance the performance of reporting in the system even if you are using large datasets. It indirectly helps in saving the cost for a company as less number of report performance issues are reported.
Badi Development and ABAP Support − SAP BPC with NetWeaver allows you to use ABAP programming to develop K2 script logic. It enables to create business add-in BAdi interface in the back-end system, which can be called later from script logic developed in BPC system. It helps in solving the complex business requirements and reducing the development time for an organization.
#9. What is the BPC client tool? And If I planning on the BEx report, I have to create an aggregation level for planning data or not?
Ans. BPC client sits on the client machines, from where; you will be doing the design. There are mainly 3 interfaces available - BPC Admin, BPC Office, and BPC Web. BPC Office, in turn, has 3 interfaces - Excel, Word, PowerPoint. These interfaces can be used for various requirements.
#10. Can you debug the data manager package?
Ans. UJD_TEST_PACKAGE.You must specify the USER ID. The DM package can be selected with F4.
#11. What are scoping commands?
The following keywords can be used to modify the scope: *XDIM_MEMBERSET Overwrites the scope for that dimension *XDIM_ADDMEMBERSET Add members to the scope of that dimension *XDIM_FILTER Filters the members of the scope of that dimension *XDIM_MAXMEMBERS Specifies the maximum number of members that should be included in one query (per dimension)
#12. What are the key advantages of using BPC MS?
Dimension Logic − This can be configured in the BPC system using simple mathematical formulas.
Business Rules − This allows you to create rules in BPC system to perform specific functions.
K2 Script Logic − This is used to perform some specific functions which can’t be achieved using out-of-box functionality to meet the business requirements. You can create K2 script logics to perform certain functions, which can be performed in a standard system.
#13. What are the system variables?
Ans. %USER% - Returns current SAP Business Objects Planning and Consolidation User %APPSET% - Returns current SAP BusinessObjects Planning and Consolidation AppSet (Application Set) %APPLICATION% - Returns current SAP BusinessObjects Planning and Consolidation Application %YEAR% - Returns current calendar year.
#14. What is the difference between EVGTS and EVANS?
Ans. EVGTS: The EVGTS (Get value and scale) function retrieves a data value based on the specified members, and scales the value if the scale property is enabled on the dimension. The report templates provided in the sample application set have a scale reference in the Control Panel area of the template.
EVSND: EVANS This Send function references another cell and sends its value to the database when you select Send and Refresh Schedules. The parameters specify the dimensions that identify where the data value is to be sent in the database. EVSND returns the value from the database to the referenced cell. You do not need to add any EVGET functions to the sheet to return values to the cell. Since the values are returned to the referenced cell, BPC sends only the cells that have changed since the last send in the current session. By putting the formula in the EVANS cell and not in the input cells, you decrease the chances of your formulas getting overwritten or erased. To further protect the formulas, you may want to hide the EVSND cells in the input schedule. This function takes members that not specified from the current view settings.
#15. What is the difference between DRILLDOWN and DRILL THROUGH?
Ans. Drill down is different than drill through. Drill down is used to drill down on member data within dimensions. You can drill down on members in a worksheet, or you can drill down on charts and graphs. Drill down is conducted within one report in the Excel interface whereas drill through is a 'jump' outside of the Excel Interface.
#16. What are the options of DRILL THROUGH?
Ans. Jump to any website Jump to a BW query Jump to ECC code.
#17. What steps are in processing a dimension?
Ans. Processing a dimension will execute the following steps:
· Validate Hierarchy.
· Validate Dimension member formulas.
· Update member data into BW.
· BW Attribute change run.
#18. What fields will be in the Distribution Template?
Ans. A Distribution Template may contain the following fields:
· BOOK: the title of your distributed book.
· SECTION: denotes the beginning of a section.
· REPNAME: report filename, location and title (can also be for Input Schedules).
· FIXKEY: sets dimension members to the fixed values when generating the report. For example, you can ensure that a report runs for 2008.TOTAL and ACTUAL.
· VARKEYS: lists the dimensions and dimension members that should vary for each report that will get created.
For example, if you want to create a new offline report for each Entity/Cost Center/etc, you would specify that dimension as a Very Key.
#19. What are the key components in BPC architecture?
Requirement − SAP NetWeaver ABAP 7.3 or 7.31
Database − Any of the above versions of SAP NetWeaver support.
Operating System − Any supported version of the SAP NetWeaver system and database engine.
#20. Which databases are supported by SAP BPC with the NetWeaver version?
Ans. This layer is responsible to store all the data in the database. SAP NW back-end system is responsible to create objects and data stored for BPC system. NetWeaver supports most of the databases like SQL Server, DB2, Oracle, and many more.
#21. What is the Model in SAP BPC?
Ans. To meet the Business Planning and Consolidation requirement of an organization, you need to build a model in an environment, which is defined as a collection of several dimensions.
#22. What is the use of Logic Scripts in SAP BPC?
Ans. Logic Scripts is defined as a set of SQL or MDX programming structures to perform some customized functions for flexibility and manage data models. When some specific requirements are not achieved using business rules, those can be met by the use of Logic Scripts.
#23. While creating a legal consolidation application, which of the dimensions needs to be created in BPC?
C_Acct (A) − For maintaining charts of account.
C_Category (C) − To define the category.
Groups (R) − Like GROUP A (USD), GROUP B (EUR), and GROUP C (RMB).
Entity (E) − It contains the business unit used to derive the process.
C_Datasrc (D) − Data Source Dimension.
IntCo (I) − It determines the level of the entity hierarchy at which level the elimination needs to be performed.
Time (T) − Time in all dimensions.
Flow (S) − To keep track of movements in Consolidation.
#24. What is the use of dimension - R_Acct (A), while creating a Rate Application in BPC?
Ans. R_Acct (A) is used for maintaining different types of Rate.
#25. Which design models are available in SAP BPC to fulfill the business requirements?
· Standard Model
· Embedded Model
#26. How the Standard model is different from the Embedded BPC design model?
Ans. Embedded model is different from the Standard model and includes data access to all community users. For the Embedded design model, initial versions used were SAP BW Integrated Planning and Planning Application Kit i.e. BW-IP and PAK.
In the Standard Model, the BPC environment contains the BPC applications or models and each model generates a BW InfoCube which is hidden.
#27. What is the use of the Transformation file? What are the different sections in a Transformation file?
Ans. Transformation file provides the mapping of fields from BW to BPC and is an excel file in BPC. It contains transaction data from InfoObjects in BW with BPC dimensions defined in the administration console.
There are three sections defined for mapping file −
Options − Contains the general settings.
Mapping − Used to assign dimension in BPC system with a source column in BW InfoObject.
Conversion − Contains the link of other Excel sheets to apply the conversion routine.
#28. What is the use of a conversion file? Name different sections in a conversion file?
Ans. A conversion file is used to apply the conversion rules for the BPC dimension and is an Excel file. It contains three sections −
- External − Contains the value from an external source.
- Internal − Contains the value it should be having for the BPC dimension.
- Formula − Defines the conversion formula applied to each record.
#29. What are the different methods that can be used to create reports and input schedules in Business Planning and Consolidation?
· Using Default Templates
· EvDRE Builder
· Drag and Drop Interface
· Blank workbook
#30. Have you used any default templates in BPC for reporting purposes? Name a few of the default templates?
totals by Account
This custom report contains an Account dimension with subtotals in rows and any dimension across in columns.
This custom report contains any dimension in rows and categories comparison in columns. It also features Variances calculation (both amount and percentage). With both YTD and Periodic boxes.
This custom report contains any dimension in rows and Entity type members across in columns with hierarchy.
This custom report contains any dimension in rows and categories comparison in columns and also retrieves the Last Year same period data. With both YTD and Periodic boxes.
Comparison with 3 -year
Year over Year comparison.
Drill in Place
This template performs drill in place.
This allows any two-dimension to be nested in a row and the third dimension in the column.
Sort on value
This template performs the sort of total value.
This allows using the drill in one dimension to others.
#31. How can you migrate EvDRE reports created by BPC 7.5 Excel to BPC 10.0?
Ans. Go to EPM Ribbon → More → EvDRE Migration.
#32. What is the syntax for Dimension logic? Which operators can be used in Dimension logic?
Ans. To define the member dimension formula, you have to put a Square bracket around the dimension and there is dot between two.
[PRODUCT].[PRODUCT1] – [PRODUCT].[PRODUCT2]
[SALES].[SALES1] / [SALES].[SALES2]
Standard Arithmetic functions have to be used in dimension formula - addition (+), subtraction (-), multiplication (*), division (/) - are used in SAP NetWeaver.
#33. What are the requirements to perform simple currency conversions and complex currency conversions?
· There should be a Rate application where you store the exchange rates.
· You should have an account dimension, which includes RATETYPE.
· Entity dimension should include a property CURRENCY.
· FXTRANS logic should be available and DEFAULT logic should include a call to FXTRANS logic.
· Entity dimension should include the property TRANSALATE_TO.
· There should be a Rate application where you store the exchange rates.
· Application should contain a CURRENCY type dimension.
· There should be property REPORTING for the CURRENCY dimension.
· Entity dimension must include the property CURRENCY.
· Account dimension must include property RATETYPE.
· FXTRANS logic should be available.
· DEFAULT logic should include a call to FXTRANS logic.
#34. What is the use of work status? What are the key attributes in defining work status?
Work status is used to lock a region of data in a model. This is used to override the user’s member access privilege to write to a particular region.
There are multiple dimensions defined for a region with one property called as OWNER. While defining the work status, the following are defined −
Work States − It belongs to the physical state of data.
Security − You can set different levels of security on changing data in the system –All or Locked. You can set who can change the work state − Manager or Owner.
Data Update − This defines how data will be updated by the customer.
Push − This option is used to push the same work state for all the children of a member.
#35. How is auditing done in SAP BPC? What are the different audit reports that can be pulled for audit purposes?
Ans. Audit functions allow you to create reports that contain a history of user sessions and system information.
You can create Audit reports on the following topics −
Business Process Flows − You can create these reports in BPF.
Security − You can create these reports in Security.
· Task Profiles
· Data Access Profiles
General − You can create these reports in general.
· Work Status
· Administration Activities
· Data Changes
#36. What are the two sections in Custom Menu Template?
Ans. Custom menu content is defined by two sections in the custom menu template - Default section and Menu item section.
#37. Explain the parameters that can be used with the Custom Menu Template?
Value is True − It opens the custom menu in Excel interface. Value is False − It opens the custom menu in Standard Excel.
If Value is True − It will hide the Planning and Consolidation Toolbar. If Value is False − It will display the Planning and Consolidation Toolbar.
It is used to define the dimensions that have to be displayed on the top of the custom menu page. These dimensions can be changed into the report mentioned in the Custom menu.
Menu Item section includes the following parameters −
- Menu Item − Text description that the user can select for the menu item.
- Actions − Highlight, custom menu function or menu command.
- Level − Level can be selected from section, item or sub-item.
- Parameters − For custom menu functions.
- Normal Screen − Default is a full screen. This is set to true, open custom menu on the normal screen.
- CV Override − This is used to change current view dimensions while switching applications
#38. What is the difference between Reporting Model and Driver and Rate Model?
Ans. We use reporting models for analysis purposes. Non Reporting modules include Driver and Rates model and are used for currency rates, price, ownership data, etc.
Types of Reporting Models −
Types of Non-Reporting Models −
#39. To perform intercompany elimination, which dimensions should be defined and what properties should be created for these dimensions?
Ans. To perform currency conversion and intercompany eliminations, you need a dimension type - Intercompany dimension (I). To execute intercompany elimination, an application should have the following −
- Dimension Type “I” for intercompany elimination.
- Dimension “I” should include a property ENTITY.
- The account dimension should include property ELIMACC.
- The entity dimension should include property ELIM.
- You should set the appropriate business tables.
- There should be a DPT package to execute intercompany logic that should be available.
It contains ‘Y’ or blank
Entity Id w.r.t Intercompany member
‘Y’ or blank