SAP BPC 10 Online Training
Pin It

SAP BPC 10 Online Training

bpc SAP BPC 10 Online Training

SAP BPC 10 Online Training

SAP BusinessObjects Planning & Consolidation (BPC) Overview

SAP Business Planning and Consolidation (BPC) is a robust planning awl consolidation application that can ifleet the organisation’s budgeting. planning. consolidation, and reporting requirements.It supports the full array of top-down and bottom-up financial and operational planning needs as well as consolidation processes necessary to ensure the smoothest.

Industry’s first untied and predictive performance management solution that delivers the following core process functionality

  • Strategic planning
  • Budgeting
  • Forecasting
  • Statutory consolidation
  • Reporting & analysis Predictive analytics
  • Scorecarding

A single,unified,Enterprise-wide solution

A web – based,collaborative solution that unifies the business planning and performance management process

Features of SAP BPC

SAP BPC lets you develop your own reports, enabling you to decide how you view your data. Although the data you can view is governed by your security access, you can customize your reports in a fashion that suits your decision-making requirements.

The application also allows you to load data yourself. This has two benefits: First, it removes your dependence on the IT solutions team, and second, it allows you to load data at any time, which in turn provides more control.

SAP BPC supports the creation of business rules that dictate how data is transformed in the application. For example, you can set up business rules for performing currency conversions.

The application also provides out of the box functions for performing planning and consolidation. These functions can be used as-is or in combination with additional business rules to support specific application requirements.

Reporting and analytic’s software in SAP Business Objects Financial Consolidation and SAP Business Objects Planning and Consolidation for Office Provided with:

SAP Business Objects Planning and Consolidation, as central interface Other EPM applications for Finance*, as optional interface Includes:

Enhanced Excel, Word and PowerPoint interfaces for creating live, connected reports from scratch and copying/pasting existing reports between Word, Excel and PowerPoint

Currency translation

This function if your organization has its place of business in more than one country and/or does business in different currencies. Currency trans-lation is used in both planning and financial consolidation applications. The currency translation process allows business users to translate transactions to one or more reporting currencies.

Intercompany elimination

This is applicable for an organization that has entities that do business with each other. A consolidated balance sheet of an organization shows transactions that relate to external companies. The transactions such as sales and COGS or receivables and payables that result from exchange of goods or services within the organization should not be counted. In these cases, it is essential to eliminate the intercompany transactions. The intercompany eliminations process creates entries that eliminate intercompany transactions.


Planning may take place at a high level, and you may later allocate the plan to lower levels. For example, you may need to allocate planned expenses incurred by the corporate office to each of its divisions based on some ratio, perhaps allocating corporate expenses to divisions based on the planned revenues of each division. The logic to perform this allocation is available in SAP BPC.

Account transformation

There are some scenarios where accounts are consolidated or transformed into another account, an activity that is used extensively in cash flow applications. Account transformation business rules are used to aggregate values posted to specific combinations of source Account, Flow, Category, and Data Source and post them to aggregated destination Account, Flow, Category, and Data Source.


The validation rules functionality in SAP BPC is a check mechanism that enables an organization to ensure accuracy of data. For example, using the validation rule table, an organization can set up business rules that would compare balances in assets and liabilities/owner’s equity accounts for a given period and report variances, if any, for that period

Carry forward opening balances

The carry forward of balances is an essential step in the creation of a balance sheet for an organization; it is when the closing balance of accounts for a fiscal period is transferred as the opening balance of a subsequent fiscal period.

Automatic adjustments

The automatic adjustments logic supports the process of generating a consolidated financial statement. The automatic adjustment business rules are used for elimination of inter company transactions and for consolidation of investments

SAP BPC allows you to view and store information in multiple languages. It also includes a feature to augment collaboration by enabling you to enter comments about your data. This provides context information to the data (making it more understandable) and aids in decision-making. For example, you can enter a comment to explain a reduction in overhead expenses from last year to the current year. This is clearly a better solution than storing this information in a different location that may or may not be accessible to the user making the decision.

Another feature of the application, Work Status, allows you to lock data so that it cannot be changed in the application. Using this feature, you can define the range of data that can be modified or locked. For example, if a sales representative creates a sales plan and sends it to his manager for approval, during the approval time frame, the data can be locked from being changed.

