What is the Accuracy of CONSILIO IT on MRP on HANA Performance?

Executive Summary

  • This is the Consilio S/4HANA which is part of our research study.
  • We evaluate the accuracy of this case study.

Introduction

In this article, we will review the accuracy of the article by IT Daily.net which references information provided by the consulting company CONSILIO IT. CONSILIO IT is an SAP consulting partner, and consulting partner normally provide highly inaccurate information about SAP. Let’s see how they did in this article.

HANA on MRP

Here is how the article begins…

“In Material Requirements Planning (MRP), time-optimized and transparent processes are a critical success factor, but every minute, especially in economic turbulent times. Innovative MRP solutions based on the real-time platform SAP HANA convince with an unparalleled performance gain.”

This description starts off using deception. MRP processing is not an issue at companies unless they have misconfigured their ERP system. Also, there is no evidence that current times are more turbulent than previous economic times.

Finally, the real-time nature of HANA is not proven. HANA performs worse than Oracle 12c in analytics, and has no track record of performing well in processing or in transaction processing, which is why SAP publishes no benchmark for transactions, while in the past it did. This point is covered in the following quotation from the book SAP Nation 2.0.

“It has not helped matters that SAP has been opaque about HANA benchmarks. For two decades, its SD benchmark, which measures SAP customer order lines processed in its Sales and Distribution SD module, has been the gold standard for measuring new hardware and software infrastructure. It has not released those metrics using a HANA database. One of the (unsatisfactory) excuses offered is that the expensive hardware needed to support such a test in a lab is better shipped to paying customers.”

“In the meantime, database players like Oracle and Microsoft are offering their own in-memory switches while supporting the systems management and IT talent infrastructure most CIOs have built over the last few decades. So in a couple of years SAP may have to reverse source about database portability. SAP has already shared dates for continued support of the Oracle Database 12c in-memory switch and its Engineering Systems products like Exadata and the SPARC SuperCluster.”

HANA is an analytics database that has yet to master (updated as of information coming to us in September 2018), dual model database processing with anywhere near the promised performance.

Lets move to the next quote which addresses the performance improvement.

“27 minutes instead of 22 hours for material requirements planning – this is the performance improvement achieved by an MRP solution with SAP HANA technology compared to a classical MRP. These impressive figures have recently provided a test scenario for the specialist solution provider CONSILIO IT-Solutions, a company founded by former SAP and KPMG managers, who is constantly testing and developing new developments for its customers in the logistics, production, organization and information technology industries in innovative applications for its customers.”

This performance improvement is not matched by any of the observations that Brightwork Research & Analysis has collected (which include both client data points and benchmarks).

In fact, quite the opposite.

Our observations point to MRP performing quite a bit worse than MRP on even older versions of Oracle or SQL Server. This result was either found through rigging the test or by simply making up this number. Remember, SAP has never produced a benchmark indicating anything like this. We cover this in the following article What is the Actual HANA Performance?

Was This Article a Paid Placement?

CONSILIO IT clearly wants to sell services in HANA and S/4HANA and they are not a reliable guide for benchmarks. Is this publication validating any of these statements or do they come straight from CONSILIO IT? Actually, is this entire article looks like a paid placement from CONSILIO IT.

“The latest new development from SAP, the HANA database system, is proving to be a powerful efficiency lever thanks to in-memory computing.”

All computing is “in memory,” which we covered in the article How to Understand Why In-Memory Computing is a Myth. So this lack of distinction makes no sense. HANA proposed that it put the entire database into memory, a technique considered inefficient, but then later we found that HANA does not work this way, it memory optimizes. HANA uses a great deal of memory as we cover in the article How HANA Takes 30 to 40 Times the Memory of Other Databases, and that is the distinction. But benchmarking clearly shows that HANA has difficulty addressing the memory in the hardware footprint.

“The technology offers increased speed in compressed storage, networking and real-time analysis: the availability of materials and their stock ranges can be displayed in real-time.”

If HANA cannot outperform other similar databases with far smaller hardware footprints, why would any of this be true?

Material and stock ranges are already displayed in real time in every system we have reviewed. It is unclear what CONSILIO IT even means here. It may simply be repeating what SAP marketing.

