- Allows for tracking of actual vs budgeted expenses. Can have multiple budgets or forecasts for comparison.
- Can create reports that can be modified to show either department or office views of the data.
- Allows for budgeting of production hours, billed hours and collections by individual timekeeper.
- Data is not easily moved between modules. Several steps necessary to accomplish this.
- Users often overwrite data entered by others. Need better controls for this.
- Better reporting of changes between versions of a budget. In particular, the user who made the changes and what those changes were.
- SAP should focus on delivering one single product for planning, consolidation and budgeting needs rather than providing a large list of options to choose from.
- The product is not very user-friendly compared to other cloud competitors. There is a heavy dependency on IT teams.
- SAP BPC should come up a pure cloud option.
SAP BPC is less appropriate for organizations using Agile methodology. It is not suitable for organizations in a hyper-growth cycle as the installation and implementation is time-consuming. It will not work for organizations where the planning and budgeting needs keep changing frequently. The UI of SAP BPC is not very intuitive and very difficult to set up a dynamic dashboard for senior executives and officials of CxO.
- Running ad-hoc reports
- Researching on variance explanations
- Creating standardized reports across the team
- It'll be helpful to make the ID/description selection change a stand-alone button in the ribbon
- Add back the option to select and copy ID's from the dimension dropdown
- SAP BPC is real time data. You can send information into the system and see it reflected in your reports immediately. Other systems may require a manual push into a reporting system.
- SAP BPC is a shared reporting tool, so multiple users can be working in a model/environment at the same time, real time. This is especially helpful if your workbooks incorporated multiple processes requiring multiple users to get into the same model.
- SAP BPC is a powerful tool designed to help all facets of the company, from cash flow to capital expenditures to headcount management to financial planning to consolidation.
- An easily accessible resource page for quick how-to's and tips, as well as things to avoid (maybe a YouTube page).
- In 10.1, one thing that was removed was the ability to go into the dimension and select multiple members/parents and copy-paste those into your workbook. Please bring this back.
- When I have a BPC workbook open and a non-BPC workbook open, it slows down performance because whenever I'm toggling between the two workbooks as it's constantly bringing in the EPM context pane into the non-BPC workbook. Is there any way to disable this easily?
SAP BPC (Business Planning and Consolidation): "SAP BPC reviewed by a heavy user, but that is new to financial systems"
- Allows for full integration of data to be analyzed in real time. Although we still load actuals on a delayed basis (2 business days after month end), when developing the budget, we not longer have to do a full loading process from a different application into BPC prior to being able to report and analyze the current budget status to prior budget versions or actuals.
- It is easy to learn basic report building. The hardest part is learning the available dimensions and the different possible combinations and their results, but that will also vary from company to company depending on the complexity of the industry.
- Being from a law firm, the system needed a lot of custom tailoring in order to fit our full needs (although many companies could say the same thing). Although the ability to highly customize the system to the company's needs is a positive, it frequently results in the system responding in unexplainable and unrepeatable ways which negatively impacts and slows the budget process. Because of the sporadic nature and variety of the issues, we are unable to repeat them on cue and therefore cannot nail down a solution.
SAP BPC (Business Planning and Consolidation) Review: "Fine if you are already in the SAP ecosystem, otherwise steer clear"
- Dimensional model allows for slicing and dicing of the data in a variety of ways
- This is a custom tool - it provides an environment but you define what the structures look like, which offers flexibility
- Updates are not backward compatible - on the server side they require complete reinstalls.
- While they suggest the tool is unlimited, in practice, there are substantial performance limitations on the Microsoft Platform if you let the cube get too large
- The Microsoft platform is legacy from the original tool (Outlooksoft) that SAP purchased. The result is that it gets the least effort in development
- If you aren't using SAP Business Warehouse, the load process is considerably more complex than it otherwise might be.
At the World Bank Group (WBG), SAP Business Planning and Consolidation (BPC) is used as a corporate performance management system to enable financial planning and management and to support the budget processes across IBRD, IFC, and MIGA.
- BPC acts as the single source for all budget, revenues, expenses, forecast plans and eliminates the need for budget monitoring staff to maintain their own spreadsheets and legacy systems.
- Results in substantial time and cost savings due to the reduction of manual errors and data redundancy, enhanced data quality, and data governance, and an expedited planning and monitoring cycle for unit level and corporate planners.
- EPM Menu can be simplified.
- Compatibility issues with MS Office 365 need to be resolved.
- Single sign on needs to be implemented.
At The World Bank Group, the implementation of BPC has enabled resource managers, budget planners, HR business partners, and activity planners across the institution to plan for budgets and expenses related to staffing/fixed costs, revenues and expenses across all sources of funds, work program allocations, capital investments, and project-based activity costing, etc.
The BPC system allows senior management to communicate budget ceilings and thresholds for top-down planning while automating real-time aggregation and consolidation of bottom-up plans for consumption by corporate budget units to perform variance analysis.
- Accounting and finance users love this tool because reports are built using native Excel. If commands such as EPMCopyRange are utilized it can further the use of native Excel.
- Compared to BPC 7.5 our elimination and consolidation logic runs in a fraction of the time. Processes that would take multiple days can be accomplished within hours.
- Powerful and dynamic reports can be built to help business leaders make decisions and see trends.
- There is missing functionality on the ability to use the dynamic filter on apply a property when using the excluded members tab of the report editor. We are currently running SP30 BPC 10.1 and the ability existed in previous service packs. We now have to manually exclude some dimensions. We use member exclusions on our income statement tabs to help clean up the multiple total lines that appear when having two dimensions in the row running on member and descendants.
- In SP 30 and some of the later BPC 10.1 service packs, when a user searches for a dimension member, it displays the dimension member the number of times it shows up in another hierarchy. In previous service packs, when searching for a dimension, it would display the dimension member within the first hierarchy it appears in and then if the user clicked next, it would jump down to show the dimension member within the next hierarchy it is a part of.
- BPC is not able to handle to calculated member formulas in a report. For example, if a calculated profit center and a calculated datasource are used in a column of the report, BPC is not able to correctly compile and display the correct value for both calculated members.
We use BPC for our planning and consolidated financial reports and [we are also] using it for reporting purpose. The biggest challenge is the data integration between the SAP system ECC, BW, and BPC. It's not real-time processing due to the data flow.
If it were a real-time data flow then it would be very useful for all kinds of reporting needs.
- Always - it's very useful at a reporting level.
- Integrated planning is required and consolidation is required from ECC to BPC.
SAP BPC (Business Planning and Consolidation) Review: "SAP Business Planning and Consolidation is worth every cent!"
- Automation of financial processes using a systematic solution.
- User-friendly Excel Interface to allow for various reporting requirements.
- Data Integration with your current SAP ERP solution.
- The new 10.1 web interface is a little slow when trying to manage a lot of dimensions compared to previous 10.0 web interface.
- Training tutorials or application demos for various levels of user engagement.
- Business process flows are really nice to have to organize the flow of a process, but they are more of a maintenance than a help.
- Pushes data from one model to another. This is helpful to have detail in one model, and summary level in another model.
- Reporting flexibility using formatting, filtering and attributes is good. This offers flexible reporting and input templates by selectively choosing which data sets are relevant to the user.
- Scripting language isn't very robust...it is a proprietary language that isn't as capable as VBA or other languages. Sometime ABAP code is needed to supplement the business requirement.
- Web Templates don't have the same features as the Excel Ad-in. The use of filters and dimension over-rides don't exist.
SAP BPC (Business Planning and Consolidation) Review: "Kinross Advanced Reporting System (KARS) aka SAP-BPC"
Used to consolidate actuals and budget for +/- 250 legal entities for quarterly external reporting and monthly internal management reporting.
- Timeliness of close process i.e. ledgers are closed on work day 5 and consolidated financial statements are issued on work day 10 (non-quarter end months) and work day 15 (quarter end months).
- Consolidation completes in 12 minutes across 5 entity hierarchies.
- The Excel front-end report writer is very user friendly so users are able to create adhoc analysis reports quickly.
- From an administration point of view populating the 'Ownership' model is laborious across 5 Entity hierarchies and setting up data access profiles in Security is also tedious i.e. Security interface needs improvement.
- Investment elimination
- Fully automated cash flow
- Gold equivalent ratio by month, quarter & YTD
- Conversion of Imperial measurements to metric
- Fx translation
- Budgeting & forecasting
- Proportionate sub-consolidations
- Custom BADIs help with complex forecasting calculations
- EPM Excel add-in enables the use of complex Excel functions with EPM features
- Non BPC users have problem accessing BPC spreadsheets, offline feature does not work well.
- The Excel EPM functions are really good
- BPF functionality with a step by step guidance is a plus
- Intercompany Eliminations within BPC engine is very straightforward and easy to setup
- When a change is needed in the EPM reports it is not very flexible and needs IT intervention
- Performance sometimes is an issue when consolidating more then 20 entities specially at quarter end
- Script logic complex to handle and always needs BPC consultant when changes are requiered even if minimal - has very high costs
- Use of data sources allows easy identification of data origin. Ex: ECC, manual entry, management adjustment entry, ICC elimination, etc...
- Reporting is generally fast if best practices are used to avoid performance hits.
- There are a lot of BPC experts available to implement and provide training.
- BPC out of the box is a blank slate and requires system development to be implemented. Generally will need to hire consultants to build and train your organization.
- Many people are not familiar with multidimensional databases like BPC so there is a learning curve.
- SAP BPC leverages Microsoft Excel well and provides an user interface that is easy to use for finance.
- SAP BPC integrates with our SAP R/3 to provide a holistic look at our project level data.
- SAP BPC provides flexibility that is needed in the A&D industry. We are able to customize functionalities for our business needs.
- I'd like to see BPC better handle large volumes of data. Our company plans at the contract level and often find ourselves struggling with data volume in terms of system performance.
- I'd like to see BPC have real-time data from our SAP R/3 system to facilitate a faster closing at month-end.
SAP BPC is well suited for companies with a large user base. Since BPC has a relatively familiar and easy user interface, it can be implemented across a large user group fairly quickly. The user interface is intuitive which facilitates an easier planning cycle.
Aerospace/Defense companies may need to customize SAP BPC to meet their business and customer needs. It would be ideal if SAP released a version of BPC specifically tailored towards the A&D industry.
- Real time consolidation
- One Source of truth for Plan and Actual
- Powerful Predictive Analytics capabilities
- Multiple Architecture Solutions available for BPC could end up with wrong selection of the tool that may not be appropriate for the organization
- Need to procure additional software to compliment BPC (SAP Analytics for Cloud), the cost associated with additional license requirements
- Maturity and stability of the latest version
More appropriate when you have multiple ERP Systems
Also, for large companies who are acquiring new companies, easy way to get consolidated results of newly acquired companies in BPC
Organizations using single ERP and do not have complex product line verticals and large geographical presence
SAP BPC (Business Planning and Consolidation) Review: "BPC for Financial Forecasting and Consolidations"
- BPC has an Excel front end, which makes it especially friendly for Finance teams who like to work primarily in spreadsheets.
- BPC reporting in Excel is easy to learn and it is fast to execute ad hoc reports that pull updated values directly from the database. With minimal training, users can learn how to create and maintain their own reports which can quickly match up and compare forecast and actual values.
- BPC allows you to use the same system for both actual consolidations and the financial forecast process. This enables users to quickly combine forecast and actual values timely. It is not necessary to wait for transfers of data to/from other systems to combine forecast and actual values in the same report.
- BPC should come standard with web functionality that enables the same functionality as the EPM formulas.
- BPC script logic should run faster for logic which has to reference member properties. When script logic has such programming, it often runs slow as it goes through the dimension information.
Less Appropriate -- Resource Planning that meets the needs of both Finance for the financial forecast but also meets the needs of project planners which are trying to plan resources over the life of a project. It is difficult to meet the needs of both groups with BPC in a way that allows for resource actuals and the outlook to be combined.
SAP BPC (Business Planning and Consolidation) Review: "Working with Business Planning and Consolidation"
Business Planning and Consolidation helps to plan / outlook across the organization and thus helps the corporate finance team to quickly get the planning number for analysis and any potential corrective action.
- Easy to use for business users.
- Less need for involvement of IT
- Quickly setup master data and transaction data to simulate any ad-hoc scenario
- Single version of the truth enable fast, accurate management and statutory reporting.
- Web interface (reports and input forms) have limited functionality
- Difficult to maintain large dimensions
- For database reads or complex logic, script logic may not be best and need to do ABAP coding
BPC for NetWeaver is more appropriate for ECC as a source system, so that master and transaction data loads can be automated.
BPC for NetWeaver may not be appropriate for non-SAP source. As automation of master data and transaction data may not be possible.
Security profiles and design
SAP BPC (Business Planning and Consolidation) Scorecard Summary
Feature Scorecard Summary
About SAP BPC (Business Planning and Consolidation)
SAP BPC (Business Planning and Consolidation) Screenshots
SAP BPC (Business Planning and Consolidation) Integrations
SAP BPC (Business Planning and Consolidation) Competitors
SAP BPC (Business Planning and Consolidation) Support Options
|Free Version||Paid Version|
|Video Tutorials / Webinar|
SAP BPC (Business Planning and Consolidation) Technical Details
|Operating Systems:||Windows, Mac|