SAP BPC also enables the distribution and collection of financial data. The application allows you to send plan information to other people, even people who do not use the application. The recipient can then make modifications to the data, and the changes can be retracted back to the system. This facilitates the exchange of data and truly supports collaboration between and participation of all people involved in fulfilling the organization’s planning objectives.

Another important feature of this application is its easy-to-use programming inter-face, which allows you to create and execute logic that may be used for planning and consolidation. For example, you can develop a script to perform revaluation of a plan by a certain percentage. The application lets you implement logic using a variety of methods to manage the data, and it lets you include logic than can be categorized into three broad areas. We’ll discuss this at length in Chapter 6; for now, we’ll only offer a brief description of each area.

Dimension logic

You configure this via simple mathematic formulas. For example, you could set a formula in the application to subtract the cost of goods sold from the gross sales to obtain the gross profit.

Business rules

You can develop rules to perform a certain function in planning or consolidation. For example, you can define custom business rules for currency translations, intercompany transactions elimination, account transformations, and so on to tailor the application to the needs of the business.

Script logic (or K2 script logic)

You can develop scripts that perform certain functions. This feature is generally used to apply detailed business logic to achieve a specific function, especially when out of the box functionality cannot satisfy the business requirement. The script logic is a fully developed language for this application and can meet any special requirements not available in the standard application. For example, you may require script logic when you want to determine the depreciation of a certain group of assets based on some logic; if the logic is not readily available, you’ll need to create it in SAP BPC.

The application frontend for planning, consolidation, and reporting runs on top of Microsoft Excel, which is widely used by planners and accountants all over the world. This lets you perform planning and consolidation functions in the familiar Excel environment and helps you avoid spending time learning new software. Creating graphical data in Excel provides an intuitive display of the data that can be easily understood, interpreted, and analyzed.

Microsoft Excel versus SAP BPC

Some organizations solely use Excel for planning, but there are many disadvantages to this approach:

Managing Excel spreadsheets

In Excel, planning data is stored in spreadsheets, which can be an issue from a security perspective; the only option to control access is to keep the files on a shared network drive and provide access only to select users. This in turn cre-ates additional work for the IT solutions team. SAP BPC alleviates this issue by storing the data in a database and enforcing security on the data.


SAP BPC allows you to use different charts of accounts for consolidation, enabling you to generate several consolidated financial statements in parallel to accommodate different accounting principles.

You can collect data for consolidation in the NetWeaver version using the follow-ing methods:

  • Online data entry
  • Flexible upload from a data file
  • Loading from an InfoProvider

The application allows you to execute the following tasks:

  • Currency translation
  • Account Transformation
  • Allocation
  • Balance carry forward
  • Intercompany reconciliation (matching)
  • Intercompany booking
  • Intercompany eliminations
  • Consolidation of Investments
  • Validation

Advantages of Performing Consolidation in SAP BPC

  • Legal and management consolidation
      The application provides a systematic process to perform legal consolidation. You can also perform management consolidation using different sets of data to highlight different scenarios for management, as well as parallel consolidations with different categories of data and using different accounting principles.
  • Accuracy
      The design of the application’s system for consolidation enables the consolida-tion process to run in a controlled manner, with the ability to perform checks and balances along the way. This mitigates any errors during the process and ensures the completeness and accuracy of the data.
  • Multiple source systems
      You can compile financial data from various source systems into a single system for the purpose of consolidation.
  • Reporting
      You can generate reports based on consolidated data, which you can then use as a tool for measuring the organization’s performance. The reports allow you to view key metrics such as return on equity, ROI, and so on.
  • Validation of data
      You can analyze different sources of data used to generate the consolidated data to ensure that the data is valid and reliable. You can also reconcile the data in the application with the source system, facilitating reliability.
  • Collaboration
      The application supports the extensive collaboration needed to gather data from multiple sources. This helps with the consolidation of data from diverse sources.
NEW Features of SAP BPC
  • 1. New Look & Feel
      EPM-Add in menu streamlined to be more intuitive to end user New ribbon with set of action buttons for creating reports, managing and formatting reports, action button for save and refresh data, action button for performing planning function, action button for publishing workbooks
  • 2. Improved EPM Suite Integration
  • 3. Simplified Report Creation
  • 4. Enhanced What-If Capabilities
  • 5. Enhanced Member Selector