Compression is irrelevant as storage is quite inexpensive. Do we cover this in the article What Was John Appleby’s Accuracy in Moving BW to HANA?

The comment of networking is a non-sequitur.

With or without HANA “real-time” analytics are already possible on all data platforms, if the data is prepared. It depends upon what data is a question — but again, HANA does not show performance advantages over competitive databases.

“This demonstrates a lot of potential, rightly demonstrated in the right applications, such as the practice test mentioned at the outset. HANA-based MRP solutions can dramatically accelerate complex material supply scheduling and capacity planning.”

We will discuss our observations which contradict this further on in the article.

The Supposed Practice Test with Realistic Data Volume

“Background of the practice test: Many companies suffer from a too slow material requirements planning run because the technical possibilities of classical databases do not give a faster data processing.”

No that is incorrect. The only reason for slow MRP that we have observed is when the system is not configured properly.

Second, as HANA is an analytics database, it should not be expected to improve MRP performance. Real life observations indicate that none of the statements SAP has made about being able to perform OLTP and OLAP out of the same database are true.

“Frequently, material requirements planning is subject to constraints, especially when new concepts, such as restriction-based and optimizing methods, are to compensate for the deficits of the MRP. The data volume increases and the run times of the programs are even longer.”

This paragraph is virtually unintelligible. So we have to guess what CONSILIO IT actually means.

New methods for supply planning have existed for some time. But they were developed not because of performance problems with MRP but because the methods were considered improvements on MRP regarding the planning output. These methods are covered in the book Supply Planning with MRP, DRP and APS Systems. But how does running MRP faster address those deficits? For instance, unlike inventory optimization and multi echelon planning, MRP does not know the stocking levels of locations that surround a particular planning location. Running MRP faster does not change that limitation. Running MRP faster also does not allow MRP to constrain resources.

CONSILIO IT seems deeply confused on the issue of MRP processing speed versus what MRP actually does versus other supply and production planning methods.

And Now on to Big Data?

“It was clear to us from the outset that the Big Data technology HANA offers completely different possibilities for our customers, not only in terms of optimizing the supply chain”, says David Reibnegger, project manager at CONSILIO.”

This is a massive switch in gears on the part of CONSILIO IT.

  • First, Big Data is not related to anything written above.
  • Secondly, HANA has nothing to do with Big Data, as described in the following article, HANA Big Data Equals Big Failure.

In terms of optimization of the supply chain, there are several methods available in supply and production planning that are “optimal.” One is inventory optimization and the second is cost optimization. Why use the term optimization as a general term (i.e. meaning to improve) when there are two methods available that actually deal with real optimization?

CONSILIO IT’s Fake MRP Test

An ECC 6.0 system with HANA DB, the so-called MRP Live, and a realistic business scenario with three plants, were created for the practice test he carried out, creating more than 300,000 materials (including configurable materials) with up to 17 disposting points. The comparison data provided a classic ECC with a MaxDB and identical master data.

The larger the amount of data, the greater the effect

The planning process had to resolve 80,000 pre-planning requirements for finished products as well as 300 customer orders for configurable materials over a period of 12 months. The products were partly planned, partly consumption-controlled. “In order to present the effect of the HANA database as much as possible, we began with small amounts of data and successively increased the volume,” says Reibnegger, summarizing: “The result speaks for itself: The classic MRP based on MaxDB Parallelization needed 22 hours for the planning of the requirements and generated 10 million planned orders – with 52 million secondary requirements and 7 million purchase requisitions including stock transfer requirements.”

All of this seems quite unlikely. This has never happened in any of our observations and it makes no sense from the perspective of HANA’s design and what it has proven to do well previously.

It also makes no sense in terms of what HANA has shown that it is capable of. CONSILIO IT goes on to make the following ridiculous claim.

“In addition, the HANA database and the newly developed HANA MRP were able to play out their strengths with increasing data volume as the data volume increases. The more data, the greater the time-optimizing effect of the HANA in-memory database. Businesses know more quickly when they need something.”

