9 Reasons SAP BW Projects Fail-Maybe! [Template]

Table of Contents

Why SAP BW Projects Fail - A Diagnosis

After watching a recent video by Mico Yuk and Jon of Jon ERP and reading the related Gartner report, which was actually sort of depressing, I had a long tête-a-tête with my brother and chief SAP BW architect to see if we couldn’t diagnose why so many BW projects around the world are apparently failing. 


Especially since the ones we have worked on have generally succeeded.   We think this is an important question because if 75% of all IT projects are doomed to failure on day one, the question is "Why" are they doomed to fail and can these doomed projects be identified through risk evaluation and perhaps set on a course with a high probability ( i.e. > 95% confidence level) of success?

Common Causes of Business Intelligence Implementation Project Failures


Brainstorming, we came up with the following potential common causes of business intelligence project failures:

  • Bad data and the related lack of confidence in the data by the end user.

  • User Interface.

  • BEx query and are the results better than Excel or a step backwards.

  • Does it lead you to the next actionable step.

  • Human Factors - do not underestimate these.

  • Resistance to Change or failed Organizational Change Management.

  • Number of weeks spent on user interface design with user on webi and  xcelsius projects.

  • U.I. Interface Requirements unclear.

  • Insufficient training, both in quality and quantity, delivered across the enterprise in an on-going manner. 

We also identified certain special causes that we have ran across. 

  • Acquisitions-resulting in changes in priorities.

  • Divestitures-resulting in numerous data problems.

  • Competitors sowing FUD (Fear, Uncertainty and Doubt)-sand in the gears.

  • Diversity in the company regarding lines of business-movie makers and jet engines have somewhat different business information requirements.

We also came to the conclusion there are various types of project failure risk factors:

  • Project Execution up to and including a failure to Go-live.

  • Implementation Methodology not defined or repeatable.

  • Failure of the underlying source system implementation.

  • Using ABAP versus the modeling capabilities of the SAP BW system.

  • System performance problems including:
    • Slow response times
    • Interface problems
    • Low or Fragmented Memory of both Ram and Hard Disk Free Memory
    • Poor, No or Convoluted Design throughout
    • Undersized Servers

  • Right answer for the wrong problem type problems.

  • Business Buy-In just not there.

  • Poorly defined or incomplete Business Requirements.

  • No clear hard-dollar value case.

  • Arbitrary timelines or schedules not based on facts.

  • Customer Expectations not set properly.

  • Lack of periodic Process, Quality or Project Management Plan Audits.

  • Incomplete Testing.

  • No Configuration Management or Version Controls.

  • Believing the Agile Scrum methodology is all you need.

  • Fixed Price Contracts.

  • No Agreement on the Project Management Methodology to be used.

  • Not using a Repetitive WaterFall Process.

  • Not following the PMP or SAP ASAP project implementation processes.

Take The First Step To Fixing Your BW Project Implementation Problems


We are sure there are many other reasons that could be identified, but we have just about always ran across these on failing projects. 

As they say, the first step in fixing a problem is admitting there is a problem.  

If you want to increase the success rate of your Business Intelligence project, you can see there are many areas that must be addressed properly that are related to either people, process or technology or a combination of all three.

SAP BW Project Success Factors 

SAP BW User Acceptance Depends on People, Process and Technology Factors

Impact of Bad Data On Project Success


If you read this blog often, and more than 411,000 people have, you will have ran across a little statistic that we find ‘impactful’ - The annual total loss to all U.S. businesses from bad data is estimated to be over $600,000,000,000 (that’s right, six-hundred billion dollars), and for that reason, we have listed bad data as one of the leading causes of Business Intelligence project failures.

There are a lot of ways to attempt to address this issue, and on any project, you might benefit from having a proven data conversion template to use.  You can get one here.



SAP Data Conversion  Template



But just why might bad data have such a drastic impact on the ultimate user acceptance of a BI system. 


The short answer is lack of TRUST! 


For instance, if only 70% of your company’s total sales (as reported in various surveys) are actually captured by the ‘system’, and you’re the CFO who has to focus on delivering the numbers, you're not really going to be able to just run with what the system tells you (you're gonna need more flat files, more handwork, more Excel; you will get yesterday's numbers...3 months from now). 

TRUST or lack thereof is a core component of the economy, no matter where you look.  For the CEO of a company that introduces new products frequently, TRUST in the marketing analysis and the related hard-dollar expenditures it takes to successfully launch that new product is critical. 

Launching More SKUs Yet Flat Sales Growth


Yet, in a recent survey reported in Inbound Logistics magazine, it was reported that Consumer Packaged Goods companies have launched 23 percent more SKUs (Stock Keeping Units) than four years ago, yet the sales growth rate has remained largely flat. 

Data Driven Problem

To me, this is a data problem, which also then leads to forecast errors in the demand planning side of the house.

In short, in the complete Sales & Operations Planning cycle, the product marketing specialist, the demand planners, the sales planners; they all are missing the data they need to make informed decisions.

If the datawarehouse provided it with 100% confidence each and every single day, they would gladly accept it and TRUST it and top management would then have a centralized common Core template system centered around common processes that they could then roll out around the world.

If you have seen a project fail, besides making great reading, please tell us and others about it by leaving a comment below. Without mentioning any names, just tell us what you saw and why you think it was a failure and perhaps what possibly could have been done to prevent this particular failure.


People Who Read This Also Read:





Topics from this blog:
How-To Data Governance Templates

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie D. Ayers, PMP

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie D. Ayers, PMP

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.