Out of the various presentations I attended, the highlight was Chris Burns and Alan Cecchini of Newcastle University, presenting their project to move to the SAP HANA platform.<\/p>\n
The first phase is a migration of ERP, BW, CRM, and SRM from Oracle to SAP HANA without making any application changes except for some tuning.\u00a0The QA was completed in early May, and the system is due to go into production in early July.<\/p>\n
Some key quotes from the presentation:<\/p>\n
- \n
- Why SAP HANA:\u00a0“Faced with SAP HANA, Oracle have chosen to put their license prices up \u2014 turkeys do vote for Christmas!<\/em>“<\/li>\n
- On the project: \u201cThe project has been fairly simple so far \u2014 in comparison, the upgrade to NetWeaver 7.5, Unicode, and the BI upgrades were much harder than SAP HANA<\/em>\u201d<\/li>\n
- The success of the proof of concept:\u00a0“Yes, you heard me right \u2014 the POC\u00a0enthused a load of jaded analysts that had been in business for years \u2014 we\u2019re\u00a0not quite skipping to work, but there’s a certainly a\u00a0bit of Little House on the Prairie there\u2026 <\/em>“<\/li>\n
- On moving from Oracle to SAP HANA, “The basic level of compression, no archiving, no deletion, nothing special, made the basis manager (me) clap like a small child in a sweet shop!<\/em>“<\/li>\n
- On the business benefits: \u201cA lot! This is an amazingly slick product!<\/em>“<\/li>\n
- On building a business case: \u201cBig shout out to itelligence. They persuaded our CFO that this was the thing to do \u2014 wouldn\u2019t take the internal view alone, and it probably wouldn\u2019t be here today without their help.<\/em>” and\u00a0\u201cIf we tried to build a case for business value up front, we would have struggled \u2014 we\u2019re big fans of first getting the platform in, then getting the value over time”\u00a0<\/em><\/li>\n<\/ul>\n
Here are more details on the project, from\u00a0the presentation:<\/p>\n
Why does\u00a0Newcastle University want to move to HANA?<\/strong><\/p>\n
- \n
- Support for non-HANA Business Suite end in 2025 and next generation S\/4HANA only runs on HANA<\/li>\n
- SAP support for Oracle starts to decrease after 2017, and Oracle is increasing licence cost to 21%<\/li>\n
- Offers solutions to business process requirements we can’t currently meet: solutions to system growth and system complexity e.g. back-ups, BW chains, overnight batch job processing<\/li>\n
- To leverage Fiori, we need to be on HANA and hence S\/4HANA<\/li>\n
- Offers real-time information to support decision-making including big data analysis and predictive analysis: chance to change oru business processes<\/li>\n
- Simpler unified landscape and database layers, in time easier and cheaper to support<\/li>\n<\/ul>\n
Just moving the data from Oracle to SAP HANA \u2014 without any other changes \u2014 resulted in big storage gains: about 75% reduction, for both ERP and BW.<\/p>\n
![\"newcastle](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2016\/05\/newcastle-university-compression-comparison.jpg?resize=956%2C507&ssl=1\")
<\/a><\/p>\nOn average, the move to SAP HANA resulted in a 2x speed gain, without any changes, although some processes were slower before optimization. In order to test SAP\u2019s claims, such as “regardless of data volume and complexity, any question can be answered,\u201d the team did a series of comparison tests:<\/p>\n
Test 1: Confirmation and Clearing report — display applicant numbers for all courses for academic year 2015.<\/p>\n
- \n
- Benchmark — 2 mins 54s (1st run), then 22s on subsequent runs.<\/li>\n
- SAP HANA unoptimized — 57s (2.6x slower, one of the rare examples of slower speeds)<\/li>\n
- SAP HANA optimized code — 1s, 22x faster.<\/li>\n<\/ul>\n
Test 2: SAP ERP report \u2014<\/p>\n
- \n
- Benchmark: 8 mins 9s<\/li>\n
- HANA unoptimized: 4 mins 8s (2x faster)<\/li>\n
- HANA optimized: 1s (489x faster)<\/li>\n<\/ul>\n
Test 3: Data Feed, write all applicant records to file<\/p>\n
- \n
- Benchmark: 18 mins 24s<\/li>\n
- HANA unoptimized: 10 mins 57s<\/li>\n
- HANA optimized: 11s (100x faster — and nine seconds of that was network transport of data!)<\/li>\n<\/ul>\n
Test 4: BW on HANA<\/p>\n
- \n
- BW process chains ran much faster with a smaller technical footprint and offered the\u00a0opportunity to leverage real-time reporting.<\/li>\n<\/ul>\n
The team also looked at transforming the end user experience using SAP HANA and the Fiori interface.<\/p>\n
One example application allowed users to search for different elements. The application using native HANA search procedure, and required just 5 lines of code for a single dialog box regardless of type of item searched. This compared to 300 lines of code in Oracle, with multiple dialog boxes for different types of search.<\/p>\n
![\"newcastle](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2016\/05\/newcastle-University-fiori.jpg?resize=150%2C150&ssl=1\")
<\/a>\u00a0 \u00a0\u00a0![\"newcastle](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2016\/05\/newcastle-University-fiori-tiles.jpg?resize=370%2C149&ssl=1\")
<\/a><\/p>\nThe team also looked into the feasibility of using Fiori tiles and a real-time data push of data to show a real-time view of the student clearing process, showing the number of students accepted for different courses.<\/p>\n
Benefits that Newcastle University has got, or expects:<\/strong><\/p>\n
- \n
- Slick, relatively bug-free, product. For version 1.0 of a software product, its robustness is extraordinary<\/li>\n
- Significant compression of database size which means reduced system copy, patching\/iupgrade and backup times.<\/li>\n
- Data download BW chain times also reduced so our overnight schedule will be freed up<\/li>\n
- Faster processes, leading to possible \u201cjust do it\u201d running of jobs rather than batching them up overnight.<\/li>\n
- \n
HANA will enable real-time number crunching, allowing business\u00a0modeling, projections and predictions to take place on the fly.<\/p>\n<\/li>\n<\/ul>\n
Summary of expected SAP HANA benefits:<\/strong><\/p>\n
Faster<\/p>\n
- \n
- Improved productivity, freeing up user and system time<\/li>\n
- Better insight (e.g. data push\/event-driven scenarios)<\/li>\n<\/ul>\n
Simpler<\/p>\n
- \n
- Leaner solutions that are easier to build and maintain<\/li>\n
- Enhanced user experience leading ot improved sentiment adoption and engagement<\/li>\n<\/ul>\n
Cheaper<\/p>\n
- \n
- Projects delivered sooner as less admin\/dev\/test\/user effort<\/li>\n<\/ul>\n
Creating the Business Case<\/strong><\/p>\n
The team built a business case on \u201cspeeds and feeds\u201d, but with the idea that the released capacity could be used to do do innovation.<\/p>\n
- \n
- “Faster business processes alone wouldn\u2019t have been enough. The team had to show, through the proof of concept, that there was a strong possibility of reengineering business processes. Its fine to do things in less than one second, but what are people going to do with the rest of the eight minutes it used to take?”<\/li>\n
- “We shared what others had done \u2014 for example, the University of Kentucky was an early adopter, and had used it for interesting student retention and engagement projects.”<\/li>\n<\/ul>\n
\u00a0Other Highlights:<\/h3>\n
itelligence UK CTO\u00a0Andy Steer<\/a>\u00a0did a great presentation explaining the pragmatic steps the audience could take to get to S\/4HANA<\/p>\n
Two key slides caught my eye:\u00a0First, Andy explained that S\/4HANA is indeed new, but inevitable for SAP Customers, and not to be feared: “nobody expects\u00a0to run Microsoft Dynamics on Oracle, or Oracle eBusiness on DB2…”<\/p>\n
- Projects delivered sooner as less admin\/dev\/test\/user effort<\/li>\n<\/ul>\n
- BW process chains ran much faster with a smaller technical footprint and offered the\u00a0opportunity to leverage real-time reporting.<\/li>\n<\/ul>\n
- On the project: \u201cThe project has been fairly simple so far \u2014 in comparison, the upgrade to NetWeaver 7.5, Unicode, and the BI upgrades were much harder than SAP HANA<\/em>\u201d<\/li>\n
![\"preparation](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2016\/05\/preparation-for-s4hana.jpg?resize=608%2C319&ssl=1\")
<\/a>And that waiting to make a decision\u00a0is in fact a decision — to forego keycurrent and\u00a0future enhancements.<\/p>\n![\"no](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2016\/05\/no-decision-is-a-decision.jpg?resize=608%2C339&ssl=1\")
<\/a><\/p>\n