SAP BPC Course Content:    

                                                        Request a demo button SAP BPC 10 Online Training

 Course Overview

    1. Course Goals
      Course Objectives
  • Unit 1: Concepts and Objects in BPC Administration
      Business Objects – Overview and Advantages of BO PC
      Business Planning and Consolidation – Some Modeling Aspects
      Environment Management
      Dimension Management
      Creating Models
  • Unit 2: SAP EPM 10.0 add-in
      Creating a Planning and Consolidation Connection
  • Unit 3: EPM Client – Microsoft Office Excel
      Create a Report
      Create a Input Form
  • Unit 4: Comments
      Enable Comments
      Input and Retrieve Comments
  • Unit 5: Multi-Reporting and Axis Sharing
      Create a Multi-Reporting Spread Sheet
      Share axis from one report with another report
  • Unit 6: Formatting
      Dynamic formatting
      Link a formatting sheet to one or several reports
      EPM Function to apply formats
  • Unit 7: EPM Cell-based formulas
      EPMAxisOverride Cell-based formula
      EPMDimensionOverride Cell-based formula
      EPMInsertCellsBeforeAfterBlock Cell-based formula
  • Unit 8: Books
      Create a Book Template
      Validate the Book Template
      Publish a book to the Web Library
      View the book in the Book Viewer
  • Unit 9: 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
  • Unit 10: Data Acquisition, Transformation, ECC and BW
      Data Acquisition, Transformations, Packages, and Package Links
  • Unit 11: 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
  • Unit 12: 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
  • Unit 13: 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
      E-Mail notification
  • Unit 14: Crystal Dashboards
      Design a Dashboard and Export it to Flash format in SAP Business Objects dashboard design
      Insert a Flash object into a report
      Publish a Flash objects into the Web
      Creating Crystal Dashboards Using EPM Connector
      Explain Crystal Dashboards functions with BPC Data
      Display the content of a .txt file stored in Content Library
      Input data in BPC from Dashboards
  • Unit 15: Word and Powerpoint Integration
      Explain MS Word Integration with BPC 10.0
      Explain MS PPT Integration with BPC 10.0
  • Unit 16: BPC 7.5 Migration
      How to migrate BPC 7.5 Reports built with former EV Functions
      How to migrate BPC 7.5 EVDRE Reports
  • Unit 17: Others
      Work Status
      Work Spaces
  • BOPC 10.0, NW Consolidation
  • Unit 1: SAP Business Objects Planning and Consolidation Framework
      Environment and Models
      Dimensions, Properties, and Loading Master Data
      Consolidation Logic
  • Unit 2: Data Collection and Preparation
      Transaction Data Collection
      Journal Entries and Balance Carry Forward
      Account Transformation
  • Unit 3: Consolidation Controls
      Execute Controls
      Review Controls
  • Unit 4: Currency Translation
      Currency Translation
  • Unit 5: Ownership Manager
      Setup Master Data to support Ownership Manager Calculations
      Setup Business rule Methods to support Ownership Manager Calculations
      Access the Ownership Manager Web Interface
      Create an Ownership Structure
      Execute Ownership Calculations
  • Unit 6: Consolidation of Investments
      Consolidation of Investment Concepts
      Consolidation of Investments Architecture
  • Unit 7: Inter Company Eliminations
      Inter Company Matching
      Inter Unit Elimination and US Elimination
  • Unit 8: Consolidation Monitor
      Explain Status information displayed in the Monitor
      Describe the running rules
      Describe incremental consolidation

 SAP BPC INTERVIEW Questions and Answers

 Can you debug the data manager package ?

    1. Program: UJD_TEST_PACKAGE .You must specify the User ID .The DM package can be selected with F4 .
  • 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)
  • What are system variables ?
      %USER% – Returns current SAP BusinessObjects 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
  • What is the difference between EVGTS and EVSND
      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: EvSND 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 EvSND 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.
  • What is the difference between DRILLDOWN and DRILLTHROUGH ?
      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.
  • What are the options of DRILL THROUGH?
      Jump to any website Jump to a BW query Jump to ECC tcode
  • what steps are in Processing a dimension?
      Processing a dimension will execute the following steps:
      Validate Hierarchy.
      Validate Dimension member formulas.
      Update member data into BW.
      BW Attribute change run.
  • what fields will be in Distribution Templatae?
      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.
      VARYKEYS: 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 Vary Key.
      You then map a specific Vary Key to a User ID who should receive that report (for example, the Cost Center manager). This way, each user who gets a report has the required dimension(s) set to their individual values
      SECTIONEND: denotes the end of a section.