The landscape of an EPM project is literally changing right before our eyes. In fact, we posted a blog on this topic not long ago and realized that there were several updates that needed to be made. Not because the post was incorrect but because the practice in the field had changed in a few short years.Read More
Column5 - Leading Edge of Enterprise Performance Management Blog
Thought Leadership on SAP BPC and EPM Implementations
Successful delivery and adoption of any project requires a partnership between the business, IT, value chain partners and end-users to ensure the solution delivered meets business objectives and return on investment. Collaboration is required to make certain:Read More
Column5 is pleased to be sponsoring the North American edition of the “Close Cycle Rankings 2014” in conjunction with our research partners EPM International. This research is now available to our clients.
For the last 10 years EPM International (EPMi) has compiled information from publicly available sources on the elapsed days taken to report Q4/year-end results and obtain the annual audit report sign-off for over 1,000 of the world’s largest companies, including the New York Stock Exchange Top 100.Read More
EPM stands for Enterprise Performance Management. In a nutshell, it is at least a 4th generation moniker describing an underlying use of OLAP (Online Analytical Processing) technology. Why should you care? Well, it really is the current “end game” of computing for most organizations. If you are an executive or in a leadership role in say, Finance or FP&A, you should really care! One cannot manage that which they do not measure. Those who can achieve EPM and leverage OLAP technology will outperform their peer groups across the board. How in the world can you track your EPS or monthly profit if you do not capture and report the information to do so? How can you take action to get back on plan, or stay ahead of plan, if you have no tools to do so? This is what EPM is for, and what OLAP has been solving for nearly 40 years. The path to effective leadership and success is not simply about delivering results; it is about consistently delivering results. In order to do this one must be able to both monitor their business, and be able to take actions to control the business.
If you're like a lot of people out there, you probably had to read the title of this blog twice. Over the last several years there has been a plethora of speculation, confusion, frustration and exasperation about the future of BPC for the Microsoft Platform. From the very first announcement that SAP would port BPC to the NetWeaver platform, people have forecasted the end of the Microsoft version. The lack of roadmap beyond extensions of platform support for the latest versions and some new content (i.e. IFRS Starter Kit) does make one wonder about the future of BPC for the Microsoft Platform. Here's the good news: SAP recently released the latest roadmap for the EPM portfolio and there are several meaningful planned enhancements to BPC for the Microsoft Platform; from here on out referred to as BPCMS.
The Excel Add-In reporting tool of EPM 10 combines the features of Excel with EPM functionality. A feature within Excel that is sometimes useful to meet more advanced reporting needs is macros programmed using Visual Basic (VBA). This can achieve features that are not achievable through EPM 10 functionality.
Recently I received a detailed critique of the underlying technology components of BPC in the form of a comment to one of my blog posts. At first, I chuckled at the response, and wanted to respond with a blog post entitled, “Things No CFO Said…Ever”, but then I thought just how sadly prevalent some of the beliefs are in the EPM ecosystem.
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.
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.