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
- Statutory consolidation
- Reporting & analysis Predictive analytics
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
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.
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.
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.
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.
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.
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
- Balance carry forward
- Intercompany reconciliation (matching)
- Intercompany booking
- Intercompany eliminations
- Consolidation of Investments
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.
- 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.
- 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.
- 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:
- 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 ?
- 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.