SAP Analytics
Thought Leadership

BPC has always been a flexible tool with many “hooks” through Excel and the database layer enabling all manner of customizations to increase usability to customers’ exact specifications. The risk of customizing is the potential of that customization being an impediment to an upgrade. One popular access point provided by SAP/OutlookSoft was the “MNU_Commands” hook.

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!

We know that EPM (and specifically SAP BPC) implementations have the potential to be very profitable, more so than other IT projects like ERP implementations. But how do you prove that?

This blog takes a step by step approach to building a solid business case for a SAP BPC implementation. There are many intangible benefits to an EPM project which are difficult to put a value to, but we can set out all the costs and calculate a large part of the benefits. Even without adding in the intangible benefits, such as improved data quality, higher management efficiency and faster decision making, BPC projects can still be very profitable projects, so let’s go through the business case elements step by step.

Whether you already have an existing BPC environment or are planning a new one, how to appropriately staff and support your EPM environment is a big question to tackle early on. While the number of FTEs will greatly differ based on the size or your organization, the complexities of your planning process, and the level of automation you invest in upfront, there are some basic skillsets you should address.

SAP BPC systems receive data from a range of external sources.  The planning and configuration necessary to insert this data into the system is an important aspect of an implementation.  The integrity of data is vital, and invalid data can affect processes within SAP BPC, such as calculations and reporting.  Safeguards should be in place to prevent the entry of invalid data.

The main methods employed to enter external data into a SAP BPC system are:

• Interfaces to source systems such as an ERP or SAP BW system.
• Flat file uploads.
• Input schedules for manual data entry.

The first two sources – interfaces and flat files – are tested, configured, and operated by experienced administrators and consultants who understand the data structures of source systems and SAP BPC, so these usually do not create problems.  The greatest risk is with data entered through input schedules by users who, whilst knowledgeable about the commercial functions of their organisations, are not experts in the data structures of financial information systems like SAP BPC.  The techniques available to ensure the integrity of data entered via input schedules are the focus of this article.

When upgrading to BPC 10.x, many companies are curious about what new features will become available to them.  Besides being quicker, more stable, etc., there are three new features that Column5 believes are worth the upgrade.

A key component of an effective reporting strategy is the ability to get data to users when, where, and how they need it to make better decisions. For many users in today’s technology-driven world, that means mobile devices are a critical part of the overall reporting strategy.

While working with clients to deliver EPM capabilities, we have all heard about how it is critical to have good EPM business processes in place within an organization. I would say that I totally agree with an earlier Column5 blog post, “The Process is King”. Clearly documented business process models assist organizations to align operations to their strategy, promote better communication, improve existing practices, establish control and consistency, and even gain competitive advantage.

Column5 CEO David Den Boer once told me, “Behind every checklist there is a dead body. “ As a military veteran, he knew that safety procedures were often put in place in the aftermath of a tragic accident that unfortunately involved the loss of life. The military is well known for their rigor, strict definition of procedures, and processes that deliver consistent and repeatable results.  Isn’t that what we all strive for in delivery of our EPM projects? You can accomplish this result without enduring fatalities along the way.

BPC owners often seek to implement automation to make manual administration the exception wherever possible, in order to lower TCO and increase uptime.  For dimension automation, new members added to source systems (accounts, product names, etc.) would be automatically inserted into the BPC master data tables.  Automating this task could save quite a bit of manual effort over time, and increase system uptime.  If your BPC deployment requires manual dimension maintenance, this solution may be of great interest to you.