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.?

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.

Column5's EPM Academy sets the industry standard in quality curriculum, with course content developed by top field experts on SAP products and delivered in a variety of formats.Software knowledge and skills are only as valuable as what's retained and applied in the real world. Column5's "360 Training Experience" ensures that your staff will not only develop good habits and acquire confidence while mastering the software—they'll build organizational enthusiasm for EPM that lasts long after implementation.

Column5 is the leading edge of Enterprise Performance Management and strives to provide technical tools which enable personal growth to benefit you and your organization. This blog will provide users high level functional help using dimension properties to automatically display related members

For many companies, its getting to be that time of year again. No, I am not talking about getting ready for Christmas decorating contests in the office...although that is not far off. I am talking about getting ready for the big annual plan.

I was reading the newspaper recently and came across a story about a Spanish submarine that was constructed 70 tons too heavy. Officials didn't discover the problem until the submarine was nearly complete. Now they fear if they launch the sub it would be too heavy to resurface! How did this happen? The problem can be traced to a miscalculation — someone apparently put a decimal point in the wrong place. Ouch! Something as simple as a keying error resulted in a $2.7 billion dollar paper weight. Fortunately, engineers think they can enhance the sub to make it seaworthy but this story illustrates how costly user errors can be. Segue to the world of finance where roughly 70% of companies rely solely on Excel for planning, budgeting and forecasting and the stories of user error and resulting time loss may not be as astounding as an overweight submarine but are just as prevalent.

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.

In part one of this post we explored some of the areas where SAP Business Planning and Consolidation has added significant value to the Consolidation process through the use of Business Process Flows. The Business Process Flow not only aided in guiding a user through the steps in a process but served as a mechanism to allow once time consuming centralized tasks to be pushed upstream and distributed across the user base.  This post will dive into some key model considerations that need to be addressed in order to achieve this value.

The ultimate goal in any competitive pursuit is to achieve peak performance—and in the enterprise performance management world, that means reaching "column five" in the EPM Maturity Model.

In the first part of this blog, I discussed how to obtain some helpful and resourceful information around the SAP EPM space on the web.  My main emphasis focused around several SAP websites including the SAP Service Market Place, SAP’s Help Center and the EPM Forum.  Though I know most sequels don’t do as well as the original, I would like to now share with you some very supportive sites that revolve around the database layer of BPC.