This quotation is headed right into crazytown. This is particularly deceptive because HANA’s memory management is significantly lower performance than the competing offerings. This means that CONSILIO IT absolutely knows this entire paragraph is false. Furthermore, no database processes with an infinite improvement as more data is used. This is how a person who works in marketing thinks that databases work. If CONSILIO IT is intent on lying, they could at least try to make the lies somewhat credible. This quotation fact checks itself.

In-Memory Computing for more Efficient Production Planning

“The enormous run-time gain opens up completely new possibilities for MRP Live on HANA-based supply chain planning. For example, planning is possible during the day so that companies can react quickly and flexibly to market changes.”

This is based upon the premise of faster MRP runtimes that are proposed to have been documented by CONSILIO IT. At Brightwork Research & Analysis, we question whether any of this happened.

But even if we assume it is true, the related benefits of running MRP during the day don’t make much sense.

  • Currently, almost all companies perform a nightly MRP run, called a net change run. Remember, the forecast is already in the system.
  • As orders come in, they decrement the forecast. Therefore when new sales orders come in, they don’t necessarily increase demand.

The illusion being presented by CONSILIO IT is that just because a system can be updated quickly, the supply network can be updated quickly. But it can’t.

CONSILIO IT’s Confusion Between Planning and Execution

Real supply chains have real lead times and real constraints. The overall presentation by CONSILIO IT is an oversimplification of how supply chain planning reacts to changes. MRP is a planning method — emphasis on planning. Planning means an endeavor for the future. Execution requires instantaneous changes (on some occasions), but not planning.

Yet, the overall presentation by CONSILIO IT is an oversimplification of how supply chain planning reacts to changes. MRP is a planning method — emphasis on planning. Planning means an endeavor for the future. Execution requires instantaneous changes (on some occasions), but not planning.

And then, to top it off, in addition to misrepresenting/misunderstanding CONSILIO is basing its proposals based upon an inaccuracy regarding HANA’s improvement in MRP processing speed. CONSILIO IT is producing inaccurate information in an uncountable number of dimensions.

MRP on HANA for Better Simulation?

Here is what CONSILIO IT has to say about simulation.

“Simulation runs for the assessment of different scenarios can thus be generated and evaluated over the course of a day, unlike classical MRPs, which require several days. “With HANA, the MRP program can work substantially, unlike conventional systems, where such actions are typically shifted to night because of the amount of data,” explains Reibnegger. “With MRP Live you always have the latest planning results.”

ECC was never a good simulation environment, and there is no evidence that S/4HANA will be better. It is extremely rare to find ECC environments that perform simulation, and not enough S/4HANA environments are live to say much of anything about how companies use it.

Simulation encompasses much more than speed. MRP is better simulated in an external system that is designed for simulation. This is covered in the book How to Repair Your MRP System.

Some of the concepts are covered in the following article An Analysis of the Commonly Listed Problems with MRP.

“A more efficient planning with the MRP Live is also possible for companies with highly complex products, a large number of orders or industries with short-term demand fluctuations. As a result, companies can react very quickly and flexibly to new customer requirements during production planning and control, or to exceptional situations in production.”

This seems to imply that products with extensive BOMs could be planned better. However, current ECC systems normally don’t have a problem exploding very complex BOMs. Companies with complex BOMs tend to have fewer overall SKUs, so it tends to balance out.

The later part of the quote goes back to the topic of reacting quickly. However, just because the computer can recompute quickly does not mean the overall supply chain or the production floor can react quickly.

CONSILIO IT Implies it Has Performed Full TCO and ROI Analyses of MRP on HANA

“Even if the MRP Live is not yet fully developed and certain functionalities such as the termination of planned orders or long-term planning are still in development, the costs for an MRP solution based on HANA will have been quickly amortized, especially because of the supply Chain ‘time’ is de facto just another word for ‘money’. And here is already true: Fast, faster, MRP Live.”

Seems like something written on the back of a cereal box.

CONSILIO IT seems to be underplaying the very high costs associated with HANA. And of course CONSILIO IT’s consulting costs.

  • Does CONSILIO have any idea if this is true.
  • Have they calculated a full TCO for ERP on HANA? A full ROI?
  • How do they know what they are writing is true or are they simply guessing. They should say.

The Real Story on MRP on HANA from a Research Entity Rather than Someone Trying to Sell HANA and S/4HANA Services

