SAP Analytics
Thought Leadership

Over the past 6 months, we’ve seen a lot of our clients experience stubborn errors and issues that have surfaced in BPC for Microsoft environments. It’s important to understand that these issues are mostly related to user errors or updates not being performed correctly.

The Technical Team at Column5 has performed in-depth troubleshooting and continues to provide various technical solutions for our customers. Today, we have compiled a list of the top 10 issues including root cause and a simple solution. Continue reading to discover how you can tackle these issues and improve your performance!

Bad performance can make even a well-designed EPM system unusable, and if you’ve got more aggressive expectations like those required for an xP&A solution...even suboptimal performance can be a total block to realizing your goals. Performance issues have got to be attacked quickly and decisively.

Many users feel a poorly performing system is a fatal condition and they blame the software, as if the system is working as expected when the user experience is slowed. This is not only a false belief, but it can also be a very costly one. If there’s nothing that can be done to improve an unworkable software product, then replacing it is the only option. However, poor performance is an indicator of your solution working, but it must not be tolerated. That’s right, more users adding more data to an expanding EPM or xP&A solution will eventually create poor performance. The trouble begins when you don’t know what to do about this eventuality. Don’t react rashly, instead follow the practical steps below to get a grip on the root cause of the degraded performance...in this case, for SAP BPC for NetWeaver.

If you're a support team member or power user of SAP BPC for NetWeaver, you probably know there are many standard SAP BW layer housekeeping jobs that are provided by SAP.  Most of these generate system information required for analyzing SAP BPC performance, system/error logs retention, completed job logs, etc. and are run at their default frequency. These can be scheduled in SM36, though you can't stop here. 

Keep reading to find out how to avoid poor performance by following the 6 steps below.

To appreciate the new foundation for BPC 11, we have to explore the underlying database platform.  BW/4HANA may share a similar name with its predecessor, however, this all-new platform represents SAP’s rearchitected, next-generation data warehouse.

Let’s explore this new platform by directly addressing five key commonly asked questions:

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. 

A risk is the possibility of an event or a condition that could negatively impact a project. There are many events or conditions in any EPM BPC implementation that can derail the project, because BPC is a complex tool that touches many areas of your organization. This article is intended to help mitigate risk.

For 30 years there has been a divergent view as to the best approach to using technology to support the key finance process of consolidation and reporting, generally known today as the “record to report process”.

To deliver excellence in the record to report process SAP now offers S/4HANA Group Reporting.  Read on to see if it's the best technology for you:

EPM as a solution category has arguably been around for more than two decades. Before the turn of the century, a long line of solutions starting with Hyperion was developed to alleviate specific pain points caused by Excel-based financial planning and analysis (FP&A) processes. 

In the first significant redefinition of EPM technology requisites, Gartner has just coined xP&A for Extended Planning & Analysis. While Gartner did not necessarily define an advanced performance management process to go along with these new platform technology requirements…xP&A does make possible some highly valuable advancements that are, in our humble opinion, worth serious consideration. 

Two key themes underpin xP&A:

• Alignment of Operational and Financial planning and analysis
• Incorporation of AI features such as Predictive Analytics

Of course, astute users of EPM might observe that using EPM tools to cover operational planning and analysis is not new, nor is predictive analytics. What is new is aligning these capabilities as a unified platform and assigning it a label. 

Let's face it, Gartner is influential. Redefining this category has had a ripple effect almost immediately on the market. Vendors formerly identifying as EPM technology developers snapped in alignment to rebrand their product portfolio as supporting xP&A. Customers are sure to follow Gartner's classification and articulate requirements for new analytics solutions using the fresh xP&A framework. 

How do longstanding vendors support these newly defined requirements? Prospective customers seeking the benefits of xP&A are right to be skeptical. Let's discuss three key ways technology vendors offering cloud EPM solutions may be overplaying their capabilities when they claim their solutions support xP&A. 

Most organizations think about defining and improving the business case for expected ROI from EPM models only at the time of technology purchase - if these concepts are considered at all. But this is a mistake. Instead, the best practice is to measure the ROI of the system frequently in as many meaningful dimensions as can be evaluated. For example, solution and cycle performance times, analytic value, accessibility/reach are all crucial dimensions where metrics should be defined and consistently monitored for optimization opportunities. Doing so will help to bring about a significant shift in Performance Management capabilities.

The current trend is to start from scratch and re-implement performance management (EPM or xP&A) solutions to address challenges with the status quo solution effectiveness. Unfortunately, this extreme step is very costly and not likely to produce high-value results.

Over the last decade, Column5 has been very involved in supporting SAP BPC Solutions, and a common theme for our customers has been the performance and stability of their system. With this in mind, we set out to address this challenge by developing the Darwin program.

Darwin has evolved (pun intended) to become a comprehensive platform of advanced features and pre-defined processes helping organizations maximize the value of SAP Analytics investments.

This blog focuses on how customers leverage Darwin’s advanced calculation capabilities to address common performance challenges specifically.