Not your Grandmother's Spreadsheet
Updated September 02, 2021
Not your Grandmother's Spreadsheet
Score 8 out of 10
Vetted Review
Verified User
Software Version
SAP NetWeaver Edition
Overall Satisfaction with SAP BPC (Business Planning and Consolidation)
SAP BPC (Business Planning and Consolidation) is being used as part of a larger project integrating several different databases. The end goal is to get the data from some proprietary systems into a format that will line up with SAP and allow timely forecasts and accurate reporting of past sales, billing, etc. It's a useful tool for this type of consolidation, especially when the end goal is SAP.
- Integrates with Excel.
- Has APIs that can connect to all different types of databases.
- Cube architecture allows for very big data
- The refresh time for our spreadsheets is maddeningly slow.
- It is not an intuitive product. I had to be taught how to unhide a tab in Excel because it doesn't let you unhide in the traditional way.
- It's very easy to wipe out mountains of data with a few keystrokes. There's no "undo" feature for this. I haven't done it, but others have. The data is backed up elsewhere, but you still have to reimport it and clean it up.
- Allows us to see into the future across a myriad of diverse databases.
- Allows us to report financial data from a number of sources.
The main advantage SAP BPC (Business Planning and Consolidation) has over Tableau, or Business Warehouse is that the data can be input and reported via Excel spreadsheets instead of navigating the rather clunky world of SAP. The data in SAP BPC (Business Planning and Consolidation) can be automatically linked to a host of SAP applications. If your company runs SAP, this is the most accessible tool. I never used Hyperion, but I don't think it was it's explicitly designed to interact with SAP.