In the previous Brightwork article, How to Interpret the Performance Problems of MRP on HANA,

We covered the observations that have been coming in about how the many problems that have surfaced when running MRP on HANA.

Conclusion

CONSILIO IT is making some outlandishly false claims about MRP on HANA and most likely lying about the performance improvement that it “tested.” They both provide false information about HANA performance and then top it off by misunderstanding how supply and production planning works. The cherry on top is to further propose, falsely, that MRP run times are currently a problem at many companies that run ECC (something SAP also says, but did not seem to say back when they were selling ECC for some reason).

This is all standard practice. SAP or the SAP consulting company produces exaggerated claims that are tantalizing to buyers, who then bring in the consulting company only to be disappointed.

Everything piece of information provided here by CONSILIO is inconsistent with what we know about both supply chain planning and our research into HANA.

  • This article receives a 1 out of 10 for accuracy. Literally, nothing in it was true.
  • It is obviously a paid placement, and most the article is “written” by CONSILIO IT, and then simply released it through IT Daily.net.

SAP’s Inaccurate Messaging on S/4HANA as Communicated in SAP Videos

Fact-Checking SAP Information on S/4HANA

This video is filled with extensive falsehoods. We will address them in the sequence they are stated in this video.

SAP Video Accuracy Mesurement

Appleby's StatementAccuracy % of the CommentExplanationLink to Analysis Article
S/4HANA is what allows key processes to be digitized.
0%
ECC was already fully digitized and digitized across key business functions.The Problem with Using the Term Digital Transformation on IT Projects
HANA is a Platform
0%
HANA is not a platform, it is a database.How to Deflect You Were Wrong About HANA
Fiori is a major advantage for S/4HANA.
10%
In S/4HANA implementations Fiori is infrequently used when S/4HANA. How Accurate Was SAP on the Number of Fiori Apps?
Fiori is far more efficient than what came before.
10%
In testing Fiori and S/4HANA, Sven Deneken's statements did not hold up. There was a particular weakness in actually making changes after noticing something needed to be changed, and we found the efficiency below that of ECC with of course SAPGUI.
S/4HANA is innovative as it brings "real time inventory."
0%
Sven Deneken brings up the topic of "real-time capabilities," however there is nothing particularly real-time or different in terms of a reaction than ECC. Whenever you make a change in ECC or any other ERP systems for that matter, the entry is real-time. Sven Deneken states that "the physical inventory is the same as the digital inventory." However, under what system would this not be true?What Happened to the Term Perpetual Inventory?
S/4HANA is innovative because it allows access to supplier information.
0%
Sven Deneken states that information about the supplier is "just a fingertip away." Sven Deneken may be familiar with ECC, where supplier data is also a fingertip, or say mouse click away. It called the Vendor Master in ECC.
Sven Deneken says that the cycle could be changed to daily or sub-daily.
0%
Why would that occur? This is a very strange scenario that is being laid out.
S/4HANA is innovative because it allows MRP to be rerun interactively for a product location.
0%
Sven Deneken is extremely confused when he states that S/4HANA allows a fresh MRP run to be performed for a specific product location and that this is a differentiator for S/4HANA. For a single product location, there is no ERP system that cannot run MRP for a single location. Secondly re-running MRP does not remove uncertainties. MRP can be re-run when something changes. For example, when the forecast changes.Performance Problems with HANA and MRP
Sven Deneken states this demo shows SAP has reimagined inventory management.
0%
However, all of this functionality, save for several of the graphics shown in the video have already been available in ECC for many years, in fact, decades.

The Problem: A Lack of Fact-Checking of S/4HANA

There are two fundamental problems around S/4HANA. The first is the exaggeration of S/4HANA, which means that companies that purchased S/4HANA end up getting far less than they were promised. The second is that the SAP consulting companies simply repeat whatever SAP says. This means that on virtually all accounts there is no independent entity that can contradict statements by SAP.

Being Part of the Solution: What to Do About S/4HANA

