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

SAP Analytics
Thought Leadership

Discover the Value Formula to evaluate and implement EPM and xP&A solutions for success!

Posted by David Den Boer on Fri, May 14, 2021 @ 08:05 AM

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.

Topics: Enterprise Performance Management (EPM), Performance, sap, xp&a

Improve Performance of your SAP BPC Solution by 80% or more!

Posted by Blog Tipster on Wed, Apr 21, 2021 @ 08:04 AM

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.

Topics: Performance, sap, Darwin EPM, DarCE, xp&a

[TECH ALERT] How to fix the top 10 issues for BPC Microsoft Environments

Posted by Manus Cornelius on Wed, Apr 21, 2021 @ 03:04 AM

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!

Topics: Performance, Microsoft, BPC (Business Planning & Consolidation), Technical, User Experience

6 Housekeeping Hacks To Enhance Your SAP BPC Performance for NetWeaver

Posted by Vishal Goradia on Wed, Feb 03, 2021 @ 04:02 AM

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.

Topics: NetWeaver, Performance, sap bpc, Performance Tuning

[TECH ALERT] Critical vulnerability for SAP Systems on SAP JAVA Stack

Posted by Vishal Goradia on Wed, Aug 12, 2020 @ 09:08 AM

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.

Topics: Enterprise Performance Management (EPM), Performance, Technical

COVID-19: How To Update your EPM Solution & Avoid Exposure by Long Planning Turnaround Times

Posted by David Den Boer on Wed, Jul 15, 2020 @ 12:07 PM

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.

Topics: Thought Leadership, Enterprise Performance Management (EPM), Performance, Performance Tuning

COVID-19: A time for Leadership - Leveraging Enterprise Performance Management in Times of Crisis

Posted by David Den Boer on Fri, Jun 19, 2020 @ 05:06 AM

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

Topics: Thought Leadership, Enterprise Performance Management (EPM), Performance, User Experience

[TECH ALERT] Current Performance Issues with SAP BPC 10 and 10.1 MS

Posted by Charles Dagaev on Wed, Feb 28, 2018 @ 09:02 AM

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.

Topics: Enterprise Performance Management (EPM), Performance, Technical

How to (really) speed up your ABAP code

Posted by Richard Hynes on Wed, Feb 21, 2018 @ 09:02 AM

Have you ever wondered if there’s a straightforward way to make your SAP BPC system perform better? The Darwin Calculation Engine (DarCE) might be just the trick you need!

Topics: Performance, Technical, Darwin EPM

Kill Bill Volume 1: Memory Consumption and the White Screen of Death

Posted by Bill Gaskins on Wed, Sep 13, 2017 @ 11:09 AM

Google “EPM Performance or Memory issues” and you will receive millions of hits from your search results.  When it comes to performance and especially memory consumption, not only is the “magic bullet” fix rare but the resolution is potentially complex and multifaceted in nature.  On a recent project, we started to see symptoms that became issues including long refresh times.  For one user, we saw an Input Schedule consume so much memory it resulted in the “White Screen of Death (WSoD) and Excel crashing.  In this article, I wanted to look at the challenges we faced and strategies employed to resolve the issues.

Topics: Excel, Performance, EPM, SO - Functional Track

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