I have had the pleasure of being involved with at least 100 BPC (OLAP) deployments over the past two decades in some role or another. I wanted to share what I believe are the 7 Deadly Sins of a BPC Implementation. Over the past 9 months I have been speaking with new clients to my organization who have had prior experience with another firm claiming to understand BPC. Seventy-five percent (75%) of these discussions involved most, if not all of the aspects described below.
Topics:
Best Practices,
Thought Leadership,
Enterprise Performance Management (EPM),
Project Management,
Performance,
Value,
Implementation,
BPC (Business Planning & Consolidation)
It’s the corporation’s latest planning/forecast/budget cycle, and you’re responsible for putting together the consolidated reports for the executive review meetings. The analysts in Europe, Asia, North America and South America have sent you their Excel spreadsheets, which have been reviewed and revised according to their local management review meetings. Their regional financial managers will be participating in the executive review meetings, and presenting their region’s forecast.
The PowerPoint reporting package for the executive review meeting will consist of income statements, capital spending reports and Key Performance Indicators (KPIs). Comments will be included, and there will be slides/reports at the region and total corporate level. You have spent hours copying the Excel “reports” and pasting them into the PowerPoint slides. Also, in order to produce the numbers for the region and total corporate reports, you had to combine the multiple Excel spreadsheets from the site analysts. This included calculating the KPIs at the region and corporate levels. You finally have everything ready for tomorrow’s first executive review meeting, although it’s 9:15 PM and you’re still at the office.
Topics:
Center of Excellence,
Excel,
Thought Leadership,
Enterprise Performance Management (EPM),
Value,
Implementation,
BPC (Business Planning & Consolidation),
Forecasting
This week has been somewhat of a client reunion week in that three of our clients from the “OutlookSoft” days are looking at upgrading to BPC v10. Enough to where I had three meetings that felt like one topic three times over. That makes me believe there are other SAP BPC clients out there who could benefit from this information. This article is for any existing SAP BPC client who is not currently on v10.
Topics:
HANA,
Thought Leadership,
OutlookSoft,
NetWeaver,
Roadmap,
Microsoft,
Implementation,
BPC (Business Planning & Consolidation)
The business blueprint is arguably the most important – and most complex – document that is delivered during an implementation. But how much time should be allotted to this phase?
Topics:
Center of Excellence,
Best Practices,
Thought Leadership,
Value,
Implementation,
BPC (Business Planning & Consolidation)
I was on a sales call recently with a current BPC customer who is about to embark on an upgrade to BPC 10.0 for the NetWeaver platform. The customer had recently implemented BPC v7.5 and was expressing their frustration with having to move to v10.0 and learn the new way to write reports after just spending a lot of time and money on implementing v7.5. Had they known that v10.0 was coming so soon they might have done things differently. This got me thinking about how many times I’ve encountered customers in similar situations. The situation being that you don’t know what you don’t know. Whether it is not knowing about the BPC roadmap or the vast community of BPC users exchanging ideas and supporting each other on the SAP forums, there is ton of information and resources available to a BPC customer. A great starting point is Column5’s own website (I have to plug my own company) where you can find info on BPC via our blogs, demos, webcasts, case studies and more at www.Column5.com. In addition to Column5’s website, BPC information is available from SAP. The challenge is finding it as it as the information is spread across several different sites and portals. A friend and former colleague of mine at SAP, Jens Koerner, wrote a very useful blog that outlines all of the information available from SAP with links directly to the content so rather than recreate what he’s already done I will simply share a link to his original blog here.
Topics:
Center of Excellence,
Best Practices,
Enterprise Performance Management (EPM),
Roadmap,
Implementation
Recall your last few project status meetings. The project manager reviews the open tasks and asks for progress. The technical team reviews and responds with answers such as 50% complete, 90% complete, 34.7% complete, etc, etc, etc……. but what does it all mean?
Topics:
Thought Leadership,
Project Management,
Implementation,
BPC (Business Planning & Consolidation)
SAP BPC forecasting model implementations frequently replace existing spreadsheet forecasting models. A key question to be asked when implementing SAP BPC is to consider how it will improve a forecasting process that works and therefore justify the disruption the change may involve and the expense, both internal and external.
Topics:
Excel,
Analytics,
Value,
Implementation,
Data,
BPC (Business Planning & Consolidation),
Forecasting
Way 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.?
Topics:
Center of Excellence,
Enterprise Performance Management (EPM),
Analytics,
Financial Close,
Implementation,
BPC (Business Planning & Consolidation)
This is an old story we see all the time. A policeman happens upon a drunk frantically searching for something at the base of a streetlight. “Hello there, looking for something?” The drunk looks up, “Yesh Offisher, I lost my keysh in the park.” “In the park? Then why are you looking on this street corner?” says the confused cop. “The light is better here!” says the drunk.
This is the problem with how EPM projects are governed today, and no, I am not implying drunks are prevalent in EPM! Too often prospects make decisions based solely on price, thinking that value is equivalent across service providers, and net ROI is maximized by selecting the lowest cost implementation proposal. I encourage customers to stop and think about what they get with the low cost provider. A team that doesn’t have the ability to offer the appropriate breadth services that are specifically designed to add value while reducing risk, leave only the lowest common denominator of value in their wake.
Topics:
Best Practices,
Enterprise Performance Management (EPM),
EPM ROI,
Value,
Implementation,
BPC (Business Planning & Consolidation)
In the last article we looked at a pragmatic approach to assessing EPM Maturity using a Maturity Matrix. In this article we’ll expand on the matrix and also develop the ideas of what this can be used for in developing an EPM approach in an organization.
Topics:
EPM Maturity,
Enterprise Performance Management (EPM),
Performance,
Roadmap,
Implementation,
BPC (Business Planning & Consolidation)