We can provide feedback from multiple HANA accounts that provide realistic information around S/4HANA — and this reduces the dependence on biased entities like SAP and all of the large SAP consulting firms that parrot what SAP says. We offer fact-checking services that are entirely research-based and that can stop inaccurate information dead in its tracks. SAP and the consulting firms rely on providing information without any fact-checking entity to contradict the information they provide. This is how companies end up paying for a database which is exorbitantly priced, exorbitantly expensive to implement and exorbitantly expensive to maintain. When SAP or their consulting firm are asked to explain these discrepancies, we have found that they further lie to the customer/client and often turn the issue around on the account, as we covered in the article How SAP Will Gaslight You When Their Software Does Not Work as Promised.

If you need independent advice and fact-checking that is outside of the SAP and SAP consulting system, reach out to us with the form below or with the messenger to the bottom right of the page.

Financial Disclosure

Financial Bias Disclosure

Neither this article nor any other article on the Brightwork website is paid for by a software vendor, including Oracle, SAP or their competitors. As part of our commitment to publishing independent, unbiased research; no paid media placements, commissions or incentives of any nature are allowed.

S/4HANA Implementation Research

We offer the most accurate and detailed research into S/4HANA and its implementation history. It is information not available anywhere else and is critical correctly interpreting S/4HANA, as well as moderating against massive amounts of inaccurate information pushed by SAP and their financially biased consulting ecosystem.

Select the description that best matches you.

Option #1: Do You Work in Sales for a Vendor?

See this link for an explanation to sales teams.

Option #2: Do You Work for an Investment Entity that Covers SAP?

See this link for an explanation for investment entities. 

Option #3: Are You a Buyer Evaluating S/4HANA?

For companies evaluating S/4HANA for purchase. See this link for an explanation to software buyers

Search Our HANA and MRP Content

References

*https://ww2.cfo.com/applications/2017/11/armour-discloses-hiccups-sap-implementation/

https://investor.underarmour.com/directors.cfm

https://www.it-daily.net/it-management/erp-sap/12107-schnell-schneller-mrp-live

*https://www.amazon.com/SAP-Nation-2-0-empire-disarray-ebook/dp/B013F5BKJQ

The Real Story on ERP Book

ERPThe Real Story Behind ERP: Separating Fiction From Reality

How This Book is Structured

This book combines a meta-analysis of all of the academic research on the benefits of ERP, coupled with on project experience.

ERP has had a remarkable impact on most companies that implemented it. Unplanned expenses for customization, failed implementations, integration, and applications to meet the business requirements that ERP could not–have added up to a higher Total Cost of Ownership for ERP were all unexpected, and account control, on the part of ERP vendors — is now a significant issue affecting IT performance.

Break the Bank for ERP?

Many companies that have broken the bank to implement ERP projects have seen their KPIs go down— but the question is why this is the case. Major consulting companies are some of the largest promoters of ERP systems, but given the massive profits they make on ERP implementations — can they be trusted to provide the real story on ERP? Probably not, however, written by the Managing Editor of SCM Focus, Shaun Snapp — an author with many years of experience with ERP system. A supply chain software expert and well known for providing authentic information on the topics he covers, you can trust this book to provide all the detail that no consulting firm will.

By reading this book you will:

  • Examine the high failure rates of ERP implementations.
  • Demystify the convincing arguments ERP vendors use to sell ERP.
  • See how ERP vendors take control of client accounts with ERP.
  • Understand why single-instance ERP is not typically feasible.
  • Calculate the total cost of ownership and return on investment for your ERP implementation.
  • Understand the alternatives to ERP.

Chapters

  • Chapter 1: Introduction to ERP Software
  • Chapter 2: The History of ERP
  • Chapter 3: Logical Fallacies and the Logics Used to Sell ERP
  • Chapter 4: The Best Practice Logic for ERP
  • Chapter 5: The Integration Benefits Logic for ERP
  • Chapter 6: Analyzing The Logic Used to Sell ERP
  • Chapter 7: The High TCO and Low ROI of ERP
  • Chapter 8: ERP and the Problem with Institutional Decision Making
  • Chapter 9: How ERP Creates Redundant Systems
  • Chapter 10: How ERP Distracts Companies from Implementing Better Functionality
  • Chapter 11: Alternatives to ERP or Adjusting the Current ERP System
  • Chapter 12: Conclusion