<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">

SAP Analytics
Thought Leadership

BPC Heaven vs. Excel Hell

Posted by Rick Bryant on Fri, Jan 24, 2014 @ 09:01 AM

paper clutter resized 600Way back in 2009 while I was working in the EPM practice at SAP I routinely cited a Gartner survey stating that 70% of organizations still relied on spreadsheets for their budgeting, planning and forecasting processes when speaking with customers or at events. Fast forward four years to 2013 and amazingly a new Aberdeen study found that a whopping 89% of organizations use spreadsheets for these processes! What gives? We've all heard over and over about the pitfalls of using spreadsheets for these processes, often referred to as “Excel Hell”.  The bottom line is that business users love spreadsheets for their ease of use and flexibility.  So how do we let business users continue to use their tool of choice AND have the qualities of a planning system such as security, workflow, common formulas and logic, a single source of data, multi-dimensional analysis, etc.?

It turns out that the founders of OutlookSoft – which went on to become SAP Business Planning and Consolidation (BPC) when OutlookSoft was acquired by SAP in 2007 - were on to something when they embraced the spreadsheet and built an application around it.  They didn’t try to recreate the Excel experience; they leveraged it as the platform upon which the user experience was built. Today that user interface is the frontend not only to BPC but also for the other solutions in SAP’s Enterprise Performance Management portfolio.  To be clear, BPC’s Excel interface (I should also mention that there are user interfaces for Microsoft Word and PowerPoint as well) is not a static, single user tool to which you are extracting data. Think of it as a window into the database; the data doesn’t reside in the spreadsheet it is stored in the database so that each time a report is opened the latest data is pulled from the database. The list of advantages to using a purpose built application instead of native Excel for budgeting, planning and forecasting is quite lengthy and there are many companies out there that offer solutions that solve for the inherent issues with using spreadsheets, none however, have done it as successfully as SAP’s Business Planning and Consolidation.

Contact us at info@column5.com for more information on BPC!

Interested in learning more about EPM and BPC? Register for one of our upcoming webcasts!

View Webcasts!

Topics: Center of Excellence, Enterprise Performance Management (EPM), Analytics, Financial Close, Implementation, BPC (Business Planning & Consolidation)


Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book


2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC


  3. Get Your EPM Assessment  


Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment