SAP Analytics
Thought Leadership

It is said that there is no accounting for taste. Meaning, there is no mathematical formula that can define and score what individuals prefer. This is because each person has their own “taste” or set of subjective preferences they find appealing, and attempting to distill this highly variable process of selecting what one finds attractive, tasteful, even beautiful to a digital formula for universal criteria is considered impossible.

For some reason, this same subjectivity has reigned in the world of Enterprise Performance Management (EPM) solutions for too long, as I will argue. With the advent of xP&A (Extended Planning & Analysis), which can be thought of as high-intensity EPM, deciding which solution to buy is more critical than ever.

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.

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.

Description:
Critical vulnerability identified for SAP Systems based on SAP JAVA Stack.
The RECON (Remotely Exploitable Code On NetWeaver) vulnerability has a CVSS score of 10 out of 10 (the most severe)

Symptom:
LM Configuration Wizard of SAP NetWeaver AS JAVA, does not perform an authentication check which allows an attacker without prior authentication, to execute configuration tasks to perform critical actions against the SAP Java system, including the ability to create an administrative user, and therefore compromising Confidentiality, Integrity and Availability of the system.

The COVID-19 pandemic hit just like the children’s game of musical chairs. As the music of our economy stopped, if you were not near a safe place to sit, you were caught out in the open…finding yourself at risk. Similarly, your EPM solution was likely being enhanced, and upgraded on a certain path before the virus came into being. Any EPM strategy not ready for intensified operations learned the hidden weaknesses of their solution.

To make you feel better, almost no EPM solution was ready for this.

Whatever the state was of your EPM solution, that is the tool you had to wield as you navigated your organization through  the impacts of the virus. As we said in part one of this blog series, the jarring impact to the market doesn’t specifically need to be the virus, it could be anything. Just some unpredictable market influence that won’t wait for long running processes.

"The Chinese use two brush strokes to write the word 'crisis. ' One brush stroke stands for danger; the other for opportunity. In a crisis, be aware of the danger--but recognize the opportunity." 

John F. Kennedy, US President 

It's the sort of blockbuster movie plot you'd expect to see while sitting in the dark confines of a movie theater, booming audio and a gasping crowd. A thrilling plot has your eyes riveted to the screen, where the dramatic tension is only broken when you run out of popcorn or the movie ends. In that scenario, you can return to your "real life" in a little over an hour, with no discernible life altering impact. It is now clear this COVID-19 provocateur is no movie; this virus will not go away so quietly without leaving an indelible impact on the world.  It most certainly will impact how you and the leadership team rely on your EPM software and Enterprise Performance Management in general. 

For this article, we'll define EPM software as Gartner does as dealing with “the process of monitoring performance across the enterprise with the goal of improving business performance.”  Other activities we'll include under the Enterprise Performance Management umbrella are FP&A modeling, budgeting, forecasting, reporting, and consolidation.  Keep reading to find out how our plot unfolds. You'll learn how to avoid high latency, Excel centric planning.  You'll also learn 3 stages of recovery and the leadership principles needed to accelerate  your Enterprise Performance Management and remodeling during COVID-19. 

Our tech team has noticed a pattern of SAP BPC performance issues with certain SAP BPC 10 and SAP BPC 10.1 systems on Microsoft. Dimension indexes are becoming fragmented, which seems to relate to dimension processing. The addition of even a single member to a dimension, with the same processing, fragments the first index (clustered) in the list. In turn, Analysis Services is unable to read from the dimension table efficiently, which in turn kills retrieval of data (reports / schedules) performance.