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

SAP Analytics
Thought Leadership

The Top 5 Critical Success Factors for Your EPM Project

Posted by Column5 Consulting on Tue, Jan 31, 2023 @ 12:01 PM

How do you ensure your Enterprise Performance Management (EPM), Business Planning & Consolidation (BPC) or Business Intelligence (BI) project will start out positioned for success? You've gone through the RFP process, completed the vendor evaluation, and have decided on the technology. But before diving into requirements and design, you also need to spend time in the project initiation phase--ensuring the project's critical success factors (CSFs) are defined and socialized, and that a plan for implementation is developed. Be sure there is a common understanding of the importance of the CSFs and how they differ from project objectives and success criteria.

Topics: Best Practices, Enterprise Performance Management (EPM), Project Management, Performance, BPC (Business Planning & Consolidation)

The Top 5 Things to Consider When Selecting a Consulting Partner

Posted by Column5 Consulting on Sat, Dec 10, 2022 @ 08:12 AM

As with most specialized software programs, it is usually not suggested to implement SAP BPC without the assistance of a consulting partner.  Many projects require expertise that most EPM administrators do not have, and so it is recommended to find a partner that can ensure success.  Choosing this partner is an important decision.  Here are a few of the top things a company should look at when deciding on an appropriate organization. 

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), Project Management, Training, Implementation, BPC (Business Planning & Consolidation)

We Don’t Know What We Don’t Know

Posted by David Den Boer on Fri, Apr 06, 2018 @ 08:04 AM

We have all overcome mistakes in life, using the rearview mirror to observe how easy it would have been to sidestep the pitfall, commenting, “If only I knew then what I know now.” This thought crosses my mind almost daily.

What do you do when you feel this way about the EPM process, BPC or your consultants? Do you ever wonder how they became experts, or how qualified they truly are? How do they define best practice? Recently, I worked with a customer who started their BPC journey with an early version of BPC for NetWeaver. They sought out highly talented consultants, assuming their talent and experience based on their reputation within the industry.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), Implementation, Services Focused, Executive

Key Lessons From Our Webcast Series with DNB ASA: "Achieving Excellence and Efficiency in EPM with SAP"

Posted by Paul Coleman on Thu, Apr 20, 2017 @ 12:04 PM

During November and December, Column5, in conjunction with our client DNB, three interesting and informative webcasts ran on the exciting and rewarding journey taken by DNB ASA, Norway’s largest financial services group.

This series of webcasts focused on the following specific and important elements of Enterprise Performance Management:

  • Financial Consolidation for Statutory and Regulatory Reporting
  • Intercompany Reconciliation
  • The Last Mile of Financial Reporting

Each topic was underpinned by informing the attendees how SAP EPM solutions help companies achieve excellence and efficiency based on this real life DNB example.

Topics: Best Practices, Case Study, sap, EPM, webcast

EPM Maturity Model - How do I use it?

Posted by Peter Bull on Mon, Mar 27, 2017 @ 14:03 PM

In the last article we looked at the definition and content of the EPM Maturity Model.

In this article we’ll look at how to gauge EPM Maturity and how to identify areas to improve. At the core of the Maturity Model is the definition of:

  • Right Model
  • Right Audience
  • Right Time

Across these definitions we lay a scale that moves from low levels of maturity to high levels of maturity:

Topics: Best Practices, Process Improvement, Thought Leadership, Enterprise Performance Management (EPM)

EPM Maturity Model - What is it?

Posted by Peter Bull on Thu, Mar 23, 2017 @ 09:03 AM

Organizations need to plan, measure and manage across Strategy, Operations and Finance. Isn’t that what Enterprise Performance Management (EPM) is all about? It seems like a simple formula. But what about if we change the question to ask what makes successful EPM and successful organizations? If we start with the definition that “Successful EPM drives organizations that dramatically outperform their competitors in terms of both financial and non-financial results” – this gives a very different perspective on the importance and value of EPM. It also means that you need to have a mechanism and framework to objectively review your EPM capabilities and relative maturity.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM)

How to be a BPC Capital Planning Jedi Master - from Darwin EPM

Posted by David Den Boer on Tue, Mar 14, 2017 @ 08:03 AM

At Column5 we always advocate the approach to EPM that yields the highest value returned to our clients and EPM users in general. One emerging best practice in EPM is adopting packaged content in lieu of custom developed solutions for your EPM functionality. The advantages are legion: faster time to value, more robust functionality, enhanced performance, improved supportability, lower project cost and total cost of ownership over time. Packaged content is most applicable when facing standard requirements that are consistent across customers.

Topics: Best Practices, BPC, Capital planning

Calculating Column Totals Dynamically - SAP BPC

Posted by Deb Silverman on Wed, Mar 16, 2016 @ 12:03 PM

Need to calculate a grand total dynamically?  Shifting of Local Members giving you a headache?  I previously used Indirect() functions, but I discovered with larger reports this put a drag on reporting performance.  To sum from the first report column to the last report column I was using something like this  =SUM(EPMPOSITION(1):INDIRECT(ADDRESS(ROW(),COLUMN()-1))), which is not considered best practice but I got results!

The SAP definition: “EPMALLMEMBERS is used to perform a calculation (such as sum or average) on all the members displayed in a row or column axis, whether the axis contains one or several dimensions”

HOW?  Here are some examples:

Topics: Best Practices, Excel, Training, Performance

A Great Financial Consolidation Solution for Statutory and Regulatory Reporting in Complex Multinational Organisations

Posted by Paul Coleman on Tue, Feb 16, 2016 @ 09:02 AM

SAP has a portfolio of Consolidation solutions with their own unique positioning and the SAP Financial Consolidation (FC) software is an enterprise solution offered to companies looking to improve and speed up their financial close – without sacrificing quality control and compliance.

FC became part of the SAP EPM portfolio through the acquisition of BusinessObjects in 2007.  BusinessObjects itself acquired the French software vendor Cartesis who originally marketed Financial Consolidation as Cartesis Magnitude.  With a large and loyal customer base throughout Europe and Japan, FC has a particularly strong focus on statutory consolidation requirements within large multinational organisations that have complex and evolving corporate structures across multiple reporting standards (e.g. IFRS and local GAAP).

Topics: Best Practices, Analytics, Consolidation, Financial Close, Value

SAP BPC Performance - Best Practices

Posted by Charles Dagaev on Tue, Feb 02, 2016 @ 09:02 AM

Column5 and I have seen a lot of things over the years in the EPM space. I have been working on the technical side of BPC MS since 2000, BPC NW since 2007, and BPC NW on HANA since 2012, having implemented it around the world over 1000 times.

I have a dream to, at some point, write a book of everything I have seen over the years. If investors knew what was really going on deep within some of the world’s datacenters, I think some heads would be rolling! I won’t mention ANY NAMEs but some of them are the who’s who of worldwide companies!

I keep running into the same thing over and over and over again, whether it is hosted by a 3rd party or implemented on-site at a client. The challenges start with a common element that is surprisingly easy to fix: No one seems to take care of the servers and technology!

Topics: Best Practices, Performance, BPC (Business Planning & Consolidation)

Subscribe

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  

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