Sap Hana Essential-book

Table of Contents Copyright About the Cover Image Note from the Author Table of Contents Acknowledgments How to use this book Foreword Chapter 1: SAP HANA Overview Chapter 2: SAP HANA Architecture Chapter 3: SAP HANA Business Cases Chapter 4: SAP Business Suite Powered by SAP HANA Chapter 5: SAP NetWeaver Business Warehouse Powered by SAP HANA Chapter 6: Data Provisioning with SAP HANA Chapter 7: Data Modeling with SAP HANA Chapter 8: Application Development with SAP HANA Chapter 9: SAP HANA Administration & Operations Chapter 10: SAP HANA Hardware Chapter 11: SAP HANA Projects & Implementation Chapter 12: SAP HANA Resources The rest of the story… About the Author No part of this publication may be reproduced. including but not limited to. the SAP Logo. SAP has no obligation to pursue any course of business outlined in this material or to develop or release any functionality mentioned in this document.com. This material is not subject to your license agreement or any other agreement with SAP.Copyright © 2013 Epistemy Press LLC. BusinessObjects. SAP AG is neither the author nor the publisher of this publication and is not responsible for its content. recording. R/3. All other products mentioned in this book are registered or unregistered trademarks of their respective companies. Business Objects and the Business Objects logo. the implied warranties of merchantability. SAP. mechanical. except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act. Crystal Decisions. Xcelsius and other Business Objects products and services mentioned herein are trademarks or registered trademarks of Business Objects in the United States and/or other countries. scanning or otherwise. Epistemy Press LLC makes no warranties or representations with respect to the content and specifically disclaims any implied warranties or guarantees of merchantability. The author and publisher gratefully acknowledge SAP’s kind permission to use its trademarks in this publication. photocopying. This publication contains references to the products of SAP AG. please send a written request to info@epistemypress. stored in a retrieval system or transmitted in any form or by any means. Crystal Reports. either express or implied. SAP HANA and other SAP products and services mentioned herein are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. This material and SAP’s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. Web Intelligence. or non-infringement. fitness for a particular purpose. or non-infringement. This material outlines SAP’s general product direction and should not be relied on in making a purchase decision. For reproduction or quotation permission. SAP NetWeaver. fitness for a particular purpose. without either the prior written permission of the Publisher. ISBNs: 978-0-9856008-0-8 (ePub) 978-0-9856008-1-5 (Kindle) . SAP assumes no responsibility for errors or omissions in this document. and SAP Group shall not be liable for errors or omissions with respect to the materials. electronic. Epistemy Press LLC assumes no responsibility for any errors or omissions that may appear in the publication. This document is provided without a warranty of any kind. All rights reserved. In terms of SAP HANA. If you ever go visit SAP headquarters in Germany. this sign will immediately bring a smile to your face because you can step on the accelerator and drive as fast as you want to or as fast as your car can go (which ever comes first). .About the Cover Image The cover image is a European “No Speed Limit” sign. If you’ve ever driven on the Autobahn in Germany. we selected this image because SAP HANA allows your company to run at top speed with no artificial limit to how fast it can go. you’ll see this sign about 2 miles south of the Frankfurt airport on the A5 — and there’s no speed limit on your way to visit SAP. Just like SAP HANA is disrupting the status quo in the database world and breaking lots of ossified rules of the game.Note from the Author Since this book is about the shift to “real-time” business. Who says you have to wait till the whole book is written to release it? Who says you have to charge $$ for an extremely valuable book? Who says it has to be printed on paper with ink and sold in a bookstore? We’ve decided to break all those traditional publishing rules and release chapters as they are finished and then release the remaining chapters as they are completed later. it’s fitting that we’ve been writing this book in “real-time” and will be delivering it in “real-time”.com website when you register to download the ebook and keep watching saphana. that means that we can’t wait around for everything in the SAP HANA world to settle down and solidify before writing each chapter and expect everyone to hold their breath until the entire book is finished and ready to print. SAP HANA is moving extremely fast right now and you could be holding your breath for quite a while waiting for that day. Basically. . we’ll be doing much the same with this book. That’s pretty easy: Follow the book on twitter @EpistemyPress and @jeff_word. it’s important that readers keep connected to learn about the release of new chapters and content updates. sign up for the email updates from the saphanabook.com. And trust me. Since this is a “digitalonly” book. Fujitsu & NEC sections 11 SAP HANA Projects & Implementation Updated RDS section and new advice section 12 SAP HANA Resources . Huawei.Table of Contents 1 SAP HANA Overview Updated details 2 SAP HANA Architecture 3 SAP HANA Business Cases New Chapter 4 SAP Business Suite Powered by SAP HANA (NEW) 5 SAP NetWeaver Business Warehouse Powered by SAP HANA (NEW) 6 Data Provisioning with SAP HANA 7 Data Modeling with SAP HANA 8 Application Development with SAP HANA (NEW) 9 SAP HANA Administration & Operations 10 SAP HANA Hardware Updated PAM. Nadav Helfman. Ralf Czekalla. John Appleby (Bluefin). KaiGai Kohei (NEC). Si-Mohamed Said. Holger Fischelmanns. Chris March (Hitachi) Production Robert Weiss (Development Editor) Roland Schild. Ron Silberstein. Lothar Henkes. Thomas Zureck. Many thanks to all of you for your support and collaboration. Michael Erhardt. — Jeff SAP Colleagues Margaret Anderson. Gigi Read. Michael Rey. Steve Thibodeau SAP Mentors Thomas Jung (SAP). Naren Chawla. Wolfram Kleis. Gunther Liebich. Adolf Brosig. Roland Kramer. Vitaliy Rudnytskiy (HP). Daniel Rutschman. David Porter. Bill Lawler. Balaji Krishna. Amit Sinha. Jason Lovinger. Daniela Geyer. Ben Gruber. David Hull. Markus May (Libreka/MVB) Michelle DeFilippo (1106 Design) . Prasad Ilapani. Tag Robertson (IBM). Nathan Saunders (Dell). Mike Eacrett. Scott Shepard. Kathlynn Gallagher. Vijay Vijayasankar (IBM). Arne Arnold. Andrea Neff. Storm Archer. Uddhav Gupta. Lori Vanourek. David Jonker. Their support has been invaluable and many more people will be involved as the book progresses. Markus Fath. content preparation and reviewing of this book. Bhuvan Wadhwa. Puneet Suppal.Acknowledgments Although we’re at the beginning of this journey. Harald Reiter (Deloitte). Oliver Mainka. Tammy Powlas (Fairfax Water). Craig Cmehil (SAP). Andrea Voigt (Fujitsu). many people have already been phenomenally helpful in the scoping. Kijoon Lee. Lucas Kiesow. Scott Leatherman. Johannes Beigel. Alvaro Tejada (SAP) SAP Partners Lane Goode (HP). Rick Speyer (Cisco). In fact. but in many ways. SAP HANA is a rapidly evolving product and its level of importance to SAP customers will continue to increase exponentially over the next several years. its content is necessarily broad and not-tootechnical. SAP felt that every customer and ecosystem partner should have free access to the essential information they will need to understand SAP HANA and evaluate its impact on their future landscape. Given the massive strategic impact of SAP HANA on the medium and long-term IT architectures of its customers. We’re working on several Level 2 technical books on SAP HANA and are committed to providing as much technical and business content as possible through the Experience SAP HANA website and other channels. but will provide easy links to Level 2 technical content to continue learning about the various sub-topics in more detail. Although a great deal of this book focuses on “living in a world without compromises” from a technology and business perspective. We’ve also tried to cover as many of the high-level concepts as possible and provide copious links to deeper technical resources for easy access.How to use this book “May you live in interesting times” This book is designed to provide an introduction to SAP HANA to a wide range of readers. Please refer to the last chapter to get a listing of additional free information sources on SAP HANA. from Clevel executives down to entry-level coders. The content is structured so that everyone can begin with the introduction chapter and then skip to the subsequent chapters that most interest them. SAP sponsored the writing of this book and has funded its publication as a free ebook to ensure that everyone can easily access this knowledge. The knowledge you will find in this book is the first step on the journey to becoming a real-time enterprise. Business people will likely skip to the applications and business case chapters while techies will jump ahead to the application development and hardware chapters. We’ve tried to make this book as easy to read as possible to ensure that every reader can understand the concepts and get comfortable with the big picture of SAP HANA. We will attempt to provide updated . it would probably be odd if anyone actually read this book from beginning to end (but go ahead if you want to). we’ve unfortunately had to make a few compromises in the scope and depth of the content in order to reach the widest possible audience. This book should be the first thing everyone reads about SAP HANA. As such. If we hadn’t. this would be a 10. it is just the “tip of the iceberg”.000-page encyclopedia that only a few hundred people would ever read. Hopefully. you will enjoy reading the chapters and find it quite easy to “punch out” to additional technical information as you go regardless of your level of technical knowledge or business focus. editions of this book on a semi-annual basis to ensure that you can easily access the most up-to-date knowledge on SAP HANA. Please continue to visit the SAP HANA Essentials website to download updated and revised editions when they are released (typically in May and November of each year). . You can also follow @EpistemyPress on Twitter for updates. its sound indistinguishable from that produced by factory-built flutes of yesterday. food and musical instruments. I believe that information technologies. Physical books and the bookstores they inhabited have been rapidly disappearing. it reached almost a million of the 1. During the American Revolution. By putting 3000 songs in our pockets.Foreword By Vishal Sikka. connecting and acting in real-time — whether it is to stage uprisings or rent apartments. Some of the most visible recent examples of this dissolving of layers are the transformations we have seen in music. Executive Board Member. A recent issue of the Economist described Martin Luther’s use of social networking. Within a single year. Thomas Paine published his Common Sense manifesto on a derivation of the Gutenberg press. the iPod liberated our music from the housings that confined it. empower and renew us and serve to amplify our reach and our abilities. movies and books. The capabilities and services provided by workshops and factories are now embodied within a printer that can print things like tools and accessories. along with a bunch of services for sharing. from India to Greece — individuals whose voices were amplified and aggregated by modern technology and its unprecedented power to connect and empower us. layers of inefficiency got dissolved. distributing and publishing pictures. and helped seed democracy and America’s birth. especially well-designed. in more consumable ways. The iPhone has a highdefinition camera within it. more modular vessels. Yet there is more music than ever before. But social networking is not new.5 million residents of the 13 American colonies — about two-thirds of the populace. A remarkable musical flute was printed recently at MIT. Their content got separated from their containers and got housed in more convenient. which better tie into our lives. and uses this connectivity to bypass the intermediaries and get straight at the things it seeks. 3D printing is an even more dramatic example of this transformation. especially the Gutenberg press. now approaching 800 million users (more than 10% of humanity). phonograph records. SAP AG Time magazine picked “The Protester” as its person of the year for 2011. purposeful ones. The ensuing connectedness dissolves away intermediary layers of inefficiency and indirection. even editing them — services that used to be inside darkrooms and studios. An empowered populace gets more connected. are often viewed as the harbinger of social networking. more books and more movies. Ph. plan travel or . I see layers of inefficiency dissolving all around us. recognition of individuals who spoke up around the world — from the Arab countries to Wall Street. as have physical compact discs. to start the Protestant Reformation. In the process. videotapes and the stores that housed them.D. Twitter and Facebook. In reality. we have been engaged in such rethinking. this happens now in 2 seconds — a performance improvement of over 100. we delivered SAP Business Warehouse on SAP HANA. can enable more than 1 billion people on the planet to interactively explore their energy consumption based on real-time information from their energy meters and appliances. and our customers are starting to see its results. and take control of their . delivering fundamental improvements in performance and simplification. for the last several years. is driven by an in-memory product called SAP HANA which. cloud computing. the Essar Group. Thus a complex question can be posed to real-time operational data. based on the purchases she is about to make. across a company’s lines of businesses. Today’s machines can bring large amounts of main-memory. And it scales simply with addition of more processors or more blades. Nongfu Spring. At SAP. and consequently that of our customers. Customers like Colgate-Palmolive. and the business consequences are radical. a large Japanese retailer. SAP HANA also integrates text processing with managing structured data. It is time for a rethink. and lots of multi-core CPUs to bear on massively parallel processing of information very inexpensively. and across application types. While this architecture is vastly disruptive to a traditional relational database architecture. and our principle of delivering innovation without disruption. elastically-scalable hardware infrastructure: a grand dissolving of the layers of complexity in enterprise landscapes. Looking ahead.000 times. as the transaction unfolds. and can be delivered as appliances. By my estimate. Thus various types of applications. together with mobility. is helping to radically simplify enterprise computing and dramatically improve the performance of businesses without disruption. SAP HANA brings these benefits non-disruptively. instead of asking pre-fabricated questions on pre-aggregated or summarized data. SAP HANA was designed from the ground-up to leverage this. The empowered store-manager can determine these at the point of sale. without disruption. or intellectual renewal. a complete removal of the traditional database underneath. this re-bundling increases the clutter that already exists in enterprise landscapes. as our chairman and cofounder Hasso Plattner challenged me. in a single system. And in Fall 2011. At Yodobashi. to our customers it brings fundamental innovation without disruption. while the customer is in a store. The incentive for a customer can be calculated on the fly. without forcing a modification of existing systems. are the unprecedented applications that are now within our reach. have seen performance improvements of thousands to tens of thousands times. And yet enterprises have been far too slow to benefit from such renewal and simplification that is pervading other parts of our lives. Even more exciting. SAP HANA achieves this simplification by taking advantage of tremendous advances in hardware over the last two decades. I expect that we will see lots of amazing improvements similar to Yodobashi’s. Provimi. our own SAP IT and many others. This renewal of SAP’s architecture. Charmer Sunbelt. But even more important is the opportunity to rethink business processes. The IT industry has focused on too much repackaging and reassembly of existing layers into new bundles. edit pictures or consume apps by the millions. once a month. can all be run off a single. private or public clouds. a cloud of approximately 1000 servers of 80-cores and 2 terabytes of memory each. SAP HANA hardware is built by various leading hardware vendors from industry standard commodity components. With SAP HANA. ostensibly to lower the costs of integrated systems.author books. With SAP HANA. SAP HANA provides a single in-memory database foundation for managing transactional as well as analytical data processing. and business processes are being rethought. batch processing is converting to real time. the calculation of incentives for loyalty customers used to take 3 days of data processing. based on our instincts as well as our analysis. combined with mobility and cloud-based delivery. can similarly be made truly dynamic. SAP HANA. Vishal Sikka is a member of the Executive Board of SAP AG and heads the technology and innovation areas. And it is this empowerment and renewal. The possibilities are endless. Just as the iPod put our entire music libraries in our pockets. Dr. mining vast amounts of data as needed. healthcare. . One of our customers in Japan is working on using SAP HANA to analyze genome data for hundreds of patients each day. driven by purposeful technologies. To re-think our solutions to solving existing problems — and to help businesses imagine and deliver solutions for previously unsolved problems. something that was impossible before SAP HANA. The management and optimization of their finances. Banks can manage risks in real-time. Empowering us to take actions in real time. communications. entertainment and other activities. and healthcare companies can analyze vast amounts of genome data in real time.energy management. Another customer is using SAP HANA to determine optimal routes for taxicabs. Airlines and heavy machinery makers can do predictive maintenance on their machines. insurance. oil companies can better explore energy sources. that continually brings us all forward. enables us to take our entire business with us in our pocket. The IT Industry: A History of Technology Constraints Throughout the history of the IT industry. each version of Adobe Photoshop was designed to maximize the most current hardware resources available to achieve the optimal performance. and so on — is released. SAP HANA is disrupting the technology industry in much the same way that Amazon and Apple have disrupted the publishing industry. the capabilities of applications have always been constrained to a great degree by the capabilities of the hardware that they were designed to run on. which is a massively disruptive innovation for the positively ancient publishing industry. That is — until Amazon and Apple came along and digitized the production. To understand this point. Today. The book industry has operated under the same basic rules since Gutenberg mechanized the production of books in 1440. For example. more capable generation of hardware — processors. but the basic processes of writing a book. memory. and reading it remained largely unchanged for several hundred years. and consumption of books. This technology represents an overwhelming assault of disruptive innovation on a 500+ year-old industry in less than 5 years. storage. These companies are also starting to revolutionize the writing of books by providing new authoring tools that make the entire process digital and paper-free. primarily in the distribution chain. SAP HANA is one of those massively disruptive innovations for the enterprise IT industry. There were a few subsequent innovations within the industry. distribution. Rendering a large image in Photoshop 10 years ago could take several hours on . The rules might be adjusted from time to time as the industry matures. where a more capable version of an application is released shortly after a newer. but the general rules stay basically the same — unless some massive disruption occurs that changes the rules or even the entire game. This explains the “leapfrogging” behavior of software and hardware products. printing it. Before we discuss how this happens. consider that you’re probably reading this book on an e-reader. we need to consider a few fundamental rules of that industry.Chapter 1 SAP HANA Overview “Significant shifts in market share and fortunes occur not because companies try to play the game better than the competition but because they change the rules of the game” — Constantinos Markides1 Every industry has a certain set of “rules” that govern the way the companies in that industry operate. Eventually. Rather. even on a low-end PC. Enterprise software has operated on a very similar model. however. The problem wasn’t that the servers lacked sufficient processing power. and so on. the application could use whatever processing power was in the mainframe. the bottleneck associated with obtaining data from the disk wasn’t getting better. The transactional data — known as online transaction processing. Each transactional record by itself doesn’t contain very much data. To resolve this problem. If you wanted more power. until the transaction was completed and the record was updated for the last time. you had to buy a bigger mainframe. Basically. the app would read a bit more data from the database. the system still had a single database server. even though servers were getting faster and more powerful (and cheaper). the requests from the application servers got stuck in the same input/output (IO) bottleneck trying to get data in and out of the database. the system must read multiple tables in the database all at once and then sort the data into reports. This bottleneck was even more pronounced when it came to reporting data. all of the software — specifically. This arrangement would free up resources for the transactional system to focus on processing transactions. When you have to run a report across every transaction in a process for several months. which would then get dumped into the reporting system. as more users performed more activities on the system. The transactional data from the application and the data used for reporting were physically stored in the same system. and that was it. when run on current hardware. it was producing more and more data. As more processes in the company were being automated in the transactional system. Unfortunately. To create reports. it was actually getting worse. The major advantage of this architecture was that. Despite these innovations. you could either process transactions or process reports. and database — was designed to maximize the hardware resources located inside the mainframe as a contained system. in fact. or OLTP — from documents such as purchase orders and production orders were stored in multiple locations within the database. but you couldn’t do both at the same time or you’d kill the system. you start dealing with huge amounts of data that have to be pulled through a very slow “pipe” from the database to the application. the latest version. however. Because . the ever-increasing requests for data from so many application servers began to crush even the largest database servers. In the early days of mainframe systems. Consequently. Unfortunately. so transmitting data from that server to all the application servers and back again created a huge performance bottleneck. The Database Problem: Bottlenecks When SAP R/3 came out in 1992. This process requires the system to pull a massive amount of data from the database. it was designed to take advantage of a new hardware architecture — client-server — where the application could be run on multiple.the most powerful PC. which essentially prevents users from doing anything else in the system while it’s generating the report. SAP engineered quite a few “innovative techniques” in their applications to minimize the number of times applications needed to access the database. the user would input more data. In contrast. each additional database operation continued to slow down the entire system. relatively cheap application servers connected to a larger central database server. To address this problem. you could just add a few additional application servers to scale out application performance. operating system. can perform the same task in just a couple of seconds. the applications. The application would read a small quantity of data when the purchasing screen was started up. companies began to build separate OLAP systems such as SAP NetWeaver Business Warehouse to copy the transaction data over to a separate server and offload all that reporting activity onto a dedicated “reporting” system. to be answerable for all of their financial transactions. Both the volume of data and the volume of users requesting data were now growing thousands of times faster than the improvements in database I/O. SAP had also just released SAP NetWeaver 2. as the number of requests increased.the reporting system contained more. The objective was to enable their customers to leverage the full capabilities of their investment in SAP while avoiding the data latency issues. Fast forward a few years. Having become aware of this issue. You can see how this vicious (or virtuous) cycle can spin out of control quickly. These requirements increased the pressure on already stressed systems to analyze more data more quickly. in 2004 SAP initiated several projects to innovate the core architecture of their applications to eliminate this performance bottleneck. It was around this time that two other key factors were becoming more significant: (1) internet use and the proliferation of data from outside the enterprise. generated by laws such as SarbanesOxley. Looking forward. broader data about the company’s operations. Of course. more people wanted to use the data. as the amount of operational data in the SAP NetWeaver Business Warehouse database increased exponentially. and now the acquisitions of Business Objects and Sybase were generating another exponential increase in demands for data from both the transactional and analytic databases from increasing numbers of analytics users and mobile users. which in turn generated more requests for reports from the database under the reporting system. Similarly. The Solution: In-Memory Architecture This is the reality that SAP was seeing at their customers at the beginning of the 2000’s. and (2) the regulatory pressures on corporations. the greater the number of users. The Beginnings: LiveCache and SAP BWA When SAP introduced Advanced Planning Optimizer (APO) as part of its supply chain management . SAP could see this trend becoming even more widespread and the bottleneck of the database slowing things down more and more. which added extensive internet and integration capabilities to its applications. Because disk I/O has been a performance bottleneck since the beginning of three-tier architecture. so did the number of requests for reports. the first step in the transition to a new in-memory architecture for enterprise applications and databases. the quantities of data that had to be pulled correspondingly increased. the greater the number of application servers that flooded the database with requests. The SAP projects resulted in the delivery of SAP HANA in 2011. SAP NetWeaver added many new users and disparate systems that talked to the applications in the SAP landscape. The timing couldn’t have been better. SAP’s initial in-memory technologies were used for very specific applications that contained complex algorithms that needed a great deal of readily accessible data. SAP R/3 had been hugely successful. and customers were generating dramatically increasing quantities of data. SAP was concerned that customers who had invested massive amounts of time and money into acquiring and implementing these systems to make their businesses more productive and profitable would be unable to get maximum value from them. Again. SAP’s Early In-Memory Projects SAP has a surprisingly long history of developing in-memory technologies to accelerate its applications. SAP HANA flips the old model on its head and converts the database from the “boat anchor” that slows everything down into a “jet engine” that speeds up every aspect of the company’s operations. So. SAP has constantly searched for ways to avoid or minimize the performance penalty that customers pay when they pull large data sets from disk. SAP held some senior-level meetings with Intel to formulate a joint-engineering project to optimize Intel’s new dual-core chips to natively process the SAP operations in parallel. In 2005. Eventually. At the same time. thereby increasing performance exponentially. sometimes even days. Since that time the two companies have continuously worked together to optimize every successive generation of chips. LiveCache keeps a persistent copy of all of the relevant application logic and master data needed in memory. a team in SAP’s headquarters in Waldorf. their bosses asked them to apply the same technique to a much more imposing problem: the data from a SAP BW cube. the team discovered how to package Euclid into a stand-alone server that would sit next to the existing SAP BW system and act as a non-disruptive “turbocharger” for a customer’s slow SAP BW reports. When this technology became operational. SAP MaxDB (called SAP DB at the time). or BWA) BWA has since evolved into one of SAP’s best-selling products. Even more importantly. Basically. LiveCache worked extremely well. SAP solved this problem in 1999 by taking some of the capabilities of its open-source database. Intel immediately sent a team to SAP headquarters to begin the optimization work. TREX scans the tables in a database and then creates an index of the information contained in the table. SAP launched the product SAP NetWeaver Business Intelligence Accelerator. the success of BWA proved to SAP and its customers that in-memory data processing just might be an architectural solution to database bottlenecks. began to productize a specialized search engine for SAP systems called TREX (Text Retrieval and information EXtraction). The only remaining solution was to eliminate the bottleneck itself. Thus. SAP decided to take the next big . in fact. it clearly demonstrated that in-memory caching could solve a major latency issue for SAP customers. and built them into a memoryresident cache system called SAP LiveCache. Germany. The Next Step: The Tracker Project Once the results for BWA and LiveCache began to attract attention. it represented another successful use of in-memory. Along with LiveCache. That is.application in the late 1990s. the TREX team came up with the idea of putting the entire index in the RAM memory of the server to speed up searches of the index. Cubes are the basic mechanism by which SAP BW stores data in multidimensional structures. the TREX team devised a strategy to eliminate the database from the equation entirely by indexing the cubes and storing the indexes in high-speed RAM. it processed data 600 times faster than disk-based I/O. In the best spirit of disruptive innovators. Because the index is a tiny fraction of the size of the actual data. the logistics planning algorithms required a significant speed boost to overcome the disk I/O bottleneck. These algorithms — some of the most complex that SAP has ever written — needed to crunch massive amounts of product. and logistics data to produce an optimal supply chain plan. Running reports on very large cubes (>100GB) was taking several hours. Within its narrow focus. (The company subsequently changed the name to SAP NetWeaver Business Warehouse Accelerator. At that time. BWA solved a huge pain point for SAP customers. The SAP BW team had done just about everything possible in the SAP BW application to increase performance. or BIA. Initial results for Euclid were mind-blowing: The new technology could execute query responses for the same reports on the same data thousands of times faster than the old system. but had run out of options in the application layer. many of the larger SAP BW customers were having significant performance issues with reports that were running on large data cubes. In 2003. however. thus eliminating the need to make multiple trips back and forth to the disk. with one of the highest customer satisfaction ratings. production. Project Euclid was born. TREX approached enterprise data in much the same way that Google approaches internet data. Shortly after achieving this milestone. Because the new SAP database was in an early experimental stage and the final product could seriously disrupt the market. The Tracker team was composed of the TREX/BWA engineers. the Tracker team passed its primary performance and “reality check” goal: the SAP Standard Application Benchmark for 1000 user SD two-tier benchmark with more than 6000 SAPs. SAP quietly acquired Callixa and P*time (as well as a couple of other specialist database companies). The researchers examined the prototypes from the Tracker team — now called NewDB — and added some valuable external perspectives on how to mature the technology for enterprise applications. In early 2006. To put that in perspective. and put them to work with the Tracker team. in 2005.” even to SAP employees. the Tracker Project was strictly “Top Secret. the SAP ERP performance optimization and benchmarking gurus. In the mid-1990s. Using memory as a cache to temporarily store data or storing indexes of data in memory were key innovations. Basically. Two of the Stanford researchers went on to found companies to commercialize their research.step and determine whether it could run an entire database for an SAP system in memory. but eliminating the disk completely from the architecture takes the concept to an entirely different level of complexity and introduces a great deal of unknown technical issues into the landscape. hired several of the most distinguished database geniuses on the planet. The team completed the porting and verification of the in-memory database on a server with 64gb of RAM. Suddenly. The result was the Tracker Project. As we’ll see later. a few of the key architects from the SAP MaxDB open-source database team. SAP began an academic research project to experiment with the inner workings of in-memory databases with faculty and students at the Hasso Plattner Institute at the University of Potsdam in Germany. One product was a database query optimization tool known as Callixa. and the other was a native in-memory database called P*Time. SAP decided to build a skunkworks project to validate and test the idea. which was the maximum supported memory at the time. several researchers at Stanford University had performed the first experiments to build an in-memory database for a project at HP Labs. this undertaking is a lot more complicated than it sounds. In late 2005. an entirely new world of possibilities had opened up for SAP to fundamentally change the rules of the game for database technology. the key engineers who built LiveCache. Passing the benchmark in such a short time with a small team — in total secrecy — was a truly amazing feat. the team was an all-star lineup of everyone inside and outside SAP who could contribute to this “big hairy audacious goal” of building the first in-memory database prototype for SAP (the direct ancestor of SAP HANA). which essentially matched the performance of the two leading certified databases at the time. it took Microsoft several years of engineering to port Microsoft SQL to SAP and pass the benchmark the first time. and several database experts from outside the company. less than four months after the start of the project. Therefore. . SAP also had to . To make the transition as painless as possible for its customers. SAP embarked on a “bullet-proofing” effort to evolve the “project” into a “product”. SAP announced the first live customers on SAP HANA and that SAP HANA was now generally available. Not only did these revelations shock the technology world into the “new reality” of in-memory databases. SAP’s supervisory board chairman and chief software advisor. Different Game. SAP also introduced the first SAP applications that were being built natively on top of SAP HANA as an application platform. announced SAP’s vision for delivering an entirely in-memory database layer for its application portfolio. In addition to all the technical challenges of building a completely new enterprise-scale database from scratch on a completely new hardware architecture. This development sent shockwaves throughout the data warehousing world because almost every SAP NetWeaver Business Warehouse customer could immediately 3 replace their old. disk-based database with SAP HANA. What made this new architecture especially attractive was the fact that SAP customers did not have to modify their current systems to accommodate it. but they initiated a massive shift for both SAP and its partners and customers into the world of “real-time business”. In November 2011.3 to be a non-disruptive innovation. it’s probably worth watching again. It’s Professor Plattner at his best. SAP had renovated this software so that it could run natively on top of SAP HANA. Different Rules: SAP HANA One year later. SAP designed Business Warehouse 7. In May 2010. Hasso Plattner.However. it’s worth watching. So. If you saw it when he delivered it. passing a benchmark and running tests in the labs are far removed from the level of scalability and reliability needed for a database to become the mission-critical heart of a Fortune 50 company. If you haven’t seen his keynote speech. Innovation without Disruption Clay Christensen’s book The Innovator’s Dilemma was very popular reading among the Tracker team during the early days. SAP achieved another milestone when it released SAP Business Warehouse 7.3. for the next four years. occurs because people have to wait while their information systems process the relevant data. In essence. For example. with the senior IT leadership of several of SAP’s largest customers to obtain insights concerning the types of concerns they would have about such a monumental technology shift at the bottom of their “stacks. the entire “stack” needed to run a Fortune 50 company is maddeningly complex. manufacture their products more efficiently. having to wait several minutes or several hours or even several days to obtain an answer from your SAP system is a primary contributor to process latency.” As we discussed earlier. Making that business case involved much more than just the eye-catching “speeds and feeds” from the raw technology. often have to do a lot of “waiting” both during and between the various process steps. At its core. Why does it take one company twice as long as its competitor to complete the same process? What factors contribute to that additional “process latency”? The answers lie in the reality that the software is simply the enabler for the execution of the business process. sell their products more effectively. So.” The customers provided some valuable guidelines for how SAP should engineer and introduce such a disruptive innovation into their mission-critical landscapes. It had to enabled them to track their inventory more accurately. Slow-performing systems force people to take more time to complete their jobs.be very thoughtful about how its customers would eventually adopt such a fundamentally different core technology underneath the SAP Business Suite. under NDA. while its primary competitor accomplishes this task in 5 days — even though both companies are using the same SAP software to manage the process. Much of it. both inside and outside the company. The people who have to work together to complete the process. and they result in less effective use of all the system’s capabilities. Clearly. however. it also had to reduce the complexity and costs of managing the landscape for the IT department. you first have to focus on WHAT the entire system has to do for the business. At the same time. such as lunch breaks or meetings. SAP’s senior executives made the team’s primary objective the development of a disruptive technology innovation that could be introduced into SAP’s customers’ landscapes in a non-disruptive way. The team spoke. They realized that even the most incredible database would be essentially useless if SAP’s customers couldn’t make the business case to adopt it because it was too disruptive to their existing systems. SAP’s customers would switch databases only if the new database was minimally disruptive to implement and extremely low risk to operate. however. It also discourages people from using the software frequently or as it was intended. SAP would have to build a hugely disruptive innovation to the database layer that could be adopted and implemented by its customers in a non-disruptive way at the business application layer. to engineer a new technology architecture for a company. Unfortunately. The old saying that “time is money” is still completely true. To accomplish this difficult balancing act. and “latency” is just a nice way of saying “money wasted while waiting. latency is a bad thing. the new SAP database architecture was created to help users run their business processes more effectively4. Both of these factors introduce latency into process execution. and purchase materials economically. however. there’s an even darker side to slow . Some of that waiting is due to human activities. one public company might require 10 days to complete its quarterly closing process. every business process in a company has some amount of “latency” associated with it. Today. The Business Impact of a New Architecture When viewed from a holistic perspective. Geoffrey Moore has some great thoughts on how gamechanging technologies “cross the chasm. None of the existing database vendors had any incentive to change the status quo (see The Innovator’s Dilemma for all the reasons why). cheaper model perfectly. Cheaper There’s another fundamental law of the technology industry: Faster. simpler. companies that employ in-memory systems are operating in “real time. when you compare the total cost of ownership (TCO) of in-memory databases. That is. hybrid row/column store. and expensive database. among other things. The Need for Business Flexibility In addition to speeding up database I/O throughput and simplifying the enterprise system architecture.” He maintains. However. Faster. and much cheaper to acquire and operate.systems. In addition. when you compare the cost of an in-memory database to that of a diskbased database on the appropriate metric — cost per gigabyte per second — in-memory is actually cheaper. I/O is hundreds to thousands of times faster on RAM than on disks. and SAP couldn’t afford to sit by and watch these problems continue to get worse for their customers. and cheaper are fundamental characteristics that must be present for a successful product introduction. and ease of operations. SAP released their service-oriented architecture. The only way out of this dilemma was for SAP to innovate around the database problem entirely. inflexible. new processes were springing up too fast to count. or customers won’t purchase it. and adapt their core business processes to reflect their rapidly changing business needs. that faster. In-memory computing fits the faster. Cheaper. Finally. better. more flexible. It was one of those impossible challenges that engineers and business people secretly love to tackle. tighter integration with the apps. In 2003. and the information they need to make more intelligent decisions is instantly available at their fingertips. once you remove all of the latency from the systems. SAP NetWeaver. workarounds can seriously compromise data quality and integrity. better. users can focus on eliminating the latency in the other areas of the process. Also. better. Better. none of that flexibility was going to benefit their customers if the applications and platform that managed those dynamic business processes were chained to a slow. The effort and costs spent on “inventing” workarounds to the performance limitations of the system waste a substantial amount of institutional energy and creativeness that ideally should be channeled into business innovation. SAP also had to innovate in a third direction: business flexibility. cloud applications. each new generation of product or technology has to be faster. Better. SAP had become adept at automating “standard” business processes for 24 different industries globally. Mobile devices. extend. SAP’s customers needed a huge amount of flexibility to modify. Over the years. As we have discussed. the major benefits of in-memory storage are that users no longer have to wait for the system. In-memory databases are a better architecture due to their simplicity. SAP needed to engineer a breakthrough innovation in inmemory databases to build the foundations for a future architecture that was faster. and it couldn’t have been more critical to SAP’s future success. and cheaper than the generation it is replacing. Thus.” Significantly. they invent workarounds to avoid the constraint. and began to renovate the entire portfolio of SAP apps to become extremely flexible and much easier to modify. It’s like shining a spotlight on all the problem areas of the process now that the system latency is no longer clouding up business transparency. however. When businesspeople can’t use a system to get a quick response to their questions or get their job done when they need to. Despite this progress. and big data scenarios were creating a whole new set of business possibilities for customers. There’s really no comparison in how rapidly you can get memory off a database in RAM than off a database on disk. they’re . and. Significantly. which it redesigned as a touch-screen interface (hence the name iPod Touch). but it was so phenomenally better and cheaper per megabyte (even at $399) that it became a category killer. most importantly. . and Apple was selling millions of units of its most current version of the “classic” iPod. Apple had to make several architectural compromises to squeeze that hard drive into the iPod. at a time when most other MP3 players could hold only ~64mb of music in flash memory. in 2001 people had been thrilled with 5gb of storage. and a sufficient amount of storage. When Apple introduced the iPod in 2001. In 2007. which contained 160gb of storage. 5gb of disk for roughly the same price as 64mb of RAM was a huge difference.” Otherwise. for several reasons. Apple could build an iPod with 16gb of solid-state RAM storage — which was only one-tenth of the capacity of the current hard drive model — for the same price as the 2001 model. First. more powerful processor in the device. it created more room for a bigger motherboard and a larger display. But faster. In fact. a disappointingly short battery life. eliminating the physical hard drive more than doubled the battery life since there were no more mechanical disks to spin. the new model sold at the same price as the original. It was the shift to solid-state memory as the storage medium for iPods that really changed the game for Apple. because they could download their entire CD collection onto the iPod. If you really look at what the switch from an “old” platform to a “new” platform can do for overall usability of the solutions on top of the platform. Removing the hard drive and its spinning disks had a huge impact on Apple’s design parameters. cheaper is even more important than just the raw technology. In addition to the vastly expanded storage capacity. By this time. Despite these limitations. long battery life. Apple could now turn the entire front of the device into a display. the iPod was still so much better than anything else out there it soon took over the market. better. The physics needed to spin a hard disk drained the battery very quickly. It wasn’t significantly faster than its competitors. Moore’s law had been in effect for four full cycles and 16gb of memory cost about the same as a 160gb hard drive. First. so the cost per megabyte per second calculation wasn’t terribly relevant. it enabled the company to shrink the thickness and reduce the weight of the iPod. it revolutionized the way that people listened to music. In addition. The key innovation was that Apple was able to fit a tiny 1. Meanwhile. Hard drives had become so enormous that nobody had enough music to fill them.8-inch hard drive into its small case so you could carry 5gb of music in your pocket. however. By that measure. 32 times more than the original 5gb model. the hard drive took up most of the case. These innovations essentially transformed a simple music player into a miniature computer that you could carry in your pocket. Most importantly. the newer model was similar to the original in most ways. however.even more economical to operate than traditional databases due to the reduction of superfluous layers and unnecessary tasks. It had an operating system. audio and video capabilities. There was a tiny monochrome display. there are some amazing possibilities. In hindsight. even though it wasn’t the first MP3 player on the market. Take the ubiquitous iPod for example. the storage capacity of the hard drive was no longer such a big deal. a fairly weak processor. Fast-forward six years. Inserting a bigger motherboard in turn allowed Apple to insert a larger. however. Apple had added a color screen and a pressure-sensitive “click wheel. leaving very little room for anything else. making it easier to carry and store. (This is a classic illustration of “changing the rules of the game. In fact. Apple could also build another model with nearly all of the same parts that could also make phone calls.”) I/O speed wasn’t a significant concern for playing MP3s. a clunky mechanical “click wheel” user interface. Going even further. but do you know . Apple still makes and sells the “classic” iPod (160gb/$249). better. SAP is convinced that SAP HANA represents a similar architectural shift for its application platform. will encourage the development of a new breed of business applications that are built natively to exploit this new platform. Once a large number of people began to carry a computer around in their pocket. eventually. SAP also believes that this new architecture. and cheaper architecture. Although Apple couldn’t have predicted the success of games like “Angry Birds. and. back to the memory-as-storage paradigm that the portable music player market had started with. iPhone. it only made sense that developers would build new applications to exploit the capabilities of the new platform. Eliminating the disk-based database will provide future customers with a faster. getting rid of the hard drive in the iPods was the most critical technology decision Apple made to deliver the iPod Touch. Although this might seem like an obvious choice in retrospect. the iPad. but it is a tiny fraction of their overall iPod sales. it was the same piece of technology that made the original iPod so successful. Most of the other pieces of technology in the architecture improved as expected over the years. somebody must be buying the “old” iPods and Apple must be making some money off of them. But the real game changer was the switch from disk to memory. That single decision freed Apple to innovate without constraints and allowed them to change the rules of the game again. In essence. like the solid-state memory in the iPod. at the time it required a huge leap of faith to take.Comparison of Apple iPod Models Source: Apple Inc.” they realized that innovation couldn’t be unleashed on their new platform until they removed the single biggest piece of the architecture that was imposing all the constraints. So. Think about that for a second: Apple had to eliminate the key technology in the iPod that had made them so successful in order to move to the next level of success with the iPod Touch and the iPhone. Note: as of early 2012. Ironically. which avoids the performance penalty of disk I/O completely. In-Memory Basics Thus far. As we have seen. you’ll need an overwhelmingly compelling business reason to forego all the goodness of the new architecture and renovated SAP apps on top of SAP HANA. in these systems slow disk I/O was the main bottleneck in data throughput. but this pipe can send a flood of data to hundreds of processors at the same time so that they can crunch more data . we’ve focused on the transition to in-memory computing and its implications for IT. Pure In-Memory Database With SAP HANA. At that point. but they’re predicting a similar adoption trend once the SAP Business Suite is supported on SAP HANA. Main memory is no longer a limited resource. There are also some cutting-edge concepts. Historically database systems were designed to perform well on computer systems with limited RAM. however. There’s a techie book6 on all those conceptual differences if you really want to get down into the details. Before we do so. In a disk-based database architecture. Either disk or solid-state drives are still required for permanent persistency in the event of a power failure or some other catastrophe. What follows here is a brief summary of some of the key advantages of SAP HANA over its aging diskbased cousins. Parallel Processing Multiple CPUs can now process parallel requests in order to fully utilize the available computing resources. this arrangement shifts the performance bottleneck from disk I/O to the data transfer between CPU cache and main memory (which is already blazing fast and getting faster). It is important to note that there are quite a few technical differences between a database that was designed to be stored on a disk versus one that was built to be entirely resident in memory. This doesn’t slow down performance. however. Currently server processors have up to 64 cores. SAP thinks that there will also be a small category of its customers who will continue to want the “old” architecture — so they’ll continue to support that option. With the increasing number of cores. Storing data in memory isn’t a new concept. all relevant data are available in main memory. What is new is that now you can store your whole operational or analytic database entirely in RAM as the primary persistence layer5. In fact. CPUs are able to process increased data volumes in parallel. with fast communication between processor cores enabling parallel processing. we next “dive into the deep end” of SAP HANA. Some of these concepts might be similar to what you already know about databases and server technology. This arrangement dramatically simplifies the architecture. however. The key difference with SAP HANA is that all of those caches and layers are eliminated because the entire physical database is literally sitting on the motherboard and is therefore in memory all the time. because the required backup operations to disk can take place asynchronously as a background task. and 128 cores will soon be available. With this information as background. multicore CPUs — multiple CPUs located on one chip or in one package — are standard. there are several levels of caching and temporary storage to keep data closer to the application and avoid excessive numbers of round-trips to the database (which slows things down). not only is there a bigger “pipe” between the processor and database. Today. that merit discussion. Significantly. So. here are a few basic concepts about in-memory computing that you’ll need to understand.anyone who’s bought a hard-drive based iPod in the last five years? You’d have to really need all that storage to give up all the features of the iPod touch. which allows them to hold complete databases in RAM. modern servers can have 2TB of system memory. . The SAP HANA database allows the application developer to specify whether a table is to be stored column-wise or row-wise. configuration tables). Columnar and Row-Based Data Storage Conceptually. two options exist: row-based storage and column storage. swap space. companies can typically achieve between 5x and 10x compression ratios on the raw data.) The application typically needs to access a complete record (or row). The table has a small number of rows (e. Column-based tables have advantages in the following circumstances: Calculations are typically executed on a single column or a few columns only. SAP HANA is a “hybrid” database that uses both methods simultaneously to provide an optimal balance between them. in column storage the entries of a column are stored in contiguous memory locations. The decision to use columnar or row-based tables is typically a determined by how the data will be used and which method is the most efficient for that type of usage.). The table has a large number of rows. The table is searched based on values of a few columns. in contrast. To store a table in linear memory. Compression Because of the innovations in hybrid row/column storage in SAP HANA. SAP typically recommends that companies double the estimated compressed table data to determine the amount of RAM needed in order to account for real-time calculations. Conversely. High compression rates can be achieved because the majority of the columns contain only few distinct values (compared to the number of rows). OS and other associated programs beyond just the raw table data. Neither aggregations nor fast searching is required. is organized as a linear structure. The columns contain primarily distinct values so that the compression rate would be low. A row-oriented storage system stores a table as a sequence of records. Computer memory. The table has a large number of columns. Row-based tables have advantages in the following circumstances: The application needs to only process a single record at one time. It also enables the developer to alter an existing table from columnar to row-based and vice versa. just like a Microsoft Excel spreadsheet. (This applies to many selects and/or updates of single records. so that columnar operations are required (aggregate. each of which contains the fields of one row. g. This means that 5TB of raw data can optimally fit onto an SAP HANA server that has 1TB of RAM. Persistence Layer The SAP HANA database persistence layer stores data in persistent disk volumes (either hard disk or . scan. etc. a database table is a two-dimensional data structure with cells organized in rows and columns.without waiting for anything. it includes all of the standard application interfaces and libraries so that developers can immediately get to work using it. If power is lost. pre-installed appliance on certified hardware. Applications have to put data in and take data out of the database. we can focus more specifically on the SAP HANA architecture. The persistence layer ensures that changes are durable and that the database can be restored to the most recent committed state after a restart.solid-state drives). SAP HANA is quite different “under the hood” than any database in the market. and it has to store and manage data reliably. In reality. it is delivered as a pre-configured. the data in RAM is lost. SAP HANA in-memory appliance Finally. Despite these surface similarities. In what ways is SAP HANA unique? First. without re-learning any proprietary APIs. SAP HANA is much more than just a database. data sources have to interface with it. Second. These features are designed to make SAP HANA as close to “plug-and-play” as it can be and to make it a non-disruptive addition to your existing landscape. This eliminates many of the typical activities and problems you find in regular databases. As we noted earlier. conceptually SAP HANA is very similar to most databases you’re familiar with. however. In fact. We’ll spend a few moments here . SAP HANA Architectural Overview Now that we’ve discussed the key concepts underlying in-memory storage. SAP HANA uses an advanced deltainsert approach for rapid backup and logging. it’s a full-featured database platform. However. because the persistence layer manages restore points and backup at such high speeds (from RAM to SSD) and recovery from disk to RAM is so much faster than from regular disk. you actually “lose” less data and recover much faster than in a traditional disk-based architecture. It includes many tools and capabilities “in the box” that make it much more valuable and versatile than a regular database. SAP HANA comes with several ways to connect easily to nearly any source system in either real-time or near real-time. SQLScript The SAP HANA database has its own scripting language. However. especially for MS Office integration DBSL (Database Shared Library) for ABAP . Libraries The technical details of communicating with the SAP HANA database are contained in a set of included client libraries for standard platforms and clients. MDX Interface The SAP HANA database also supports MDX (MultiDimensional eXpressions). there are some features — for example. MDX can be used to connect a variety of analytics applications like SAP Business Objects products and clients such as Microsoft Excel. The SQL implementation of the SAP HANA database is based on SQL 92 entry-level features and core features of SQL 99. We’ll discuss them in much more technical detail in the SAP HANA Architecture chapter. Planning Engine The SAP HANA database contains a component called the planning engine that allows financial planning applications to execute basic planning operations in the database layer. Engines The core of the SAP HANA database contains several engines that are used for specific tasks. These extensions are available for creating tables as both row-based and column-based tables and for conversion between the two formats. that offers scripting capabilities that allow application-specific calculations to run inside the database. By incorporating procedural language support — C++. Programming Interfaces for SAP HANA SQL SQL is the main interface for client applications. the de facto standard for multidimensional queries. SQLScript is similar conceptually to “stored procedures. it can achieve exceptional performance because the data do not need to be moved out of the database. Calculation Engine What truly makes SAP HANA unique is that. The following client libraries are provided for accessing the SAP HANA database via SQL or MDX: JDBC driver for Java clients ODBC driver for Windows/Unix/Linux clients. Python. in addition to its being a standard SQL database. it offers several SQL extensions on top of this standard.explaining these capabilities at a basic level. For most SQL statements it is irrelevant whether the table is column-based or row-based. However. and then written back in. named SQLScript. The two primary engines are the planning engine and the calculation engine. time-based queries and column-store specific parameters — that are supported only for columnar tables. it also natively supports data calculation inside the database itself. processed. and ABAP — directly into the database kernel through a dedicated calculation engine.” but it contains several modern innovations that make it much more powerful and flexible. The information modeler is used for modeling data. Replication-based data provisioning like Sybase Replication Server or SAP SLT (System Landscape Transformation) provide near real-time synchronization of data sets between the source system and SAP HANA.Business Function Library SAP has leveraged its deep application knowledge from the ABAP stack to port specific functionality as infrastructure components within SAP HANA to be consumed by any application logic extension. the changed data are pushed from the source to SAP HANA based on triggers such as table updates. and lifecycle management. which enable users to analyze values from single-fact tables related to the dimensions in the attribute views. and analytical views in on-the-fly calculations. After the initial replication of historical records. Attribute views are built on dimensions or subject areas used for business analysis. and data modelers. the information modeler. It enables users to create new data models or modify existing ones. index tables. In traditional databases. create backups. Examples of common business functions are “currency conversion” and “calendar functionality. In contrast. which utilizes SQLScript and stored procedures to perform business logic on the data models. in SAP HANA. 2. Analytical views are multidimensional views or OLAP cubes. change the configuration. It is based on the open-source Eclipse framework. dynamic data modeling on the lowest granular level is loaded into the system. Calculation views are used to create custom data sets to address complex business requirement using database tables. Information models in SAP HANA are a combination of attributes/dimensions and measures. perform a recovery. users experience bottlenecks when changing business requirements requires modifications to the existing data model. These raw data are constantly available in memory for analytical purposes. Data Modeling in SAP HANA Business and IT users can either create on-the-fly non-materialized data views or build reusable ones on top of standard SQL tables via a very intuitive user interface.” SAP HANA Studio The SAP HANA Studio is the primary interface for developers. and so on. Information models created in SAP HANA can be consumed directly by Business Objects BI clients or indirectly by using the Universe/Semantic Layer built on top of SAP HANA views. SAP HANA provides three types of modeling views: 1. 3. or any other redundant data storage. and they are not pre-loaded in cache. and it consists of three perspectives: the administration console. Data Provisioning for SAP HANA SAP HANA offers both real-time replication and near real-time/batch replication to move data from source systems to the SAP HANA database. physical aggregate tables. It includes database status information as well as functions to start/stop the database. which required users to delete and re-load data into materialized views. The lifecycle management perspective provides an automated SAP HANA service pack (SP) for updates using the SAP Software Update Manager for SAP HANA (SUM for SAP HANA). The administration console of the studio allows system administrators to administer and monitor the database. administrators. attribute views. SAP SLT can also be used to “direct write” data back to the source system in . It benefits from being database and OS agnostic. earthquakes or hardware failures. Trigger-Based Data Replication using SLT is based on capturing database changes at a high level of abstraction in the source SAP system. Real-Time Replication Using SLT SLT replicator provides near-real-time and scheduled data replication from SAP source systems to SAP HANA. Backup & Recovery The Administration console in the SAP HANA Studio supports the following scenarios: Recovery to the last data backup Recovery to both the last and previous data backups Recovery to last state before the crash Point-in-time recovery In the event of disaster scenarios such as fires. and unstructured data. power outages. Back-up & Recovery. and it can parallelize database changes on multiple tables or by segmenting large table changes. DS loads snapshots of data periodically as a batch and is triggered from the target system. The type of data provisioning tool used is primarily determined by the business needs of the use case and the characteristics of the source system. Administrators are notified by an alert mechanism when critical situations arise. Analytics and statistics on historical monitoring data are also provided to enable efficient data center operations and for planning future resource allocations. SAP BusinessObjects Data Services is a proven ETL tool that supports broad connectivity to databases. and User provisioning. ETL-based data provisioning is primarily accomplished with SAP BusinessObjects Data Services (DS). It provides the modeling environment to model data flows from one or more source systems along with transformations and data cleansing. the SAP HANA database can be connected as a secondary database to an SAP ECC system and provide accelerated data processing for existing SAP applications.scenarios where “write back” or “round trip” synchronization to the SAP source system is needed. Real-Time Replication with Direct Write/Write-back SAP HANA also supports real-time replication with direct write using database shared library (DBSL) connection. It is based on SAP’s proven System Landscape Optimization (SLO) technology that has been used for many years for Near Zero Down Time upgrade and migration projects. . SAP HANA Database Administration The SAP HANA Studio Administration Console provides an all-in-one environment for System Monitoring. its services. legacy. and the consumption of its resources. file formats. Applications can use the DBSL on the application server layer to simultaneously write to traditional databases and the SAP HANA database. Using DBSL. Extraction (ETL) / Periodic Load The ETL-based data load scenario uses SAP BusinessObjects DataServices to load the relevant business data from virtually any source system (SAP and non-SAP) to the SAP HANA database. applications. SLT can be installed on an existing SAP source system or as an additional lightweight SAP system side-by-side with the source system. System Monitoring The Administration console provides tools to monitor the system’s status. including deployment in the customer data center. in reality installing SAP HANA requires on-site activities and coordination on a high technical level. the better. role-based security and analysis authorization using analytic privileges. using the latest Intel Xeon E7 processors. multipurpose appliance that combines SAP software components optimized on hardware provided by SAP’s leading hardware partners such as Cisco. a primary database for the SAP Business Suite. SAP uses the amount of RAM to determine the server’s t-shirt size as well as its price. and we’ll consider some potential future scenarios. Although the term “appliance” suggests a “black box” that plugs into an outlet. Analytical privileges provide security to the analytical objects based on a set of attribute values. however. The appliance approach for SAP HANA systems reduces the implementation and maintenance effort significantly. In its current form. a primary database for SAP NetWeaver Business Warehouse. and a development platform for new applications.” so it does not impose a per-processor charge for SAP HANA. but it does not eliminate it completely. SAP’s underlying philosophy is “the more processors (cores). where the failover is triggered automatically. and Fujitsu. SAP is currently testing a 60 node SAP HANA instance in the labs. Dell. SAP HANA Hardware SAP HANA is delivered as a flexible. NEC.SAP HANA supports Hot Standby using synchronous mirroring with the redundant data center concept — including a redundant SAP HANA system — in addition to Cold Standby using a standby system within one SAP HANA landscape. Hitachi. potentially. The hardware vendor provides factory pre-installation for the hardware. SAP HANA can be used for four basic types of use case: agile data mart. it can be used in multiple scenarios and deployed in several ways. These values can be applied to a set of users by assigning them to user/role. It may also add specific best-practices and configuration. HP. With the current certified Scale-Out options from SAP HANA hardware providers. With this point in mind. User Provisioning SAP HANA supports user provisioning with authentication. the installation and configuration of SAP BusinessObjects business analytics client components. the OS. Solution Manager setup. it really shines in scenarios that involve both types of data. SAP HANA Use Cases Because SAP HANA is both a database (in the traditional sense) and a database platform (in the modern sense). The customer then establishes connectivity to the source systems and clients. The vendor finalizes the installation with on-site setup and configuration of the SAP HANA components. Because RAM is the key technology for SAP HANA. we’ll discuss the key use cases that are most typical for SAP HANA deployments today. connectivity to the network. and the SAP software. It’s important to remember that SAP has developed SAP HANA to be a non-disruptive addition to existing landscapes. Due to its hybrid table structure. IBM. including the deployment of additional replication components on the source system(s) and. companies can deploy up to 16 Extra Large server nodes into on logical database instance. As SAP HANA matures and SAP renovates its entire portfolio of solutions to take advantage of all the horsepower in SAP HANA. you . and SSL support. which equates to a maximum of 32TB of RAM and 128 CPUs with 1280 total cores. SAP HANA servers are sold in “t-shirt” sizes ranging from Extra-Small (128GB RAM) all the way up to Extra Large (>2TB RAM). SAP HANA performs equally well for analytic and transactional applications. SAP router connectivity. In this scenario. analytic front end — but they are very fast to set up and flexible to use. SAP Business Suite The second major scenario where SAP HANA is being used is to accelerate transactions and reports inside the SAP Business Suite.” You can access the videos listed below to listen to a few highly satisfied customers talking enthusiastically about their agile data mart scenarios with SAP HANA. SAP HANA acts as the central hub to collect data from a few SAP and non-SAP source systems and then display some fairly simple and focused analytics in a single-purpose dashboard for users. which is then connected to the source systems and displayed to a small number of users in a simple Web-based or mobile user interface. This process involves zero disruption to the existing landscape. side-by-side with the database under the SAP Business Suite applications or as the primary database for the entire SAP Business Suite. as well as many more new “native-HANA” applications. however. For a listing of hundreds of permutations of these core use cases and details on current SAP HANA live customers by industry and function. the development cycles for these use cases are typically very short. because the business problem is well known and the relevant data and source systems are easily identified. We label these systems “agile data marts” because they perform a few of the same functions as a traditional data mart — ETL. because most of these scenarios use a standard SAP BusinessObjects front end with self-service analytics or Microsoft Excel. As of mid-2013. The scenarios might be straightforward. please visit the SAP HANA Use Case Repository. but it is not being used as the primary database under the application. SAP HANA is being used to “off load” some of the transactions or reports that typically take a long time (hours or days) to run. SAP HANA is set up as a stand-alone system in the landscape.can expect to see nearly every product that SAP provides supported natively on SAP HANA as a primary database. sometimes in just a few weeks. Agile Data Mart The earliest scenarios where SAP HANA has been deployed in production are as a stand-alone data mart for a specific use case. Nongfu Spring Medtronic SAP provides a special licensing bundle to build an agile data mart use case with SAP HANA that includes the extractors and connectors needed to obtain data from source systems and the front-end tools needed to build analytical applications on top of the data. but the deficiencies of the “old” database world made them “unfixable. and companies get instant value because they can now do things that were impossible before they acquired SAP HANA. The key advantage of SAP HANA for the agile data mart scenarios is that these scenarios were either completely impossible to build in a traditional database architecture or they were so cost prohibitive that companies could not justify building them. data modeling. SAP SRM). Additionally. SAP HANA can be set up as either a stand-alone system in the landscape. These projects are also typically completed very quickly. This use case has the advantages of (1) being completely non-disruptive to the existing landscape and (2) providing an immediate. We explained earlier that certain transactions or reports inside the SAP Business Suite can be very . In this scenario. focused solution to an urgent business analytics problem. SAP HANA can now be used as the primary database under every application in the SAP Business Suite (excl. Accelerated SAP ERP Transactions and Reports You can expect to see many more “problem” transactions and reports generated at previously . there is very little that needs to be done to accelerate a few problematic transactions or reports in an SAP Business Suite application. Budgeting and planning transactions in SAP require the system to call data from many different tables in order to run its calculations and present a result. It required no changes to the algorithm. Reports are also very data-intensive. SAP has also set up special fixed-price. Hilti set up an SAP HANA system next to their production SAP ERP system and then copied the relevant tables into SAP HANA. and no changes to the user interface. This major — and unnecessary — delay was the epitome of “latency. Users log in as they normally do. the application must request the data from the database. let’s consider the case of Hilti. Quite often. meaning that the user must run the report or transaction. run the algorithm or calculation. SAP has already delivered the content for most of the truly problematic transactions and reports as part of the latest service packs for the SAP Business Suite — for free. Watch Hilti’s SAP HANA story here. the users didn’t even realize there had been any change to the system until they ran the report for the first time. A salesperson used to hit “Enter” and then return three hours later to obtain the results. the user needs to make some adjustments to the results and then save the changes back to the database. Hilti used to generate a list of 9 million customers from 53 million database records in its SAP ERP system in about three hours. the algorithm only took a few fractions of a second to calculate. and the results come back incredibly fast. the completed report appeared on their screen before they could get out of their chairs. In addition.slow. In summary. review the results. then. that completes the process. Sometimes. Eliminating System Latency: The Case of Hilti To illustrate severe system latency. system latency can seriously slow down the entire company. The results? Hilti can now run the exact same report in about three seconds. there is a quick change in the configuration screen to redirect the transaction to read from the SAP HANA database instead of the primary database — and that’s about it. make some changes. it takes one hour to finish (from when you press “Enter” until the results are displayed on the screen). this process is iterative. In fact. fixed-scope SAP rapid deployment solutions (RDS) to assist customers in the rapid implementation of these “accelerated” transactions and reports. and then display the results. due primarily to the slow I/O of the disk-based database underneath the system and the huge requests for data generated by these transactions and reports. Technically. We’ll discuss this topic that in detail in the chapter on the Accelerated SAP Business Suite. execute the transaction or report. What if it took several hours or even a day or two to run that transaction or report? Clearly. For both transactions and reports. 99% of the time the system took to generate that list came from simply retrieving the records off the disk-based database. Significantly. the global construction tools manufacturer. Imagine a scenario where every time the transaction or report runs. Other times. Once the relevant tables have been replicated to the SAP HANA system. no changes to the production database. installing SAP HANA was totally nondisruptive. however. load it into a buffer table in the SAP application server. To their complete surprise. and then run the report or transaction again to reflect the changes. They expected the process to take several hours — as always — so they got up from their desks to do something else.” To eliminate this latency problem. involving vast amounts of data contained in multiple tables. Once the data were conveyed to the SAP application. Please see the chapter on SAP Business Suite Powered by SAP HANA for many more details. with instant analysis of your credit memo and billing list.0 Powered by SAP HANA The power of SAP HANA dramatically enhances unified planning. accounts payable and receivable. on-the-fly analysis at any level of granularity. armed with real-time information. SAP intends to allow customers running the application that have invested in SAP HANA to leverage the power of in-memory computing technology to boost performance by accelerating planning and consolidation processing. Powered by SAP HANA. open and overdue items. Here’s a short listing of some of the SAP ERP transactions and reports that are currently available: Sales Reporting Quickly identify top customers and products by channel — with real-time sales reporting. Financial Reporting Obtain immediate insights across your business — into revenue. This solution can also be implemented alongside the wider SAP BusinessObjects Enterprise Performance Management solutions portfolio to help organizations create a complete picture of their cost and profit drivers. powered by SAP HANA announced last year. SAP Solutions for Accelerated Applications SAP BusinessObjects Planning and Consolidation 10. budgeting. and the movement of goods — with real-time purchasing reporting. Furthermore.unimaginable speeds as SAP introduces enhancement pack updates to SAP HANA. and material lists — for improved productivity and accuracy. You can try the solution on your own with the SAP CO-PA Accelerator TestDrive and visit . Improve order fulfillment rates and accelerate key sales processes at the same time. and dimension. top general ledger transaction. SAP BusinessObjects Planning and Consolidation 10. Master Data Reporting Obtain real-time reporting on your main master data — including customer. self-service access to trusted profitability information. vendor. customers. Make the right financial decisions. and days sales outstanding (DSO). vendors. The solution helps finance departments to perform real-time profitability reporting on large scale data volumes and to conduct instant. SAP CO-PA Accelerator SAP CO-PA Accelerator dramatically improves the speed and depth of working with massive volumes of financial data in ERP for faster and more efficient profitability cycles. aggregation.0. The application is planned to be the first enterprise performance management (EPM) application to support the SAP NetWeaver Business Warehouse component. Shipping Reporting Rely on real-time shipping reporting for complete stock overview analysis. version for SAP NetWeaver aims to increase agility by helping enterprises harness big data to plan better and act faster with better insight into all relevant information and rapid write-back. You can better plan and monitor outbound delivery — and assess and optimize stock levels — with accurate information at your fingertips. Make better purchasing decisions. forecasting and consolidation processes. finance teams can run cost allocations at significantly faster processing time and be empowered with easy. based on a complete analysis of your order history. Purchasing Reporting Gain timely insights into purchase orders. best-run businesses can unlock hidden revenue opportunities as well as significantly increase profits and sales effectiveness. The solution offers four implementation scenarios — Financial Accounting — Controlling — Material Ledger — and Production Cost Analysis. They can react more quickly to changing sales conditions with real-time information. . and accelerate deals through the pipeline with powerful and user-driven analytics. SAP Sales Pipeline Analysis With SAP Sales Pipeline Analysis powered by SAP HANA. As a result. SAP Finance and Controlling Accelerator SAP Finance and Controlling Accelerator supports finance departments with instant access to vast amounts of ledger. which can be implemented individually or in any combination. sales departments can get real-time insight into massive volumes of pipeline data in CRM while performing on the fly calculations and in-depth analysis on any business dimension.the website to discover how organizations are generating significant business value with the solution. cost and material ledger data in ERP as well as easy exploration of trusted and detailed data. The power of SAP HANA combined with SAP Enterprise Resource Planning (ERP) empowers financial professionals to perform faster reporting and analyses. accelerate periodend closing. Sales managers can now leverage the power of SAP HANA combined with SAP Customer Relationship Management (CRM) for complete and instant visibility of accurate and consolidated pipeline data. and make smarter decisions. tactics and channels. You can view a demonstration of the solution and discover how organizations like yours are generating significant business value by visiting this website.SAP Customer Segmentation Accelerator The SAP Customer Segmentation Accelerator helps marketing departments build highly specific segmentations on high volumes of customer data and at unparalleled speed. dramatically reduce the cost of marketing by targeting more easily high margin customers. and react quicker to optimize campaigns and tactics. The power of SAP HANA combined with SAP Customer Relationship Management (CRM) empowers marketers to maximize profits with highly tailored campaigns. Marketers can now work with large amounts of granular data to better understand customer demands. . behaviors and preferences — targeting the precise audience with the right offers across every customer segments. SAP HANA Rapid Deployment Solutions A great majority of these solutions powered by SAP HANA can be deployed as rapid-deployment solutions in order to ensure a quick time to value. The rapid deployment solutions streamline the implementation process bringing together software, best practices, and services ensuring maximum predictability with fixed cost and scope editions. SAP Rapid Deployment solutions leverage an innovative delivery model to accelerate the implementation times and lower risk. Implementation is supported by a standardized methodology, accelerators developed uniquely for each offering, and predefined best practices, meeting typical business requirements to address the customer’s immediate needs. Even as customers benefit from prebuilt functionality, these solutions provide a platform designed to evolve and extend as the customer’s business grows. SAP Rapid Deployment Solutions are available through SAP as well as SAP partners by traditional licensing or subscription pricing, transparency of price and scope eliminate project risks for companies. A good example is the SAP ERP rapid-deployment solution for operational reporting with SAP HANA that can help you quickly generate insightful reports — from sales to financials to shipping — on high volumes of ERP data. A second example is SAP rapid-deployment solution for sales pipeline analysis with SAP HANA that helps you to analyze massive amounts of pipeline data in CRM. You can view a demonstration of the solution here. Here are a few of the SAP Rapid Deployment Solutions that are available to enable the accelerated SAP applications: SAP ERP rapid-deployment solution for accelerated finance and controlling with SAP HANA Gain access to large volumes of secure and detailed data from cost and material ledgers — quickly and easily. By running SAP HANA, you can improve decision making through accelerated reporting, analyses, and period-end closings. SAP ERP rapid-deployment solution for operational reporting with SAP HANA Quickly and affordably generate insightful reports from sales to shipping — in real time — using our operational reporting solution with SAP HANA. Rely on in-memory technology to process high volumes of data quickly, and get ready to transform decision-making business-wide. SAP ERP rapid-deployment solution for profitability analysis with SAP HANA Analyze massive amounts of profitability data in enterprise resource planning (ERP) (CO-PA) faster than ever before. Our ERP profitability analysis solution with SAP HANA can help you perform real-time reporting and conduct instant, on-the-fly analysis — for more profitable decision making across your enterprise. SAP rapid-deployment solution for customer segmentation with SAP HANA SAP HANA combined with SAP Customer Relationship Management (CRM) can help you analyze and segment massive amounts of customer data in real time. You can target the precise audience with the right offers across customer segments, tactics, and channels. SAP rapid-deployment solution for sales pipeline analysis with SAP HANA Gain instant insight into massive volumes of sales pipeline data while performing on-the-fly calculations and indepth analysis on any business dimension. You can also try out a few of the current accelerated applications running LIVE: http://hanauseast.testdrivesap.com/copa. We’ll go into much more detail on the applications and RDS packages in the Accelerated SAP Business Suite chapter. SAP offers a specific licensing bundle to utilize SAP HANA for this use case that includes additional replication tools needed for the connections to the SAP source system. SAP NetWeaver Business Warehouse Powered by SAP HANA In this scenario, companies replace the entire database under their SAP BW 7.3 system with SAP HANA. They simply swap out whatever disk-based database their system is currently running on with SAP HANA — in just a few weeks.7 Recall from our earlier discussion of early SAP in-memory projects that SAP BW was the first SAP application that was renovated and updated to natively run on SAP HANA as its primary runtime database. Most of these renovations were necessary to more closely tie the SAP BW application to the SAP HANA database. In a disk-based architecture, SAP BW is separated from the database by an abstraction layer, essentially making it impossible for the application to “see” anything in the database other than bare tables. Once the abstraction layer is removed, the SAP BW application cannot only “see” everything in the database, but the entire database is designed around the needs of that specific application. This opens up a whole new world of possibilities for SAP customers. With SAP HANA, SAP BW now generates turbo-charged query responses natively, without the need for any side-car accelerators or crazy multi-layered third-party architectures. Because the entire database under the SAP BW system physically sits in memory, every activity — not just queries — is executed orders of magnitude faster. SAP released the 7.3 version of SAP BW in general availability in early 2011 and then released the SAP HANA-enabled version into general availability in April 2012. SAP NW BW on SAP HANA is now Generally Available to all customers globally. All of the SAP HANA-specific enhancements were bundled into the SPS05 update, and customers who had already upgraded to 7.3 could install the service pack and migrate to SAP HANA in a matter of days (seriously). Red Bull was the first live customer of SAP BW on SAP HANA. They told the world about their amazing 10-DAY project to get up and running at the Sapphire Now 2011 conference in Madrid, Spain. The whole effort was incredibly non-disruptive. SAP is seeing similar results with the other customers in the ramp-up project. All of the changes on the SAP BW side are delivered “under the hood” in the service pack, and the database migration can be performed without any changes to the SAP BW application. All of the customer’s content and configuration are completely unchanged. Have a look at the end-to-end migration guide for a great overview of the SAP BW database migration process. You should also read a great blog post by John Appleby, a consultant who performed one of the first SAP BW on SAP HANA migrations. The speed and flexibility acquired by replacing the old database with SAP HANA reflect two fundamental benefits of keeping the entire database in memory: (1) This architecture eliminates the need to send huge amounts of data between application and DB servers, and (2) it allows users to execute performance-critical operations directly on the data in the database itself. Basically, running SAP BW on SAP HANA completely eliminates nearly every one of the nasty things that historically slowed down the system, from both a user perspective and an administration perspective. We’ll explore all of the technical enhancements in the SAP BW on SAP HANA chapter. SAP offers a specific “run-time only” license option to utilize SAP HANA as the primary persistence layer for SAP BW. If you are already an SAP BW customer, the company offers several options for license credits based on previous SAP BW and BWA licensing. Consult your SAP account executive for the details. SAP has also set up a special migration fund to provide professional services credits to migrate to SAP BW on SAP HANA. SAP HANA as an Application Development Platform Probably the most wide-open innovation opportunity for SAP HANA is as an application platform. If the speed and simplification that were achieved by porting SAP BW are any indication, users can realize an unbelievable amount of value not only by renovating existing applications (SAP and nonSAP) to run natively on SAP HANA, but by also building entirely new applications that are designed from scratch to maximize SAP HANA’s powerful capabilities. The performance limitations of traditional databases and processing power have often led organizations to compromise on how to deploy business processes on their enterprise platforms. Now, these organizations can choose to liberate themselves from these constraints and optimize business processes in ways that are more natural to the way their employees actually perform their work. This is where SAP sees a clear parallel to the Apple App Store evolution. When Apple first released the App Store, most of the first apps available were “mobile-ized” versions of desktop or Web apps (email, browser, etc.). However, once developers considered the possibilities of combining the new capabilities of the device and writing native applications for the iPhone/iPod Touch (Angry Birds, Foursquare), innovation exploded. There are three basic types of applications being built on SAP HANA today: New apps built by SAP, New and renovated apps built by partners such as independent software vendors (ISVs) and systems integrators (SIs), Custom apps built by companies for internal use. SAP brands applications that leverage SAP HANA as a database as “Powered by SAP HANA.” Partners whose applications have been certified by SAP can also add the “Powered by SAP HANA” brand to their solution name. SAP-built Applications for SAP HANA SAP is delivering a new class of solutions on top of the SAP HANA platform that provide real-time insights on big data and state-of-the-art analysis capabilities. These innovative solutions can empower organizations to transform the way they run their businesses by making smarter and faster decisions, responding more quickly to events, unlocking new opportunities, and even inventing new data-driven business models and processes that were simply not possible with disk-based databases. Below are a few examples of native-SAP HANA applications. We’ll consider them in greater detail in the SAP HANA Applications chapter. SAP BusinessObjects Sales Analysis for Retail powered by SAP HANA This solution provides retailers with real-time access to critical information and allows nearly real-time interactive analysis, which is not possible with traditional database technology. It offers prebuilt data models, key performance indicators (KPIs), role-specific dashboards and customized reports to provide retailers with a deeper understanding of all factors influencing the merchandising life cycle. SAP BusinessObjects Sales Analysis for Retail aims at providing the integration needed for improved scalability and performance for retailers operating in separate sales, inventory and promotions systems. The new service provides Point-of-Sale (POS) analysis allow retailers to assess performance and generate quick responses through the use of and by any other dimension and at any level of granularity Segment customers with precision based on energy consumption patterns that are automatically generated by identifying customers that have similar energy usage behavior Provide energy efficiency benchmarking based on statistical analysis so that utility companies can help their customers understand where they stand compared to their peers and how they can improve their energy efficiency Empower customers with direct access to energy usage insights via web portals and mobile devices connected to SAP Smart Meter Analytics via web services These capabilities delivered by SAP Smart Meter Analytics enable utility companies to increase adoption of service options such as demand response programs. launch targeted energy efficiency programs. . building type. utility companies can: Instantly aggregate time of use blocks and total consumption profiles to analyze their customers’ energy usage by what neighborhood they are in. and develop new tariffs and more accurate load forecasts. This new application enables utility companies to turn massive volumes of smart meter data into powerful insights and transform how they engage customers and run their businesses. the size of their homes or businesses. With SAP Smart Meter Analytics. interactive reports and more than 70 KPIs and inventory management to provide retailers with the ability to identify critical stock and margin issues through close inventory alignment. improve fraud detection capabilities.prebuilt dashboards. SAP Smart Meter Analytics SAP Smart Meter Analytics is a “native-HANA” application that was designed for utility companies facing an exponential increase in data volume driven by their deployment of smart meters. .SAP Sales & Operations Planning SAP Sales & Operations Planning is a next generation planning application that is powered by SAP HANA and delivered in the cloud. reduce supply chain costs. and financial data at any level of granularity and dimension Rapid. using the full S&OP data model to support demand-supply balancing decisions Embedded. and drive revenue growth. context-aware social collaboration enables rapid planning and decision-making across the organization These capabilities enable companies to align demand and supply profitably. The solution enables: Planning and real-time analysis with a unified model of demand. interactive simulation and scenario analysis. supply chain. cribs. FDA and USDA . Features of the app include: Search recall history by brand or category Create a personal watch list of items like car seats.SAP Supplier InfoNet SAP Supplier InfoNet is a cloud-based solution. NHTSA. powered by SAP HANA. Recalls Plus Recalls Plus is SAP’s first consumer mobile app that enables parents to proactively monitor recalls of their kids’ strollers. cribs. that enables companies to: Minimize supply chain disruption by proactively monitoring and predicting real-time supply risks across a multi-tier supplier network Drive stronger supplier performance by benchmarking supplier performance for your company against others in the business network and identifying significant shifts and trends in supplier performance using leading-edge machine learning and statistical analysis Manage your supply base by aggregating and transforming supplier data to deliver instant insights into the operational health of the supply base. strollers and so on Track allergen related recalls Share relevant recalls with others Read and monitor recalls from all relevant US government agencies: CPSC. toys. and other items for greater safety and peace of mind. Oversight Systems is one of the first ISVs to renovate their SAP-certified solution along these lines.com/recallsplus Partner-built Applications for SAP HANA The SAP partner ecosystem provides thousands of SAP-certified software solutions that plug into SAP’s applications to provide a variety of value-added extensions and process enhancements.com/us/app/recalls-plus/id499200328 Facebook app: https://apps. partners too can approach re-platforming as an opportunity to rethink some of the design parameters that they employed in the original solution design and to rebuild their apps to take advantage of SAP HANA’s many benefits natively. accounting and reporting. they all can be ported over to SAP HANA in a fairly straightforward way. However. From that perspective. such as travel and expenses. and HR and payroll.apple. Regardless of the programming language these partner apps are written in. Their solution conducts complex.facebook. Oversight Systems provides solutions that continuously monitor user activities — in real-time — inside SAP systems to detect policy violations and potentially fraudulent transactions. Therefore. the addition of SAP HANA underneath their solution makes perfect sense. . There are also numerous SAP partner solutions that need to “turbocharge” themselves to increase their own performance — and to keep up with the turbocharged SAP systems coming on top of SAP HANA in the future.Recalls Plus is available for free and can be accessed via an iPhone app or a Facebook app: iPhone app: http://itunes. on-the-fly calculations that demand a great deal of I/O performance from databases. just as SAP is renovating its existing applications. anything that speeds up an SAP system will also have a positive impact on any partner solutions that are integrated with that system. That’s not to say that SAP HANA can’t run your “standard” applications — it certainly can do that (really fast). if you’re building an enterprise-scale application for a business scenario that (1) needs to search or aggregate huge volumes of data. This is where the “Angry Birds” analogy really starts to make sense. SAP will invest an enormous amount of resources to extend SAP HANA’s capabilities as an application platform for both its own applications and non-SAP applications. Once the SAP ecosystem of ISVs. With that much processing power and high-speed RAM available. There’s a great deal of value that can be achieved by doing things “better” in the applications. but the sky truly is the limit when it comes to imagining what to build with SAP HANA. It speaks pure SQL and it includes all of the most common APIs. It is even more important. or (3) suffers from latency between transactional recording and reporting. optimize. Moore’s law doesn’t look as though it’s going to be slowing down anytime soon. possible. that we’re only a few years away from having more than 1000 cores and 10TB of RAM on a single “medium” SAP HANA server. SAP HANA Roadmap The future roadmap for SAP HANA is actually very simple: Continue to make SAP HANA faster. There are a few rules and “guide rails” that are designed to keep things from going wrong. It is incredibly important for SAP to renovate its portfolio and build amazing new applications to exploit the vast potential of SAP HANA. then. there really are no limits to how fast SAP can speed up its own apps and literally any other app on the planet. because there are millions of unrealized business ideas in their companies that SAP HANA can bring to life. it “shines” particularly well in a few unique situations. Renovating and re-imagining how applications work and how they deal with data in the “no constraints” paradigm represents a fundamental philosophical shift for application developers. then SAP HANA is a great choice. SAP will continue co-innovating with Intel and other hardware partners to ensure that SAP HANA is continuously updated and optimized to take advantage of the latest and greatest technology advances to become even faster than it is today. and SAP customers starts to unleash their innovation on top of SAP HANA. Nevertheless. better. If you’re a business owner who has a killer idea that fits the above description. Renovating applications to take advantage of the ever-increasing horsepower is also critical.Custom Applications for SAP HANA As stated earlier. cheaper — plus BIGGER and BROADER. Although the speed boost generated by the hardware is exciting. there literally is no limit to the amazing and game-changing applications they can build. then SAP HANA could be the solution that makes the impossible. the most exciting use cases SAP is seeing for SAP HANA as the foundation of custom apps are situations where a company has an urgent business need that is literally impossible to automate today due to the limitations of traditional databases or the lack of a supercomputer. for the SAP ecosystem to do this. For example. . (2) requires detailed/granular data analysis and/or complex algorithmic or statistical calculations. SAP HANA is a full-blown. and simplify application architectures by adding SAP HANA as the database engine underneath them. This investment will result in an increasingly rich and robust set of developer tools to renovate and re-imagine any application and to build amazing new applications. Although SAP HANA is valuable for all types of activities. so you can literally write any type of application you want on top of it. SAP partners. do-just-about-anything-you-want application platform. however. It is likely. it is only half of the equation. There are enormous opportunities to streamline. SAP intends to become the BROADEST database platform for new applications. SAP Business ByDesign. and SAP All-inOne. SAP customers need to understand that SAP HANA not only is the engine that powers the current generation of SAP applications. These efforts include innovating in new landscape configurations such as native cloud deployments of SAP HANA. system integrators. “Cheaper” isn’t achieved only through industry-standard processors. The renovation work is moving very quickly inside SAP. SAP is going “all in” with SAP HANA. The SAP BW renovation and porting to SAP HANA was the first major step towards a completely . SAP has made a passionate commitment to innovate for the future of its ecosystem. RAM. That’s true for standard. SME solutions like SAP Business One. with a robust ecosystem of ISVs. best. Cheaper is a holistic mindset that starts from application design and then progresses through user efficiency all the way to administration and operations. In November of 2012. SAP HANA will be the heart and soul of SAP’s “real-time data platform” design philosophy to renovate all existing applications and build amazing new applications. and SAP customers building their innovative applications on SAP HANA. SAP isn’t satisfied to “only” be the fastest. Significantly. Over the next few years. it also results in significantly lower TCO for companies. In poker terms. In just the first year since SAP HANA became available. on-premise applications like the SAP Business Suite. and the emerging portfolio of cloud/on-demand solutions. and the benefits of this shift for SAP’s customers and partners are too overwhelming for the company to do anything less. SAP will continue to invest heavily in many areas to make SAP HANA the cheapest and most efficient database to operate in production environments. In addition. but it will be the growth engine for all kinds of amazing NEW SAP apps. so much so that it has surpassed even the most optimistic timelines. Just as Apple provided the platform for App Store developers. SAP’s goals also include enabling the BIGGEST data scenarios by offering integrated solutions with Sybase “Big Data” products and open-source projects like Hadoop. SAP showed the extreme scalability of SAP HANA by showcasing a 250TB RAM SAP HANA system with 250 nodes. SAP HANA can have a massive impact on reducing TCO and improving business value. over 100 startups have been founded to harness this power to drive their innovation. however. and servers. SAP HANA will become the primary database for EVERY enterprise application in the SAP portfolio. and cheapest database on the planet.This opportunity for optimization and simplification not only makes things even faster than just the hardware speed boost. SAP will provide SAP HANA as a platform for thousands of amazing new enterprise applications for the ecosystem. in the forms of redundant code. once the entire SAP portfolio has been “HANA-fied. Going back into the code of all of their apps with a fresh eye and ambitious dreams free from constraints has rekindled a firestorm of innovation within the SAP development group. Moreover. The coffee corners in SAP labs around the world are literally buzzing with new ideas and passionate discussions. SAP can provide a massive reduction in layers and TCO in the landscape while at the same time providing much more flexibility and business value through real-time access to all of the relevant data. however. In an SAP HANA world. and it will release them as they come on line. This exercise is also having an amazing effect on the SAP culture. Obviously. this enthusiasm appears to be contagious: People are witnessing the same type of awakening throughout the SAP ecosystem. SAP PLM on SAP HANA. these “database avoidance techniques” have resulted in extensive “plaque” buildup inside the applications. In fact. By merging OLAP and OLTP into a single SAP HANA instance. they’re completely unnecessary and therefore need to be removed from the system. and it is having a monumental impact on the speed and volume of innovation coming from SAP.” 8 SAP will be able to deliver a vastly simplified landscape for its customers. If the past five years of in-memory (r)evolution at SAP are an indication. this renovation also represents a golden opportunity for SAP’s engineers to reimagine all of the things that these applications do from the perspective of living in a world with no constraints. Unfortunately. Renovating these applications involves much more than simply replacing the database. and so on.renovated SAP Business Suite. This is the “intellectual renewal” that SAP executives have been talking about. SAP SCM. SAP Business Suite — SAP CRM. invent better ways of doing things. tedious data aggregations and transformations. remove latency from the processes. These experts can question their original assumptions. SAP’s renovation efforts will involve a great deal of streamlining and cleanup. SAP has had to make many adjustments in its application layer to avoid the I/O bottleneck associated with the database. All of these developments will lead to lower TCO and more flexibility for customers. SAP is adding SAP HANA to all of the other applications in the portfolio. These problems were “necessary evils” to work around the constraints of the disk-based architecture. It will take SAP several years to engineer and deliver this vision to its customers. however. you can often see code samples from these discussions written on the windows because the participants ran out of whiteboard space (as in the movie “A Beautiful Mind”). In the long run. the next five years of this journey will be extraordinarily fast and exciting. . The next major step was the release of its flagship application. and program their applications to perform calculations more efficiently deep inside the database. SAP HANA has literally awakened a sleeping giant of innovation inside SAP. which in turn will make their investment in SAP much more valuable. Over the years. however. At the same time. replication of data. In parallel. Indianapolis.1 Markides. if they are already on BW 7. Strategic Innovation. Process. In-memory data management: an inflection point for enterprise applications. Hoboken. 6 Plattner. NJ 5 People always ask “if all the data is in volatile storage like RAM. (2004). . Integrated Business Processes with ERP Systems. what happens if the power goes out?” We’ll talk about that in more detail later. B. John Wiley & Sons. 2 Woods. C. and 7. with Unicode.3 SP7. 4 Magal. H & Zeier. A. and Word. Driving Product. Wiley Publishing Inc. (2002). 3 With the SAP HANA RDS migration package customers can migrate in ~7 weeks. but basically. 7 The SAP HANA RDS for database migration takes ~7 weeks for most customers who are already running SAP BW 7. S. San Francisco: Jossey-Bass. Springer.x data flows and authorizations. and Market Change. In: E.). 8 Meaning “Powered by SAP HANA” and renovated to natively take advantage of SAP HANA. SAP NetWeaver for Dummies. D. J. (2011).3. (2011). IA. Roberts (Ed.. and Word. J. Innovation. SAP HANA has some very sophisticated backup tools to prevent data loss from disasters. Chapter 2 SAP HANA Architecture COMING FALL 2013 . Some of the most fundamental reasons are: To demonstrate overall business value for the project To provide an initial financial justification for purchase and implementation To ensure that the project is aligned with the organization’s business goals and/or initiatives To establish the base-line expectations for subsequent assessment of the project’s success To provide internal documentation explaining the expected business benefits to users (and .000 times faster than traditional databases for query response times. However. “fast” is regarded as a positive attribute for a product. It also focuses on the value of the real-time information that SAP HANA makes available. If you can’t figure out how a super-fast database can help you run your business better. So what??? In general. Sr. then how can you justify the expense and effort required to buy and implement it? The approach to building a business case presented in this chapter avoids the “speeds and feeds” argument that has long plagued the software industry. it examines how SAP HANA can enable organizations to execute their business processes more quickly and efficiently. Sr.Chapter 3 Developing A Business Case for SAP HANA This chapter was written with the expert assistance of David Porter. SAP Value Engineering. SAP HANA is sometimes more than 100. as well as the resulting level(s) of business value it delivers. that quality alone is seldom sufficient to justify a purchase. it’s pretty likely that you know that SAP HANA is an incredibly fast database. Anyway? There are various reasons for building a convincing business case. Principal. and trade articles over the past year. analyst reports. SAP Value Engineering and Steve Thibodeau. Why Do You Need A Business Case. Instead. really fast!” Unless you’ve missed all the SAP marketing blurbs. The primary goal of this chapter is to help you address and answer the “So what?” question and to provide some guidelines on how to construct a convincing business case in order to justify an investment in the SAP HANA platform. and the relative importance of each reason will vary from organization to organization. Director. Introduction “SAP HANA is really. In fact. The key here is to “Think big. Before we proceed. CREATE the storyline 2. After these two steps have been completed. because both metrics are components of overall business value. TIE it all together The first step. If the primary goal of a business case project is to calculate total cost of ownership (TCO) and/or return on investment (ROI) of an investment in new software. thus maximizing the likelihood that the entire initiative will be approved. however. they should include projects that not only can be implemented quickly. but starting small enables you to build in quick wins that establish success early and then continue to build business momentum with later projects. Adding the financial dimension extends the storyline to the expected business value and provides some quantitative measures that can be used in the evaluation process. Levels of Value We’ve mentioned business value a couple of times already in this chapter. An effective business case must quantify not only the tangible value proposition of the project but also the intangible value. Methodology For each business case you build. The final collection of use cases can then be used to build a roadmap for current and future deployments of SAP HANA. by itself it isn’t sufficient to obtain funding for the project. but also demonstrate measurable business value. Rather. The roadmap will balance each project›s business value against the corresponding difficulty of implementation and/or risk involved. No matter how impressive the story. A strong business case for SAP HANA typically includes multiple use cases or projects — concrete examples of how the organization will utilize the product in the course of business. The storyline is what makes the business case unique to your organization. it is also a collection of opinions and views from relevant stakeholders — both supporters and detractors — as well as representation from both the business and IT departments. Exactly what do we mean by this term? . start small. creating the storyline. is fundamental to any SAP HANA business case. the next step is to add the financial dimension.” The big picture helps shape the long-term value from the investment. Going further. some uses cases should reflect “stretch” goals — ambitious projects that may span several years. the final step is to package up the business case in a format that is appropriate for the individuals who will evaluate the project. ADD the financial dimension 3. We will discuss each of these steps in greater detail throughout this chapter. After you have created a viable storyline. we recommend the following multistep approach: 1. This approach will enable your organization to prioritize its various projects in a thoughtful and comprehensive manner. At the same time. The use cases in the storyline should map to goals and processes that distinguish your organization from the competition. then that case will likely provide an incomplete and potentially unreliable forecast of the quality of that investment.possibly to other departments in the organization) A well-developed business case is not just a collection of data. we need to consider the fundamental concept of business value. However.” Typically this means doing things faster. At this level of business value. is the result of doing things the “right way. better. Line of Business Examples: . IT is viewed as a cost center within the organization — an expense or overhead item that needs to be managed and contained. Efficiency The first level of business value. Let’s take a closer look at each one. There are two basic subcategories of Efficiency: IT Efficiency and Business Efficiency. Moreover. The chart below illustrates a useful model for categorizing these levels. Efficiency. of business value.“Business value” actually covers a relatively wide range of benefits. IT Efficiency Organizations are likely to focus heavily on IT Efficiency when (1) the software investment under consideration is part of a broader effort such as creating an analytics center of excellence or shared analytical services and (2) the main rationale for doing so is to reduce IT costs. Reducing the annual maintenance costs of older applications and databases Reducing the internal costs of enhancing or upgrading software Reducing the IT FTE resources required to manage older applications and databases Reducing the hardware infrastructure to simplify administration and minimize floor space/carbon footprint Business Efficiency The Business Efficiency level extends beyond issues that are purely related to the IT department. 1. or degrees. Of all the levels of business value. the gains from efficiency are the easiest to quantify. business efficiency/productivity is only an intermediate step in assessing the overall value of a project. and Transformation. or cheaper or otherwise improving the way you do things (but not what you do). This model identifies three levels: Efficiency. there are different levels. The following list identifies some common examples of IT Efficiency. both quantitative and qualitative. Effectiveness. Although cost is a concern. Instead of precise estimates. e. SAP HANA provides organizations with the opportunity to fundamentally rethink their basic business processes (i. In fact. effectiveness gains can be expressed as ranges of financial value. Visibility provides the ability to access relevant information quickly and in context. business performance is improved first through visibility and then through insight. but also the most difficult to achieve. Transformation Business Transformation is the highest level of business value. . if ever.To better identify the most promising sales opportunities To gain an enhanced perspective on cost drivers To increase the productivity of knowledge workers 2. Although efficiency can deliver a fair amount of business value.. Consequently. effectiveness offers the promise of much more. Then. For example. Effectiveness The second level of value — Effectiveness — redirects the focus from “doing things the right way” to “doing the right things at the right time. Higher customer value Improved product mix (margins) Better sales pipeline conversion ratio Enhanced customer retention More accurate demand forecasts More successful segmentation Enhanced understanding of real costs Greater production yields More efficient order fulfillment Faster collections Lower production costs Reduced risk/impact of risks More timely anticipation of market changes More efficient asset utilization 3. we need to discard many of the prevailing assumptions that underlie current business processes. what they do and when and how they do it). depend exclusively upon a total cost of ownership (TCO) analysis (i. Recall from previous chapters that SAP HANA a disruptive technology. At the Efficiency level of business value. organizations rarely.” To properly assess this level. insight provides a deeper understanding of the underlying causes of a situation or the likely outcome of a course of action under consideration. the business benefits it delivers extend far beyond improvements in IT operations. and not just an organizational cost center. their monetary value is frequently greater. Although effectiveness gains are usually more difficult to quantify than efficiency gains. Transformation goes well beyond Effectiveness by enabling new business models and processes. the top-performing companies in each industry incorporate analytics into their infrastructure in order to create and maintain competitive advantage. The examination of effectiveness gains makes the assumption that IT is a strategic enabler and value creator. Efficiency) to justify a business analytics initiative.e.. as illustrated by the following list. Consequently. the focus is on use cases that involve the invention of new business models and processes by leveraging innovative solutions and technologies. or container. such as SAP HANA. Specifically. Examples: Identifying and serving new market segments before your peers can Providing personalized customer pricing and services Enabling new products or pricing models Creating new business models Improving time to market Reducing inventory Increasing market share Improving P/E ratio Hopefully you now have a more nuanced understanding of business value. Below we list samples of potentially useful categories. Creating the Storyline It’s likely that you already have at least one specific use case in mind for SAP HANA — otherwise. SAP HANA is a disruptive technology. Having covered this topic. try to map to each level of business value with one or more use cases. At the Transformation level. Note that these categories may not be mutually exclusive.Sometimes called “innovation” or “The Art of the Possible. However. Transformation involves things that have never been done before. there are no baseline data to use for comparison. Some of your use cases can cross boundaries. Here are some questions to get you thinking about potential use cases: What’s happening at other companies in your industry? What elements in your organization’s strategic plan could benefit from high-performance analytics or process optimization? Does your organization own any data that no one else has (and can that data be exploited)? What mega-trends in the industry represent opportunities for new value? A. Rather. Categorization/Business Attributes Sometimes it’s easier to create use cases when you can place each one into a convenient category. as we mentioned previously. By definition. keep in mind the “Levels of Value” section of this chapter when you’re developing the use cases. Also. so the typical approach to building a technical business case does not necessarily apply here. the potential monetary value from this level of business value is the most difficult to quantify.” business transformation can generate extraordinary financial gains. Please refer to the SAP HANA Use Case Repository for the most current list of use . We begin with the first step — creating the storyline. you wouldn’t be reading this chapter! However. it’s preferable to develop multiple use cases as part of the overall business case. we return to our discussion of the three-step process for building effective business use cases. it is critical to involve the business side of the organization up front and throughout the process. The process of creating the storyline should not be conducted exclusively by IT. especially in the case of innovations. ” potential value-add.. Track and Trace. Real-Time Warranty and Defect Analysis ) Financial: (Fraud Detection. domain experts. Outage Management. Price Optimization) Sales and Marketing: (Marketing Analytics. Price and Merchandising Optimization) Telecom: (Investment Planning. Industry-specific Consumer Products: (Supplier Risk Mgt. Network Equipment Planning & Optimization) Utilities: (Smart Metering.. Real-Time Asset Utilization) Retail: (POS/Fraud Detection. and IT staff should all participate. Risk Analysis. The figure below reproduces a sample “value map” created during the first portion of a workshop for a customer in the chemical industry. Supply Network Planning) B. Demand and Supply Planning. Program Trading. Over the course of this workshop. Operational Performance Mgt. Product Recall. however. will prefer to leverage the expertise of SAP’s Value Engineering (VE) group in constructing a convincing business case for SAP HANA. validate. processes. Product Lifecycle and Cost Mgt. Grid Management) Cross-Industry Finance: (Planning and Budgeting. Investment Planning.. Therefore.. . you will have the opportunity to identify. the project sponsor. Inventory Mgt. and prioritize a number of SAP HANA use cases. Production Planning. In addition. These use cases can describe your organization’s internal usage. Self-Discovery After reading about the methodology and techniques discussed in this chapter. Customer Segmentation. Balance and Demand Forecasting. modeling. and customer interest for each use case. One of the ways in which the VE organization can help you construct an SAP HANA business case is through a Value Discovery Workshop. some customers may feel comfortable building business cases on their own. Churn Management. The workshop will provide you with detailed information on data. business unit representatives. The SAP HANA Use Case Repository and SAP HANA Value Calculator (described below) can provide invaluable assistance with this task. Consolidation) HR: (Workforce Analytics) IT: (Landscape Optimization) Order Management: (Available to Promise. C.cases. Assisted Discovery Many other customers. consumption. EPA Standards Compliance. Trade Promotion Management) Supply Chain: (Transportation Planning. it will help you identify the “degree of match. Demand Side Management. Credit Scoring. and perhaps also how your organization interacts with its external customers. Customer Profitability) Manufacturing: (Supply Chain Optimization. and security requirements for your applications. Business Planning. The workshop is intended to address business outcomes as well as technical feasibility. clients. roles. saphana.The next illustration is an example of one of the process analysis outputs created at a later stage in another workshop. VE resources may be available to assist you in building a formal business case. Finally. but it’s extremely likely that you’ll find one or more themes that closely . You may not find an exact match. Perhaps the most obvious way to use this site is to check the category for your industry to determine which of the existing use cases reflect your organization’s needs or strategic direction.com) that contains an evergrowing number of example use cases for SAP HANA. after you have completed the workshop. you’ll find sample use cases of SAP HANA that have either been implemented by a customer or discussed with a prospect. SAP HANA Use Case Repository SAP maintains a centralized SAP HANA website ( http://www. D. In the Resources section of the site. Please check with your SAP Account Executive for further information on this service. If you’re looking to SAP HANA for competitive advantage. In many instances. 1. you will recognize a common thread that will encourage you to adopt a broader perspective than if you limited your exploration to use cases in your industry. the SAP HANA website has SAP HANA Use Cases categorized by industry and selected process areas: Aerospace & Defense Automotive Banking Chemical Consumer Products Cross-Industry Customer Service Finance Healthcare High Tech Industrial Machinery & Components Insurance Life Sciences Manufacturing Marketing Media Mill Products Mining Oil & Gas Professional Services Public Sector Retail Sales Supply Chain Telecommunications Transportation Utilities Wholesale Distribution Adding the Financial Dimension Now that you’ve developed a good storyline. always keep in mind that SAP HANA’s strengths are in applications that have never been built before. It can be quite enlightening to study use cases from industries that are seemingly unrelated to yours. it’s time to map it to the expected business value for . a guiding principle is to focus on things that you can’t do today.resemble some of your business issues and/or conditions. then you are not likely to find a close match in the repository. SAP HANA Use Case Categories Currently. In addition. A second — and perhaps more useful — approach is to use the repository as a brainstorming tool. Whichever approach you adopt. IDC completed a study that concluded that business intelligence investments delivered the following return on investment: 112 % median ROI 54% process benefit improvement (Business effectiveness measures) 42% productivity gains (Business efficiency) 4% technology gains (IT efficiency) In February 2011 Aberdeen completed a real-time business study that found that organizations wanted more accurate operational information. The capabilities of SAP HANA are seen across many areas of an organization with an increasing number of benefit scenarios. Although it is important to have quantitative results.each and every use case. Production yield is an excellent example of benefits quantification. Increased yield reduces the cost of operations. B. In most current use cases.5 times more likely to deliver on budget and to realize up-front benefits. the business value for SAP HANA is measured in a similar manner to other business analytics investments. The one fundamental difference is that analytical use cases for SAP HANA consider how the availability of real-time data impacts the organization’s ability to realize value. This section will help you identify these business areas and quantify the benefits. in 2010. IT research firms have already concluded that investing in business analytics technology generates tangible benefits.9 times more likely to deliver projects on time. In addition. To address this problem. A. The SAP HANA benefits quantification evaluates what the organization can accomplish now that it can better manage data and interpret the resulting insights at lightning-fast speeds. Moreover. As a result. Therefore. No matter how captivating your storyline. A case study concluded that manufacturing organizations yielded a 2% increase in production efficiencies. resulting inthe need to store and move significant amounts of data. the traditional processes that organizations have used to consolidate and analyze data are no longer sufficient in the new environment of real-time data. Organizations utilize various approaches to business case benefit development. Importance of Benefits Quantification It is critical to acknowledge the value of IT investments through benefits measurement and post golive monitoring. An SAP Value Management study determined that organizations that develop business cases and measure post-go live success are 1. SAP’s Value Engineering organization has taken the methodology that has been used for the past eight years and applied it applied it to SAP HANA benefits quantification. it slows down the ability to analyze data. Types of Quantification SAP Value Management has created a framework for analyzing benefits that also applies to SAP . some quantitative measures are more defficult to obtain and monitor than others. they may not have the experience to transfer that approach to business analytics and SAP HANA business cases. SAP has come to realize that organizations can struggle with analytics benefits quantification. They are also 1. Data volume is exploding. however. it must be backed up with hard numbers. The independant study demonstrates that quantitative benefits are being realized with realtime information. returning tens of millions of dollars in savings. We discuss the value engineering and the value management approach later in the chapter. data variety is continually expanding with the usage of Facebook and Twitter. which is illustrated below. Unlocking the remaining benefits requires information insight. Procuremnt leaders rely on information to understand how an organization spends money in various categories such as materials. The primary metrics that measure success in this area are overall spending managed centrally and year-over-year annual savings achieved by the procurement team. For example. however. Strategy enablement and innovation are usually treated as “soft” benefits. Objective: Deliver national spend visibility and drive procurement savings . This framework. organizations are not fully optimizing savings with consolidated spend. services and IT equipment. It is important to understand that an SAP HANA business case.HANA. like an analytics business case. However. This critical function ensures that an organization manages its spending strategically. SAP realized that the underlying transactional systems by themselves release only a percentage of the overall benefits. The procurement process controls the flow of money going out of the company for materials and services. known as “hard” benefits. Spend that is not managed centrally does not leverage contracts negotiated with preferred vendors that include already secured discount levels. risk mitigation and compliance can deliver millions of dollars in savings. typically falls within the measurable benefit category. the overall spend managed by the organization was not visible at a national level. Thus. Supplier relationships at a regional level ran the risk of not capturing increased discounts and creating redundancies in process. National Grocery Retailer — SAP HANA Business Case: The retailer had already invested in an ERP system that drove the procurement process with suppliers. The following SAP HANA case study illustrates a procurement business case involving a retail grocer. places benefits in one of four categories: Strategy Enablement Measurable Benefits Risk and Compliance Innovation Financial measurement. it was implemented in a regional format. Without real-time business insight on spend. impacts numerous process areas within an organization. Efficiency gains can result in tangible benefits if . managed by a national supplier Significant supplier data compression with transfer of spend and supplier data from four regional systems to one single instance of SAP HANA Real-time and automated data transfer that was previously not possible with four different regional systems Granular reporting analysis resulting in visibility on optimal supplier discounts and redundant buying Elimination of vendor spend with contracts that do not offer maximum discount levels. An example of a cash flow benefit is the reduction of aging receivables. Data created from regional procurement systems Four regional warehouses housing ERP structured system data No infrastructure in place to automate the data consolidation for a national view of supplier spend levels Approach: Evaluate the SAP HANA solution as the database and analytics technology to enable a single view of consolidated supplier data Develop a benefits case based on the regional grocer spend performance The four major regions each had consolidated supplier spend Business Case Development: The regional procurement spend performance was compared. In addition. Renegotiation of national vendor contracts demonstrating higher discount levels on aggregated spend 1.Shift from regional vendor relationships and contract terms to a national level Challenge: Significant data volumes residing with four regional data warehouses. and the grocer found that certain regions were outperforming others in year-over-year savings and negotiated discounts The grocer utilized SAP’s global benchmarking data to compare year-over-year savings and spend managed strategically with retail peers The grocer determined that additional savings would be possible if the organization better understood the underlying procurement data XXX calculated a conservative benefits estimate of $50 million in savings over a multiyear period Results and Business Benefit: Begin realizing $50 million in savings on supplier spend with one national view of vendor spend Remove supplier negotiation and contract administration redundancies with one process. Tangible (“Hard”) Benefits A tangible or “hard” benefit is defined as an outcome that increases revenue in for-profit organizations and reduces cost in all organizations. hard benefits can increase the cash flow that the organization utilizes to generate additional return on investments. As we discussed. An example of a hard benefit efficiency gain is the reduction of people completing a manual reporting task. The areas of improvement are derived by identifying areas of value within major business process areas. SAP’s Value Engineering organization has a full repository of all business benefits. A few of the key business benefit KPIs and key metrics are outlined below. quantifying SAP HANA benefits follows a similar approach to other traditional benefits quantification. Demand Generation Marketing Benefit: Optimized marketing spend through improved campaign effectiveness Metrics: Average cost of a marketing campaign launch Current time to measure campaign effectiveness Campaign conversion rate measured in sales or pipeline generated Outcome: Reduced marketing spend by minimizing the cost of ineffective campaigns Increased annual revenue through campaign execution Sales Execution Benefit: Increased sales conversion rate. thereby increasing annual revenue Metrics: Current pipeline conversion percentage Current revenue per sales employee Current sales team efficiency measured by time with customer and administrative time Outcome: Increased pipeline conversion rate and sales Increased total revenue per salesperson Reduced administrative time Demand Fulfillment Procurement Benefit: Reduced annual spend with increased visibility on supplier metrics Metrics: .resulting costs are removed from the gain. Common benefit KPIs are broken down within the process areas. Percent of spend managed strategically by category. direct. indirect and services Year-over-year annual savings Evaluation of vendors utilized and product categories Effort spent currently managing vendor relationships Outcome: Reduced annual spend by category Reduced efforts by buyers to manage and track vendor relationships Manufacturing Process Benefit: Reduced inventory levels and enhanced visibility of the short horizon of stock levels Metrics: Current inventory levels of finished goods Current inventory carrying costs Percentage of inventory obsolescence Outcome: Reduced inventory levels of finished goods Reduced annual inventory carrying costs Greater annual cash flow Reduced cost of inventory obsolesce Information Technology Management Information Management Benefit: Improved insight into information and reduced IT effort to prepare data Metrics: Cost of data storage Cost and effort of transferring data from source systems to a centralized data repository Effort to prepare data for reporting Effort to build standard reports Outcome: Reduced cost of information management Improved granular insights delivered in real time Organizational Performance Management . region. region.Profitability Analysis Benefit: Improved profitability analysis by product. and segment Effort required to deliver profitability analysis Current pricing processes Outcome: Increased profit by product. However. region. and segment Elimination of unprofitable items Less effort required to monitor profitability Workforce Management Benefit: Improved worker utilization levels and reduce level of overtime Metrics: Worker utilization levels Overtime percentage and cost Outcome: Reduced labor costs Improved worker output measured Fraud Management Benefit: Improved fraud detection. . and segment Metrics: Current profit level by product. thus reducing the costs associated with additional insurance claims Metrics: Current combined ratio (claims and expense measured against premiums collected) Measured fraud investigations Outcome: Reduced cost of fraud investigations Reduced combined ratio The metrics and outcomes listed in the table span many major business process areas. However. We illustrate this framework using the example of a profitability report. the external website mentioned earlier in the chapter capturing use cases and the business transformation studies captured by Value Engineering. The labour budget is not reduced. In some cases. We have multiple forums to share the benefits of SAP HANA. A business transformation study is a brief document published jointly with our customers to capture benefits realized along with the story of why the investment was made. namely.they all have a common theme. Best Practice Business Case Approach Before calculating a benefit. New KPIs and Breakthrough Innovations SAP HANA is an innovative technology that offers a fresh approach to information management. Department leads can’t drive improvements if there is no trust in the data comprising the actual results.g. but the organization utilizes appropriate metrics to deliver greater throughput with the same staff. and cash flow impacts. “first mover” advantage may result in the largest payoffs for a project. an organization must identify a baseline metric derived from the current state process. 3. After it creates this baseline. It is critical to continually measure the post-implementation impact of SAP HANA to capture benefits. C. 2. Strategic (“Soft”) Benefits Strategic or “soft” benefits are commonly linked to the tangible benefits measured above. to manage information from diverse data sources and to deliver real-time insights for decision making. profitability reporting) Number of business analysts allocated to monthly reporting Effort taken in hours taken to build monthly package . The simple steps listed below present a framework for calculating a baseline metric. These innovations are the most difficult to quantify because no baseline data exist. Similarly. SAP is constantly capturing new innovations delivered with SAP HANA to share the impact. This strategy will enable IT to jointly manage the implementation with the relevant business functions. improved decision-making can generate indirect impacts on the organization. The strategic benefits impact the organization’s overall strategies and can support the tangible benefits. A simple business case can be developed based on existing processes and then leveraged to fund breakthrough innovations. In creating and evaluating a business case. In each case the results are measured in revenue. These scenarios can be incorporated into an analytics roadmap that prioritizes value and time to value. improved employee engagement and worklife balance is another soft benefit outcome. you need carefully consider both tangible and strategic benefits. such as better execution of the corporate values for accountability. it can establish a target benefit range. The ability to deliver innovations by managing complex analysis in real time reduces time to market and generates new revenue streams. Often.. but the workforce is able to manage increasing workload. An example is a scenario in which labor costs are not reduced. Many organizations find it difficult to drive accountability with poor information. The best recommendation is to simultaneously explore innovative SAP HANA scenarios while developing existing process-improvement scenarios. SAP recommends multiple scenarios by which SAP HANA delivers maximum value to the organization. productivity or efficiency metrics do not directly result in reduced costs. Document the current state process (e. expense. SAP Value Engineering and SAP HANA Solution Management released a web-based SAP HANA benefits calculator to our customers. SAP Benchmarking . A summary report aggregates all the benefits to determine the overall financial impact. and it demonstrates how you can calculate these benefits. and the ability to collect current state processes to best calculate the benefit range. It generates ideas on how SAP HANA can impact your business. baseline metrics in isolation do not allow the owner of the business case to comfortably develop a target improvement range. As part of the initial business case development. The tool covers the most common benefit areas that most organizations would consider. past examples of measured success by other organizations. Your organization can then continue to develop benefits either in partnership with SAP VE or on your own. The baseline metric allows organizations to know how much they have improved after the technology has been implemented. E. the next step is to identify the associated value driver outcome(s). The calculator provides two or three example benefits for each of five mega-process areas: Customer Focus Procure to Pay Plan to Produce Record to Report Quote to Cash The benefits calculator enables you to customize the revenue include the number of employees. In order to truly define a benefit beyond the current state baseline. These metrics are simply utilized as a measuring stick of success. VE provides SAP Benchmarking data that indicate average and best-in-class performance. SAP designed this tool to be a great launching point for calculating benefits.) After the analysis has been completed. Benefits are more widely accepted when linked to key business initiatives such as improving spend management or improving pricing within a certain product category. SAP HANA Calculator To make it easier for people to build a value-based business case. We strongly recommend that when you calculate a benefit you apply a benefit range with a conservative and likely metric based on the SAP Value Engineering approach described above. However. The benefit as described in the process areas is typically related to its impact on revenue and expenses. discussions with the business unit sponsors ensure linkage to strategy and acceptance of the SAP HANA investment. The benefit ranges are based on the SAP Value Engineering triangulated methodology we just described. an organization needs to establish baseline metrics before it can calculate the value of a benefit. Specifically. (We discuss the SAP Benchmarking database in greater detail in Section E. SAP Value Engineering performs this function by providing a triangulated approach to benefits quantification.Associated IT effort to maintain profitability reporting Current state profitability level of the associated item tracked on the report As stated above. and key baseline information for your particular organization. D. One final point: It is commonplace to link benefits to an overall initiative involving process improvements through technology enablement. and high-impact strategies to organizations that choose to leverage the program. and sales. SAP Value Management Center (https://valuemanagement. supply chain. These data are incredibly deep and rich. SAP Benchmarking is a global program launched in 2004 to deliver empirical metrics. procurement. More than 700 KPIs More than 1. This portal offers direct access to complete surveys and analysis of results.com).000 participants from more than 3. The data in the benchmarking resources are collected anonymously from SAP customers who have participated in the program. best practices. and they enable you to benchmark your company’s current state and potential value against real-world experiences from other companies in your industry.One of the most valuable resources available to you when building an SAP HANA business case is the SAP Benchmarking database.000 companies Global — in 2010 more than 60% participants of participants were from outside North America Partnerships with ASUG and other user groups Studies available in 12 languages More than 20 business process assessments including finance. The link takes you right to the portal to sign in and utlize the surveys to capture baseline information and determine how you are performing against best in clauss organizations.sap. SAP Benchmarking program Facts: Established at the end of 2004 Complimentary service Available to SAP and non-SAP customers More than 12.000 best practices More than 300 peer groups . SAP Benchmarking is managed through a customer portal. This is a significant investment by SAP to allow organizations to measure performance and build benefit cases. previous “rules” about internal business cases may not apply to SAP HANA cases. Over the years. Although there is no set format for final deliverables. SAP addressed this problem by introducing Value Engineering. however. To accomplish this objective. a practice that focuses on driving the customer value that IT is providing to the business. and measure successful business-driven IT projects. The SAP Benchmarking program allows you to help choose a few key process areas to determine where SAP HANA best fits as a starting point. Fortunately. The program provides the flexibility to create a customized survey to capture the key metrics and best practices identified through the SAP HANA business scenario development. which we list below. A. and through maximizing return on IT investment. SAP launched a High Performance Analytics survey to track the importance of complexity and speed in the data management environment. SAP has learned a great deal about how the best-in-class companies continuously select. Accordingly. 1. because senior management buy-in and commitment and are critical. SAP HANA can impact many business process areas spanning the entire organization. In addition. execute. Despite this realization. . the presentation needs to be easily consumable by senior business executives. In addition. and it can assist with your final presentation. on budget and on value. SAP Value Engineering has standardized and packaged these best practices to help organizations deliver value by aligning IT with business goals and processes. SAP offers the Business Intelligence and Enterprise Information Management data sets and surveys. SAP Value Engineering has significant experience creating successful business cases for SAP HANA. Utilizing an ongoing processes called Value Management. SAP HANA is a disruptive technology. Internal Deliverables As mentioned throughout this chapter. As discussed previously. This process will provide the critical peer comparison that establishes the appropriate range of improvement.For SAP HANA. Tying It All Together We now shift our focus to the fourth and most vital stage in the business case process — packaging the business case in a manner that maximizes the likelihood that it will be funded. successful presentations generally contain certain critical components. Ongoing Value Management Most companies realize that the successful utilization of information technologies is critical to success in the modern business environment. Value Management Value Management is a permanent management process that ensures that investments in information technology are delivered on time. Use case and business process scenarios Financial and non-financial benefits Strategic alignment discussion Risk assessment Use case prioritization B. the storyline and financial impact have to be communicated effectively to the stakeholders and decision makers. few companies actually realize the maximum value of their IT investment. An organization can build a realistic benefit range improvement by leveraging peer benchmarking data. industry practitioners. consultants. and to deliver on these agreed-upon commitments. yet only 35% focus on measuring the value of these technologies after they have been implemented. they never fully realize their expected results. The Value Management methodology is intended to keep companies focused on choosing the right projects. Why Do Customers Like SAP’s Value Engineering Process? Quick turnaround process that delivers a strategic value proposition to customers in weeks Minimal disruption to customers’ ongoing operations using our collaborative approach Fact-based. leveraging comprehensive knowledge about best practices across industries and business . measure progress during implementation. to clearly define ownership and accountability for business results. execution.000+ customers. they lose this focus. Research conducted by SAP indicates that 98% of companies can extract more value from their initiatives. however. Why Is Value Management Important? Many companies initiate technology projects with a strong focus on their business objectives. This “virtuous circle” of proper planning. over time. 3. SAP’s approach to value management focuses on helping you discover the right projects.The discipline of Value Management is a proven way to realize the promised value from IT investments and initiatives. The SAP Value Engineering team helps identify the appropriate strategic areas to enable companies to become best-run businesses. and centers of excellence professionals Mature value management methodology based on experience with 25. Value Management Drivers and Lifecycle: Value Discovery: How do you align your business and IT strategies? Value Realization: How can the business value be captured? Value Optimization: How can you maximize the value from your investment? 2. and ongoing value analysis is critical to building a strategic IT function in successful companies. structured problem-solving approach that leverages past engagement experiences Hands-on participation from SAP experts — solution specialists. As a result. and optimize investments across your IT portfolio. Failure to realize maximum benefit from IT is a common problem that can understandably discourage executives from making the strategic IT investments needed to compete in today’s unforgiving business environment. This end-to-end process helps to ensure the business value of your IT investments. 5. disciplined approach to business value assessments that establishes a common language between business and IT audiences 4.processes Scalable. ideally as a formal methodology. such assessments are mostly subjective opinions that are not easily validated. If you’ve already identified several potential use cases for SAP HANA. In contrast. Among other things. The remaining stages in the cycle are Realization and Optimization. Continuous Value Management At this point. This kind of measurement philosophy needs to be deeply ingrained in the culture of an organization. VE resources can help you create a financial justification for the initiative. you have completed the Discovery portion of the Value Management Cycle described earlier in this chapter. if you’re willing to invest the time in a more immersive process. The Discovery phase resulted in the all-important business case. VE offers a SAP HANA Value Discovery Workshop. it certainly can make the process easier and more efficient. 6. However. but the other two phases are no less critical to the process. One strategy to ensure continued success throughout the implementation of the SAP HANA initiative is to maintain (or establish) a “culture of measurement” within the organization. However. In many organizations. objective assessments minimize the element of personal bias and enable historical comparisons of assessments for different projects. here are some of the questions that you should consider when measuring performance: . Role of SAP Value Engineering Utilizing SAP Value Engineering is not a requirement for building a solid business case for SAP HANA. Establish a “Culture of Measurement” How serious is your organization about performance measurement? It’s nearly impossible to determine the degree of success of a project unless you have a way to compare the “before” and “after” states. which was described in greater detail earlier in this chapter. What are some of your most important KPIs? What are some of the underlying metrics that you track? How do you track and communicate metrics and KPIs? What adjustments does your organization make based on regular reviews of KPIs and metrics? Are there any “new” KPIs that would be relevant to your organization but have not been adopted by your industry peers? Recommendations The purpose of this chapter is to explain why it is critical to build business use cases and to provide some guidelines to assist you with this process. Initial success will build credibility internally The resulting support may be necessary later when you plan and undertake more ambitious projects 3) Don’t view technology or IT as merely an expense or overhead. try to go beyond ideas about what you could be doing better. but start small with a quick win to build momentum in business. Consider: What you can’t do today What you haven’t even imagined yet 2) Think big. This is a business case. however. not a technical justification . we did not intend this chapter to be used as a “cookbook” for building business cases for SAP HANA. Whatever your situation. Different organizations may follow widely varying approaches when building their internal justifications for SAP HANA. technology and IT act as a: Strategic enabler Value creator 4) Track both hard and soft benefits during the financial analysis of use cases. Hard benefits are easier to calculate precisely Soft benefits may outweigh hard benefits 5) Ensure senior executive buy-in and sponsorship from Day 1. However. we strongly recommend that you keep the following points in mind during your journey: 1) When identifying use cases. When leveraged properly. 000 programmers. just as NASA didn’t stop innovating and exploring after the first moon landing more than 40 years ago. SAP realized the completion of this dream with the announcement of the availability of the SAP Business Suite powered by SAP HANA (SoH). But. we’ll . the team proposed several ambitious goals (dreams. SAP thus became the first software company to provide its customers with an integrated. 2012. less than two years after the first shipment of SAP HANA. In a nutshell. Having created this modern platform to power its flagship applications such as ERP. (3) Become a people-driven enterprise: SAP Business Suite powered by SAP HANA will help organizations become a people-driven enterprise by providing your business users with actionable insights — on any device — to decide and act SIMPLER. this was SAP’s “moon shot” declaration. SAP has created an exceptionally performant database platform that was engineered to its exact specifications and that provides a myriad of incredible new capabilities that previously were unavailable to its 20. For the first time ever. Simo Said and Amr El-Meleegy (@Meleegy). It might appear that with the delivery of SoH in 2013. SAP Business Suite powered by SAP HANA enables its customers to drive their business “smarter. most mission-critical enterprise systems in the world.Chapter 4 SAP Business Suite Powered by SAP HANA This chapter was written with the expert assistance of Puneet Suppal (@puneetsuppal). SAP had reached the end of its journey. faster and simpler” and do amazing new things that could never be done in a disk-based architecture. On January 10th. consolidate and consume real-time data FASTER. The most audacious goal was that this new database architecture would eventually be able to power the largest. In this chapter. when the project that would result in SAP HANA was in its infancy. SAP is simply transitioning into its next phase of innovation and renovation. SAP Business Suite Powered by SAP HANA Solution Marketing Team In early 2006. really) for the eventual capabilities of an enterprise-scale in-memory database. (2) Become a data-driven enterprise: SAP Business Suite powered by SAP HANA will help organizations become a datadriven enterprise by allowing you to collect. In many ways. SAP has begun a multiyear effort to achieve three basic objectives: (1) Become an innovation-driven enterprise: SAP Business Suite powered by SAP HANA will help organizations become an innovation-driven enterprise by allowing you to rethink business processes as and when needed and invent new business models SMARTER. real-time business process platform that unifies both analytic and transactional data into a single architecture. discuss several scenarios for adding SAP HANA to SAP Business Suite landscapes. reporting. real-time data platform. The SAP Business Suite can now provide real-time planning. Because SAP HANA provides a unique ability to deal effectively with both transactional (OLTP) and analytical workloads (OLAP). Employing the same database to address a company’s analytical and transactional needs eliminates the necessity to replicate data and/or integrate additional reporting/analytics landscapes. 2. such as machine sensor data and social media feeds. and analysis across end-to-end business processes.1. The SAP HANA platform provides the foundation for companies both to dramatically increase the performance of their existing SAP Business Suite applications and to continue to innovate without disrupting their current systems by leveraging a new generation of real-time applications natively built on the platform. examine the architectural implications of running a mission-critical SAP Business Suite landscape on SAP HANA. provide some details on several of the enhanced business processes/scenarios that will immediately benefit from the power of SAP HANA. 3. technical limitations in the database layer have forced companies to build two . companies can rapidly simplify their IT infrastructures — and reduce the total costs of ownership — by consolidating analytics and transactions into a single database. across SAP applications as well as non-SAP systems. Overview SAP Business Suite powered by SAP HANA (SoH) delivers a modern. companies can utilize SAP HANA as their primary database for SAP Business Suite applications and provide real-time analytics on live transactional data. and 4. Architectural Implications of SAP Business Suite powered by SAP HANA Over the years. 360degree views of real-time information. on many devices. execution. In this integrated scenario. It can also provide business users with unified. review some technical and operational aspects of this switch. It is the perfect starting point to begin taking advantage of a true real-time data platform. integrated suite of businesscritical applications that unify analytics and transactions into a single in-memory. more transformational shift is underway. As a result of this “performance dichotomy. Nearly every application in operation today was constructed in a programming approach where data are transmitted from the database to the application. you can report against them live. It was simply impossible for disk-based databases to efficiently handle both row-based transactional “writes” and column-based analytical “reads” at the same time.” database management systems currently on the market are typically optimized for either transactional workloads or analytical workloads. Because SAP HANA can process transactional and analytical workloads fully inmemory. companies can truly become “real-time businesses. Not only do these . As transactions are happening. By consolidating two landscapes (OLAP and OLTP) into a single database. another. and it significantly reduces the amount of data being moved in and out of the database. where they are then transformed for calculation by the application logic or algorithm. SAP HANA is the first commercial database system that successfully eliminates this false performance dichotomy as well as the resulting need to develop and maintain separate OLTP and OLAP systems.” Beyond the architectural simplification and cost savings that SAP HANA can bring to enterprise architectures. rather than simply serving up chunks of data to the apps. In contrast. or even to build traditional tuning structures to enable that reporting. Applications thus become much “leaner. SAP HANA provides companies with massively lower TCO (Total Cost of Ownership) in addition to mind-blowing speed. This “bring the data to the algorithm” approach was necessary because a disk-based DBMS has very limited capability to do anything more complex than rudimentary calculations. With all the relevant transactional and analytical data integrated in a single system that is updated in real time. SAP HANA enables application developers to completely flip that model on its head (see Chapter 8) and begin to leverage the system’s incredibly powerful engines inside the database. Developers can now extract data-intensive operations and algorithms from the application layer and insert them into the database layer for execution. Compounding this problem is the fact that data have to be copied between the two systems. This inefficiency not only generates significant costs. A final issue is the inevitable lag time that occurs when transactional data are exported to analytical systems on a daily or weekly basis. You don’t need to take the time to load data from your transactional database into your reporting database. This new “bring the algorithm to the data” approach is much more elegant than the old way of programming. but it forces organizations to adopt measures to ensure data integrity and usability between multiple systems. from the same database tables. the database becomes a “data engine” that spits out the “answers” whenever they are needed. In essence. but not both. it combines the best of both worlds.” and they focus on business logic.separate software/hardware landscapes to provide both OLTP and OLAP systems to address two different business needs: transaction processing and reporting/analysis. on the raw data. so they will not modify the existing business logic when a company adopts the new system.e. Significantly. All “HANA-fied” reports and transactions can be activated via the switch framework.000 to 20. Going further. SAP has made the migration to SAP HANA as painless as possible. what do I . The new architecture removes the need for Operational Data Stores. You might be asking yourself. Remaining batch processes run faster. please see the latest release notes for SAP SAP HANA Live Operational Reports Operational reports now run in real time inside the SAP Business Suite. however.e. These features ensure maximum flexibility in the consumption of these optimizations while minimizing business disruptions for the companies that implement them. but what’s the downside?” More specifically.000 times. Going forward. Operational Topics with SAP Business Suite powered by SAP HANA By now it should be obvious that adding SAP HANA to an SAP Business Suite landscape provides several major benefits. they also gain additional exponential speed by executing core application logic and algorithms inside the database. Interactive reports allow users to trigger OLTP transactions from the report. It eliminates the need to reconcile source data with copies. Not every transaction will receive this treatment because not every transaction will be able to take advantage of these new database capabilities or the value of renovating the transaction won’t be justified by the performance improvements. For details on SAP HANA optimized ABAP programs. This is when companies begin to realize process performance increases of 50.new apps increase performance by having fast access to data in memory. all of these switches are reversible and can be activated independently. essentially turning them into “on demand” jobs. It eliminates the necessity to transfer (ETL) for performance reasons. Custom ABAP code Existing core code modification limitations apply (i. SAP will deliver “HANA-fied” versions of multiple transactions in the SAP Business Suite through regular Enhancement Packs. Here are a few of the benefits this new architecture provides to existing SAP Business Suite customers: Applications You no longer have to run dialog processes in batch (i. “bad code is still bad code. Next-generation Applications Embedded Analytics can now be performed on a single system. ranging from increased performance to reductions in cost and complexity. A lot more information on this topic is available in the Application Development with SAP HANA chapter. “OK.. Regression tests for custom code are recommended after SAP HANA migration.. “Batch is dead”). it just runs faster”). Modification — Same upgrade requirements as with any new release. Customization — Stays the same. there really isn’t much more involved in migrating to this landscape than copying the data from your old database into SAP HANA and then turning on the new system.have to change in my current SAP Business Suite system to get all this goodness? You might be surprised that the answer to that question is “very little.” In simplistic terms. BADIs still supported. Security — Stays the same. SAP has invested a huge amount of effort and resources to ensure that the migration process is as painless and risk-free as possible. Several of the features of your existing system remain the same: Configuration — IMG stays the same. SAP HANA Enhancements Dynamic analytical privileges Reuse of same analytic privilege for several users with different restrictions Support for complex logic and situational security derived at runtime Roles as design time objects Offering full lifecycle management capabilities . Connectivity — Stays the same. with enhancements. ABAP Workbench — Stays the same. The company has even provided a one-step migration wizard and an RDS package to manage the entire process (check the RDS site for more details). Audit logging improvements New audit events (e.New “Support Role” Secure and enhance compliance process for productive systems.1 High Availability (HA) and Disaster Recovery (DR) scenarios . ALTER USER) Data access logging Audit configuration in SAP HANA Studio Transports — CTS stays the same Delivery via standard transport tools. SAP HANA specifics as TLOGO objects (ABAP based) CTS+ transport integration ready for custom SAP HANA code Monitoring — DBACockpit and Solution Manager stay the same SAP Solution Manager offers complete solution for operations SAP HANA monitoring and alerting integrated into SAP Solution Manager 7.1. Support Package 4.g. see note 1747682 End-to-end workload analysis for SAP HANA planned for Support Package 8 in Solution Manager 7.. HA and DR scenarios are supported New with SAP HANA SPS5 (November 2012): SAP HANA synchronous system replication (formerly known as “warm standby” solution). Further feature extensions are planned for the next service pack. Flexible appliance platform Third-party tools (e.g., agents for monitoring and scheduling, antivirus) allowed to run on appliance Third-party backup tools supported with SAP HANA (ongoing) Migrating to SAP Business Suite powered by SAP HANA Another question you might be asking yourself is, “How do I get to SoH from where I’m at today?” SAP will continue to provide customers with choice of database platforms, as it always has. Customers who choose to migrate to SAP HANA must take three steps to incorporate their existing SAP Business Suite on top of SAP HANA: 1. Update to the latest non-SAP HANA enhancement package and the latest version of the SAP NetWeaver technology platform 2. Update to the latest enhancement package version for SAP HANA 3. Migrate from any database to SAP HANA These requirements notwithstanding, however, SAP remains committed to supporting its customers’ choice of database technologies and vendors. The company will continue to offer the SAP Business Suite on all currently certified databases and to collaborate with its database partners to support continuous innovation of its applications on a variety of databases. The major downside to staying on an “old” database on your “new” SAP Business Suite — besides the costs and complexity inherent in disk-based databases — is that the “HANA-fied” transactions that SAP delivers with each enhancement package won’t work with your “old” database. You’ll continue to receive new transactions and industry functionality, but they will run much more slowly than they would on the new system. In addition, you won’t be able to use any of the HANA-fied transactions that SAP delivers. That said, migrating to SoH isn’t an “all or nothing” proposition. Companies can add SAP HANA to their SAP Business Suite systems in several ways. However, a few caveats apply, because not all of the enhanced functions that were designed for SoH are compatible with non-HANA databases due to their disk-based architecture and lack of in-memory capabilities. Current restrictions: SAP Business Suite Powered by SAP HANA — SAP Note 1774566 General Requirements Optimizations for SAP HANA require all relevant systems to run on SAP HANA (i.e., Development, Quality Assurance, and Production). Implementing an SAP HANA-based ABAP correction requires an SAP HANA-based correction system. Testing an SAP HANA-based ABAP correction requires an SAP HANA-based test system. SAP HANA-based systems interact with non-SAP HANA-based systems. In mixed ERP landscapes (several ERP’s) transports from non-HANA systems into HANAbased systems are supported. Non-SAP HANA-based development can be transported to SAP HANA-based systems SAP HANA-based development can be transported into non-SAP HANA-based systems, if the development is activated only after the system is manually activated. All optimizations specific to SAP Business Suite powered by SAP HANA require a dedicated Business Function activation to be enabled. During upgrade, all code pertaining to SAP Business Suite, powered by SAP HANA is deactivated and is running smoothly on non SAP HANA-databases. Dual-Stack Systems and it does not currently support dual-stack (ABAP/JAVA) installations. SP01 EHP 6 for HANA Optimizations by transactions and ABAP programs — please see attachment in this SAP Note: 1761546 Current Restrictions SAP EHP 6 for SAP ERP 6.com/docs/DOC-14257.40 — 1789659 Overview Suite on HANA Restrictions: 1774566 SAP CRM Customer Relationship powered by SAP HANA http://help.sap. version for SAP HANA SAP ERP powered by SAP HANA Release Notes for SAP EHP 6 version for HANA. version for SAP HANA SP1: Release notes SAP EHP6.sap.com/soh Enhancement Pack Info (SAP Note 1774566) SAP enhancement package 6 for SAP ERP 6. Java stack stays on the current database.0.0.0.g. because Java is not yet supported to run on SAP HANA (in a Business Suite app server). Unicode SAP HANA runs natively on Unicode only.sap. please subscribe for the latest updates: https://websmp202.0. version for SAP HANA . Dual-stack systems have to be split prior to an SAP HANA migration. relevant for Unicode conversion): Find more details on system copy and migration: http://scn. table split for parallelized export of large tables Combined Unicode conversion and database migration Reduced downtime for system copy (e.version for SAP HANA — 1768031 Release Restrictions for SAP Netweaver AS ABAP 7. version for SAP HANA SAP enhancement package 2 for SAP CRM 7.40. version for SAP HANA SAP enhancement package 2 for SAP SCM 7. Unicode conversion can technically be performed during the database migration.. powered by SAP HANA is based on SAP NetWeaver 7. SAP Business Suite powered by SAP HANA: Resources http://help.com/crmhana Release Notes for SAP EhP 2 for SAP CRM 7. but certain preparatory steps are required.sap-ag.SAP Business Suite.0. version for SAP HANA. see SAP Note 1680769) Several parallel processes for data export and data import.de/~form/sapnet?_SHORTKEY=01100035870000755177 SP0: Release Notes SAP EHP6. Minimizing Downtime Near-zero downtime approach: Use additional shadow database to keep DB downtime to a minimum (available on request. SAP Invoice and Goods Receipt Reconciliation.. SAP CRM).sap. . SAP HANA Live provides the following benefits: Views for easy analysis of SAP Business Suite data with SAP HANA Open for a wide variety of reporting frontends Maintained by SAP Operational reporting based on real-time Business Suite data Foundation for a new class of analytics applications The SAP Live enables you to very efficiently build operational reporting on SAP Business Suite data. and SAP Access Control Role Analytics.Optimizations and current restrictions. SAP Supply Chain Info Center. Based on analytical views in a virtual data model (VDM). which remains SAP’s core enterprise datawarehouse for consolidating data from SAP and Non-SAP sources. Please note: SAP HANA Live is available as a separate package for SAP Business Suite. Think of this new capability more as an upgrade or a real-time evolution of standard ABAP and ALV reports. SAP ERP. SAP HANA Live provides users with new strategies to analyze operational data to build their own reports and documents.0. in spite of all these great capabilities. Going further. DSO scope. SAP HANA Live also serves as the foundation for a new class of analytic applications including SAP Working Capital Analytics.com/scm_hana Current restrictions: SAP EhP 2 for SAP SCM 7. The current offering contains predefined analytical content for SAP Business Suite applications (e. please see SAP Note: 1768032 SAP SCM Supply Chain Management http://help.g. version for SAP HANA — 1768043 Scenarios for Adding SAP HANA to SAP Business Suite Landscapes Companies can utilize several methods to integrate the power of SAP HANA into their existing SAP Business Suite environments. It is basically a pipeline directly into the transactional tables under an SAP Business Suite system that allows you to display real-time operational data in a very flexible and user-friendly format. These methods can range from simply adding a SAP HANA Live deployment in side-car mode to fully migrating their entire landscape to SAP HANA as the primary data store. it does not make SAP BW obsolete. New SAP HANA Live for SAP Business Suite The new SAP HANA Live for SAP Business Suite provides an open environment that enables business users to perform operational analytics and reporting on real-time SAP Business Suite transactional data. These views form a virtual data model that customers and partners can reuse. Real-time Because all reporting is based on primary data (or a real-time replication of it). enabling a common reporting across application boundaries. the cycle time from recording to reporting is dramatically reduced. enabling fast analytics on high data volumes and high levels of data. . but it serves as a foundation for future SAP analytic development. SAP HANA Live for SAP Business Suite provides the following advantages compared to regular reporting solutions: Open Any access to the reporting framework is based on standard mechanisms such as SQL or MDX. Fast The suite features SAP HANA as the underlying computing engine. there is no need to wait for data warehousing loading jobs to finish. Data provided by the virtual data model can be presented through multipurpose analytical UIs such as SAP BusinessObjects BI Suite UIs and domain-specific Web applications. Thus.The SAP Business Suite application data models — enhanced for real-time data throughput and top performance in transactional scenarios — are optimized for analytic purposes using views in the SAP HANA database. No BW modeling or ABAP programming is required. Uniform A single approach is chosen for all Suite applications. Not only does this model benefit current users. Intuitive The virtual data model will hide the complexity and customizing dependencies of our Suite data model to make data available without requiring users to possess a deep understanding of the various SAP models. From a business value perspective there are 3 broad categories of In memory based application that are available today from SAP. 1. These Customer Engagement applications can also help you understand the present and future value of your customers and be able to segment and stratify them into core. . This was not possible in the past because customers could only rely on Revenue and Margin numbers to analyze their customers. These solutions can help transform the way you run your business. marginal and service drain customers and develop distinct and targeted sales and marketing strategies for each of them.More Details: http://help. Furthermore. and buying power into the equation all based on real time information. loyalty. Customer Engagement Applications First and foremost there are the Customer Engagement Applications categories. order frequency.com/hba SAP HANA Live for SAP Business Suite English SAP HANA Live Browser Last Update: February 2013 SAP HANA Live for SAP CRM English SAP HANA Live for SAP CRM Last Update: February 2013 SAP HANA Live for SAP ERP English SAP HANA Live for SAP ERP Last Update: February 2013 English SAP Invoice and Goods Receipt Reconciliation Last Update: February 2013 SAP HANA Live for SAP solutions for GRC English SAP HANA Live for SAP solutions for GRC Last Update: February 2013 English SAP Access Control Role Analytics Last Update: February 2013 SAP HANA Live for SAP GTS English SAP HANA Live for SAP GTS Last Update: February 2013 SAP HANA Live for SAP SCM English SAP HANA Live for SAP SCM Last Update: February 2013 English SAP Supply Chain Info Center Last Update: February 2013 Real-Time Solutions powered by SAP HANA SAP and its partners are delivering a new class of solutions on top of the SAP HANA platform that provide real-time insights on “Big Data” as well as state-of-the-art analysis such as machine learning. you can continue to utilize the SAP NetWeaver® Business Warehouse (SAP NetWeaver BW) component — also powered by SAP HANA — as your enterprise data warehouse.sap. from enabling rapid. These are applications that help our customers build personalized 1-on-1 sales and marketing engagements with their customers and do things like run targeted and personalized marketing campaigns and deliver automated selling recommendations to their Sales Force. opportunistic. But with SAP HANA you can now look into the full picture and bring in other factors like cost to serve. pattern recognition. to even rethinking business models in your industry. sense-and-respond processes and targeted actions. SAP HANA apps can also help customers extend their SAP Business Suite powered by SAP HANA investments by providing them with a wide array of complementary use cases beyond their traditional business processes. and predictive capabilities. They also provide a low risk low cost opportunity for customers to test the SAP HANA Platform with tried and tested applications that solve specific industry business problems. Marketing or Supply Chain to optimize trade promotions. These are apps that are built around helping customers’ capture and analyze large amounts of both external and internal data to help them detect hidden trends and capture deviations and respond to market changes in real time. SAP Demand Signal Management powered by SAP HANA . syndicated data and social media data — to develop a consolidated view of market demand information that they can then leverage across their organization whether that is in Sales. One example in this category of applications is SAP Demand Signal Management which helps Manufacturing companies in Consumer Products. which retailers are complying with your promotions and detecting critical issues like out of stock to reduce lost sales. So if you are a Consumer Product company for example running a trade promotion instead of waiting for weeks after the trade promotion is over to understand how it performed in the market you can do that today in near real time by accessing and analyzing Point of Sale data directly from your retailers and understanding how your products are performing on the retail shelves. and Automotive industries enterprise their downstream market and demand data-like Point of Sale data.SAP Customer Value Intelligence SAP Account Intelligence 2. High Tech. Sense and Response Applications The second category is Sense and Response Applications. and inventory planning and launch new products. SAP Liquidity Risk Management Another example in this category is SAP Fraud Management. For instance. manage their liquidity risk and optimize their working capital. Building a solid real time understanding of their liquidity becomes a huge challenge when operating in such an environment. the workload (and cost) of the investigation team can be significantly reduced. with different currencies and across different and complex financial products. Planning and Business Optimization Apps Finally there are Planning and Business Optimization Apps. One of the problems that large banks face today is that they execute millions of cash transactions each day in different countries. investigate and prevent fraud. With that. the user can run simulations by testing fraud detection criteria. to determine the right level of severity and avoid excessive load of false positives to be sent to the fraud investigation . which are applications that leverage the Planning and Calculation Engine and Simulation capabilities in the SAP HANA platform to help companies leverage their big data to do things like better forecast their cash flows. One example of application in this category is SAP Liquidity Risk Management which helps banks manage their liquidity risk in real time. It’s estimated that trillions of dollars are lost every year by governments and corporations in fraud abuses. The application helps minimize false positive signals through real-time calibration and simulation capabilities on very large volumes of data. SAP Fraud Management uses the power of the SAP HANA platform to detect. Adding to that challenge there are new and stricter regulatory requirements that are being put into place after the recent financial meltdown that require banks not just to report on specific liquidity metrics but also to simulate these results based on different future economic stress scenarios.3. SAP HANA allows banks to consolidate large numbers of cash flows and run stress simulations so they can get a better understating of their liquidity risk profile. and present the facts to solve your most pressing business questions. SAP NetWeaver BW powered by SAP HANA Want a super-charged data warehouse? SAP Predictive Analysis powered by SAP HANA Real-time. in-memory predictive and next-generation visualization and modeling SAP Visual Intelligence with SAP HANA Gather. analyze.team. SAP Fraud Management powered by SAP HANA Below are a few more examples of new and existing SAP applications that are now powered by SAP HANA. SAP Sales and Operations Planning Integrated business planning to align your business to profitably meet future demand SAP Collections Insight . In addition by combining rules and predictive methods SAP Fraud Management users can optimize fraud scenario analysis. and adapt measures to changing fraud patterns to better prevent fraud situations from happening. . SAP Access Control Role Analytics Quickly Want a super-charged data warehouse? SAP BusinessObjects Explorer with SAP HANA Analytics and business intelligence at blazing speed My GreenSpot SAP is teaming up with the World Wildlife Fund (the world’s leading conservation organization) to preserve and protect endangered forests and their ecologies with SAP HANA One. SAP Accelerated Trade Promotion Planning Maximize trade with deeper and faster trade promotion planning SAP Invoice Receipts and Goods Receipts Accelerate your financial close while ensuring compliance with your corporate rules SAP Working Capital Analytics Monitor and analyze your Days Sales Outstanding in real time SAP Supply Chain Info Centre Fully exploit your Demand and Supply Planning data for better decision making. Preserve Your GreenSpot SAP HANA for Humanity We provide the necessary technology and the associated technical resources to help nonprofits and governmental agencies analyze and visualize their large data sets to solve pressing global problems.Turn revenue into cash faster with real-time mobile collaboration tools and collections information. Learn More Care Circles Find and deliver the best care. Care Circles is a free service that helps patients and their families find best practices in caregiving from experts and caregivers around the world. This tool provides a report that includes tailored recommendations for optimizations and scenarios based on your actual current production system usage data.com and then . Learn More Recalls Plus We track product and food safety so you don’t have to. Make a list. To obtain your personalized assessment. Receive alerts. you need to fill out the form at suiteonhana. Keep your kids safe. Learn More SAP Business Suite Powered by SAP HANA — Business Scenarios SAP has set up an automated tool call Business Scenario Recommendations for SAP Business Suite Powered by SAP HANA to help you find and assess the areas where SAP HANA will bring the most value to your company’s SAP Business Suite implementation. procurement. The entire process takes about 5–10 minutes. This ability to perform complex transactions and reports in “real time” is a significant boost to driving value within the enterprise. As part of this first wave of innovations. we will review the current SAP HANA–enabled business scenarios included in the SAP Business Suite. which in turn help key personnel make better decisions in a more timely manner.com/assets/business_scenario_recommendations/en/cross-industry. However. in this context. sales. consists of a comprehensive set of business processes that are enabled by one or more applications within the SAP Business Suite. if not impossible. Irrespective of the data source. consequently. A business scenario. this capability represents a wish that was difficult. SAP will then input your actual workload data into the tool and prepare a customized report that highlights the various scenarios that will benefit from adding SAP HANA to your SAP Business Suite landscape. See the details below for examples of scenarios in the SAP Business Suite that leverage SAP HANA.pdf SAP Business Suite applications using SAP HANA as (the only) database In this scenario. finance. much more frequently — by utilizing SAP HANA. to fulfill in the pre-HANA days. Business Scenarios that directly benefit from running on SAP HANA In this section. and Accelerated Organizational Changes Publishing draws primarily from HCM data. You can view an example of a typical business scenario recommendation report at this site: http://suiteonhana. *As of January 2013. marketing. For many business.upload a screenshot of your ST03N-Workload Monitor screen in your production system. Strategic Purchase Optimization utilizes data from multiple areas including Supply Chain Management and Procurement. SAP plans to integrate them at some point in the future. SAP CRM. the ability to perform certain scenarios more frequently enables businesses to perform more “what-if” type analyses.. and SAP Supply Chain Management (SAP SCM) can fully run on top of SAP HANA in an integrated manner*. the critical point conveyed in the following scenarios is that many of these business functions can be performed much faster — and.g. the SAP Supplier Relationship Management (SAP SRM) application was not available with SAP HANA. For example. SAP delivers optimizations for 23 business value scenarios across key lines of business (e. and HR) and more than 400 industry-specific reports to achieve unprecedented performance. . In some cases. service. applications including SAP ERP. Real-Time Financial Performance Managing performance from a financial perspective is becoming more crucial every day. fast financial close offers a single multi-dimensional database and shared functionality for accounting and consolidation. management of the impact of product and production cost across an organization for volatile resource and commodity prices. compliance. Real-time close helps ensure accelerated closing activities through faster processes. and transparency throughout financial close management. You need to manage operations and related performance successfully in today’s volatile business conditions: Integrated planning uses a case-driven environment that allows new planning scenarios and userinteraction scenarios. and faster reconciliation. reporting without data latency.and analysis-related inquiries and an ability to react to risks and opportunities exemplify the need for a transparent and efficient process to deliver financial information on time and accurately. It closes the books for all individual companies. . With deeper and faster insight down to the lowest level of detail.Fast Financial Close Real-Time Financial Performance Efficient Receivables Management Efficient Payables Management Central Treasury Exposure management Access Control Role Analytics Automated Cross-System Process Control Optimized Quote Management Real-Time Inventory management Efficient Procurement Strategic Purchase Optimization Maximized Asset utilization and Uptime Accelerated Organizational Changes Publishing Insight-Driven Workforce Cost Management Real-Time material Planning Instant Material Flow Control Comprehensive Engineer-to-Order Project Management Maximized Productivity and Profitability of Complex Projects Fast Financial Close A financial close defines the financial results of a group as required for presentation to external and internal stakeholders by valuating business activities from an accounting perspective. On-time results for all audit. process efficiencies. and comprehensive product-cost management analytics. it delivers quality at the source. A fast financial close is a core element of financial excellence. A corporate close for the group and subgroups and financial disclosures combine quantitative data with comprehensive qualitative information. and heterogeneous consolidation landscapes. Product costing enables the modeling and simulation of design-to-cost product cost in real time. Support for real-time. a common view across financials (invoices) and logistics (goods receipts). providing governance. Drill-through for simulation of organizational changes is available. and commodity paper deals. By reducing the number of days sales outstanding (DSO) and bad-debt write-offs and by managing billing disputes and collections activities. from bottom-line savings and risk avoidance to top-line strategic advantage. In addition. Exceptions in the process can be pushed to a mobile device to offer immediate action from everywhere. nearly all publicly listed companies now have a dedicated compliance function. Business executives can analyze roles to uncover hidden downsides and reduce the uncertainty of many financial and operational planning decisions. validating. similarity with other roles. Central Treasury Exposure management Treasury and financial risk management involves a variety of processes. Elimination of segregation of duties was initially a main reason to implement a solution to identify access risks. efficient. derivatives. But companies are now striving to evolve many risk and compliance tools. to increase the transparency of the working capital provided in the payment and working capital dashboard. . Using SAP HANA. central monitoring. present. and credit management. taking into account data from past. All information is in real time. role administrators can perform real-time analysis on the roles. It enables global financial risk management on the ERP software system at headquarters as the central integration platform. and workflows. Real-time and accurate insight into vendor-opened receipts leads to better scheduling of payment runs and provides flexible and automated payments in real time through parallelization of different payment runs. automation. Efficient Payables Management Payables management focuses on evaluating. foreign exchange.Efficient Receivables Management Receivables management is a core finance function to manage the payment of customer invoices. and future planning. data consistency. The platform offers a lower total cost of ownership. You need a holistic view of these processes to be able to respond to changes in a quick. such as reorganization. debt instruments. their usage. and archiving of an invoice. Support for increased effectiveness of receivables management offers algorithms to match incoming payments and invoices. and options for reuse to advise business owners about the most efficient usage to avoid creating new roles. freeing headcount to focus on value-added activities and processes such as collections. dispute. The treasury exposure hub is the starting point for analytical applications that provide key performance indicators. Support for this business scenario combines reports in payables and cash position to help payables clerks make the right financial decisions. and managing payments. Access Control Role Analytics As a result of the Sarbanes-Oxley Act in the United States and similar legislation in other countries. Key elements of the accounts payable process include integration. posting. The goal of receivables management is to optimize the working capital to enable investment and growth. e-invoicing becomes more prominent. and compliant manner. not batch. from cash and liquidity management to the management of financial transactions like money market. securities. standardization. but paper-based invoices remain. and traceability of business events for financial and external auditing. you can constantly monitor the credit risk of your customer base. The treasury exposure hub powered by SAP HANA is part of support for the comprehensive process of treasury and financial risk management. Close collaboration with the treasury team optimizes DSO. including various dashboards and performance improvements. The recommendations also embrace predictive information. you can centralize all data from multiple systems into a single repository with excellent performance and gain the ability to use complex business rules for detailed analysis. Real-Time Inventory management Inventory management handles the recording and tracking of stocks of materials on a quantity and value basis. It increases process efficiency in adjacent procurement processes such as purchase order or invoice processing. and execute decisions based on real-time data. Efficient Procurement Because of intense competitive pressure. These movements lead to a large volume of business documents. and provide complete visibility into end-to-end procurement activities. You can update plans. goods. Because SAP HANA lets you analyze massive quantities of data in local memory. Using SAP HANA. Provide top business intelligence reports in procurement side by side to help ensure that you get real-time data with high performance and a modern user interface. Real-time inventory management provides stock insight and monitoring with high performance to support demand-driven procurement. Optimized Quote Management Informed customers expect a superior sales experience. You aim to boost productivity and drive innovation to lower additional costs.Automated Cross-System Process Control You need process control to perform automated testing (focused on compliance) and continuous control monitoring (focused on compliance and on process efficiency and effectiveness). Using queries. Recommendations can also take into consideration orders and materials for sales representatives to offer the best quote in real time to customers when serving them. you leverage procurement software to relieve slow and costly paper-based processes. such as the conversion rate and time from quote to order and the likelihood of paying on time based on sales volume. Quote management thus gains importance as a step in this business process. entry. frequent errors. It covers the planning. competitive global supply chains. run simulations. SAP HANA enables smart and context-based recommendations based on historical customer and sales information. is available to enhance the user experience and improve the efficiency of the process. and transfer postings. and internal stakeholders want to use the almost unlimited amount of Big Data on sales. you often absorb increased costs for commodities. internal physical stock transfers. you must deliver traceable monitoring and remedial activities to demonstrate compliance. you keep business processes and systems under control. SAP HANA increases the usability and power of automated testing and monitoring. the results of complex inquiries and transactions are available at your fingertips. To drive cost-effective. . Individually tailored offers can be made to fulfill customer needs in a fast and user-friendly way. Support fast business decisions and user adoption with flexible configuration options for procurement analysis. Inventory management is also responsible for the performance of physical inventory control. and documentation of stock movements like goods receipts and issues. or services to avoid passing them on to your customers. It is essential to embrace these trends early in the order-to-cash business. and maverick spending. A huge amount of customer data from diverse categories must be captured in one quote. events. and analytics. Accelerate lengthy processing of purchasing documents that arises from a multitude of line items and a long purchase order history. disproportionately high transaction costs. An analytical monitor for inventory management. Because of increasing regulations and policies. reports. you look for new ways to get the most out of your assets by ensuring that they stay up and running. and reporting hierarchy. It delivers the results much faster and in a user-friendly transaction. SAP software streamlines planning such activities with maintenance work orders. The software now uses the power of SAP HANA to automatically preselect maintenance plans that are due. An inability to tap this information source quickly and easily counteracts your efforts to drive HR efficiencies and introduce agile business processes. projects. organization and cost center hierarchy. the resulting wait times have a direct bearing on the overall user experience and satisfaction.Strategic Purchase Optimization Pressured to reduce supply costs while maintaining high-quality output. Accelerated Organizational Changes Publishing The performance of HR applications and related reporting. remuneration and overtime based on master data. complete. you seek greater efficiencies and savings from your procurement operations. based on SAP HANA. Influence contract negotiations proactively by getting insight into sales planning and sales orders. campaigns. To remain competitive. The data can provide insight into the fully loaded cost of employees and real-time costs associated with operations. A centralized model facilitates negotiations and better supplier relationships. Determine which manager is responsible for the organization hierarchy and define logical views in the learning catalog to provide reporting and analysis without degrading performance. Real-Time material Planning . you need to handle multiple maintenance plans that must be scheduled frequently. and planning depend to a large extent on how quickly the software can work through hierarchies in any given context. you can schedule all existing maintenance plans within a specific time frame. and so on. With scheduling transaction IP30H. In traditional systems. Push HR structural evaluations and authorizations to SAP HANA to accelerate the definition of structural authorizations (who gets access to what). Maximized Asset utilization and Uptime In asset-intensive industries. You know that high-performance organizations employ spend-analysis tools. Offer companywide search for purchasing business documents to influence actual payment conditions and rebates. sourcing and process automation. Insight-Driven Workforce Cost Management Time and payroll processes create immense amounts of valuable operational data that can bring positive and negative trends to light. and real-time working environment and view of business transactions and business data related to the strategic suppliers. and time management data stored in payroll results. Hierarchical structures are based on organizational management or cost center in reporting and analysis. This approach helps ensure that the software processes only maintenance plans that are due and that no call objects are missed. and standardized procurement operations. More important. analytics. The functions include drill-down to employee and earning details for the fully loaded cost of employees. The feature avoids the need for any parameter restrictions. Effective and efficient payroll exception handling is based on real-time data through provision of rapid insight into payroll-related workforce costs and trends in core HR functions. Provide the purchaser with a comprehensive. this transaction is triggered at regular intervals using a batch program. mitigate risks. Early identification of critical materials (such as range of coverage below threshold. This functionality instantly updates supply network collaboration with the latest demand information to help suppliers react much faster. inventory without demand. Comprehensive Engineer-to-Order Project Management Project-driven procurement and progress monitoring are vital to executing complex projects successfully. and costs) in project execution. Project or program engineers cannot provide the information needed to decide on natural deviations (time. Faster re-planning allows more frequent MRP runs in shorter cycles by providing global. and a combined analysis of financials and logistics data enables decisions to be made for acting and reacting within a window of . Production planning and purchasing departments often make decisions based on outdated information from batch runs. and better due-date performance when only the required quantity is produced. overconsumed forecast. and deliver the best resource productivity and project profitability. This functionality enables better production-order sequences to help determine the fraction of demand needed for sales orders. leading to lower work in progress. enables faster decision making so you can act and react to real project execution work. production and sales suffer as a result. Support for monitoring and analysis of large projects and programs in real time lets you decide faster. including version comparison and combined analysis of financials and logistics data. crossplant planning where demand information is propagated faster through the supply chain. Real-time progress monitoring along the project lifecycle. The huge volume of real-time data and time-consuming transactions for maintaining or analyzing project data constrain project and program engineers in making decisions when needed. forecast demand. Maximized Productivity and Profitability of Complex Projects Monitoring of progress is a key to successful execution of complex projects. Project analysis and progress monitoring are time-consuming due to high volumes of data for complex. It creates planned orders or purchase requisitions for the missing material. lengthy projects. so that decisions can be based only on the data derived from periodic runs. Material receipts and requirements for selected materials can be checked in the stock and requirement list. and stock-transfer demand with inventory and expected material receipts. Support for this business scenario combines the speed and acceleration of SAP HANA and the integrated processes in the SAP ERP application for complex projects. New project line-item reporting with acceleration and improved user experience is available to support in-depth analysis of complex projects. Cross-project or program monitoring is even more challenging. Production planners can select MRP lists with problems and stock and requirement lists with a short range of coverage (when critical to performance). shorter lead times. quality. Instant Material Flow Control The results of MRP are stored in MRP lists. Faster reactions to demand changes reduce the risk of stock-outs and allow reduced safety stocks. This lets users run what-if scenarios in real time to make decisions faster regarding reallocation and outsourcing. The main challenge is the volume of data. Waiting for the relevant data to be provided slows engineers down significantly. unconsumed forecast. MRP is typically performed in timeconsuming batch mode. and so on) and a feasibility check of production orders can be done on the fly.Material requirements planning (MRP) determines material shortages by comparing sales orders. Progress monitoring along the project lifecycle can include version comparison. Indirect improvements through SAP HANA arise in production planning. and financials because of tight integration. .opportunity. controlling. materials management. we need to be familiar with the fundamental features common to all EDWs. security software. SAP NetWeaver Business Warehouse Product Management Introduction SAP NetWeaver Business Warehouse (BW) is the first SAP application to be “HANA-fied” to take advantage of the power of SAP HANA. Given the scope of this book. SAP BW provides many of the functions needed to install an enterprise-ready EDW. In addition. Many companies that implement an EDW will choose an alternate modeling tool based on features and functionality. To discuss the benefits of SAP BW Powered by SAP HANA. All EDW systems include a database and a data modeling tool. we’ll refer to many online resources for deeper technical details. a brief introduction to SAP BW and some recent history of its evolution is in order. they will need a content-management tool. Specifically. and many more. and it is particularly well suited to benefit from the speed and simplicity that SAP HANA can provide to applications. With this background. there are a number of other tools that companies need to add to complete their enterpriseready data warehouse. this is often easier said than done. SAP NetWeaver Business Warehouse (BW) SAP BW is an application that SAP developed in the 1990s. The major difference between SAP BW and these other EDWs is that the additional software elements that are “add-ons” in a traditional EDW are included in SAP BW. workflow capabilities. a master data manager. Many SAP customers work with SAP directly through influence councils and the global SAP User groups to define new features and validate content additions Customers frequently inquire about the differences between SAP BW and their existing EDW solution. As you might suspect. a metadatamanagement tool. . Also. Product Expert.000 SAP BW implementations globally. In addition. To answer this question. SAP BW has become a critical piece of the IT landscape. With more than 14. we’ll have to assume that readers are already familiar with SAP BW concepts. and they work together right out of the box. The challenge most companies face is integrating all of these software tools into one seamless operation. It is essentially an enterprise data warehouse (EDW) application that includes many built-in functions to create an end-to-end EDW solution.Chapter 5 SAP NetWeaver Business Warehouse Powered by SAP HANA This chapter was contributed by Storm Archer III (@stormarcher3). SAP BW includes a substantial amount of content based on best business practices. we’ll then illustrate the additional power and functionality that SAP HANA adds to SAP BW. This structure is referred to as the Layered Scalable Architecture (LSA) model.. A major limitation of most databases is that they were designed and optimized to manipulate transactional data stored in a relational database management system (RDBMS). an index of a slice of data from the BW system. Next. columnar system that allowed queries to operate up to 100 times faster than a disk-based system. BWA is an in-memory appliance that can be added to the SAP BW system landscape to provide query acceleration and to offload some SAP BW functions to the appliance. EDWs are a different breed of application entirely. More specifically. many of the performance issues (and related technical solutions) in the EDW are a direct result of this mismatch between the needs of the application for OLAP workloads and the OLTP design of the underlying databases. SAP BW offers solutions to customers who need to expand the included functionality. such as a cube. the introduction of BWA was the first real proof point for SAP that in-memory databases could provide the “magic bullet” to eliminate the horrible performance issues inherent in disk-based databases while simultaneously reducing the costs and complexity of the application that had to be built around these performance bottlenecks. user queries are directed to the in-memory columnar index of the data. To combat this problem. Specifically. As previously mentioned. but the customer needs to participate in a greater identity management solution (e. they were configured to provide the best performance for row-based inserts imported from OLTP applications. rather than to the physical data arranged in rows on physical disks in the BW system. This function is very similar to the way that Google indexes websites. Although the LSA model provides a foundation for developing data models. As OLAP rather than OLTP applications. This development was an important leap for many SAP BW customers who were experiencing difficulties due to the limiting nature of the RDBMS. Basically. SAP Identity Management Services. For an EDW to operate with the complex data needed for advanced analytics.) SAP BW and In-Memory Computing One of the fundamental aspects of EDW systems is their ability to manage multidimensional data (cubes) and to conduct analytical operations on those data. is copied to BWA and stored in RAM. SAP designed this shift to inmemory indexing for queries as a workaround to avoid the performance penalties that must be paid when users attempt to read large datasets off a disk-based database.In addition. the additional layers of functionality that are designed to work around the limitations of relational databases cause performance issues as the amount of data increases. EDWs almost never insert data into rows as an OLTP application does. the data warehouse application has developed functionality that circumvents the basic limitation of the database and provides better performance. In many ways. SAP introduced the SAP BW Accelerator (BWA) in 2005. .g. An example is a scenario in which the included security is adequate. SAP BWA provided an inmemory. these additional layers limit the flexibility of the system and place heavy workloads on the hardware. one key element of an EDW is a database. their primary role is to read data from the database and display them in reports or analytical views. Therefore. BWA is a caching engine rather than a database. SAP BW Powered by SAP HANA provides similar results for end user query response times. Below we provide examples of how in-memory computing both enhances performance and accelerates applications. This chapter will examine the benefits of replacing an existing database with or without SAP BWA with SAP HANA as the database. As with the SAP BW Accelerator. data loading. SAP BW Accelerator delivered approximately 100 times the query performance compared to a relational database alone. fact tables. one fundamental difference between the two systems. There is. In-memory computing improves performance in a number of areas. SAP BW 7.Figure 1: SAP BW and In-Memory Technology This description of SAP BWA sounds very similar to SAP HANA. EDW systems incorporated functionality — aggregates. and other features — into the LSA model. As SAP BWA matured. From the end user perspective. relational databases were not designed around multidimensional data models in the EDW. Some of these improvements also reduce both administration costs and total cost of ownership (TCO). SAP BW introduces new innovations to better support customers’ business operations. SAP provided additional engines and features. they generally identify specific areas that need improvement. the amount of data that businesses need to query and analyze has grown exponentially. query performance. SAP HANA can now take the place of a traditional RDBMS and an SAP BWA appliance. Today. however. SAP introduced the SAP BW Accelerator as a query accelerator. the availability of columnar databases and inmemory technologies has made these additional elements obsolete. query response time is often one of the primary elements in system performance. as we’ve already discussed. performance is one of the key drivers for in-memory computing. and software add-on/application performance. To overcome the limitations of the transactionalbased databases. In 2005. Of course. namely. Specifically. along with other valuable columnar database features. customer results have varied and will vary based on configuration and .3x offers a substantial number of improvements over traditional RDBMS configurations. Query Performance Over the past decade. SAP HANA — Specific Enhancements for SAP BW Companies typically implement SAP HANA to enhance their system’s performance and to process voluminous amounts of data. When companies evaluate their performance. Unfortunately. most commonly. With each release. SAP BW on SAP HANA has incorporated the query acceleration and engines from BWA. however. content. then. With their existing systems. Figure 2: Migration from SAP BW & BWA to SAP BW on SAP HANA Figure 3: SAP BW on SAP HANA Architecture Data-Loading Performance In contrast to SAP BWA. the need for real-time or near real-time data reporting has dramatically increased. improving data lifecycle management. . By reducing redundancy. the time required to extract data from a source system is fairly static and predictable. In an SAP BW with SAP BWA implementation. This is one area where this architecture can reduce both TCO and administration costs. they must obtain separate licenses for the relational database and for SAP BWA. however. In contrast. The general rule. This is where the intelligence and deep integration of the SAP HANA appliance and the hardware are able to reduce this time considerably. Some customers have reported query performance greater than SAP BWA. implementing SAP HANA as the database for SAP BW involves only a single hardware appliance and license model. when companies utilize an SAP BWA appliance. the customer no longer needs to manage multiple data sets. it generally comprises about 20% of the data load process. SAP HANA dramatically reduces a company’s TCO. is to expect similar query performance. From an administration point of view. They also need to maintain two sets of hardware and data. In the business environment for many SAP customers. The remaining 80% is spent on data activation and updates. customers have to maintain two systems. Further. SAP HANA provides much more functionality to the SAP BW than simply query acceleration. and eliminating hardware and license duplication. potentially millions or billions of round trips occur between the database server and the application server. Data Loading Figure 5: SAP BW on SAP HANA DSO Acceleration By utilizing the enhanced data-loading and analytic capabilities of SAP HANA. In addition. Data Model Efficiency . Many IT departments currently have severely limited windows for regular updates due to the global nature of business operations. the data-loading improvement was 10 times that of an RDBMS alone. we can safely use an average of 6 to 10 times as a guideline. SAP BW and SAP HANA enable IT operations to provide greater support to the business. customers have been able to provide their businesses with more rapid results to data and analytics use cases. By reducing dataloading times. then. the reduced load times enable them to run updates and analysis operations more often without severely affecting SAP BW operations. This arrangement reduces the number of round trips between SAP BW and the SAP HANA appliance to only a few. Customers have reported improvement rates ranging from 6 times to more than 20 times. With SAP HANA.Figure 4: In-Memory Execution in SAP BW The process of data activation requires business logic from the application to perform activation actions on the data updates. the business logic for the activation is passed to the SAP HANA appliance along with the data. Of course. the actual customer performance is dependent on a number of factors. When SAP was tested. When this business logic exists entirely in the application. Overall. Integrated Planning (BI-IP). The answer is that SAP HANA still utilizes info cubes. This efficiency generally leads to a further reduction in TCO. . thereby making the data model more efficient. the performance is improved by converting to the SAP HANA-optimized structures. While the old structures continue to operate with SAP HANA as the database. Customers have been able to reduce the need for info cubes dramatically and report directly against a DSO. SAP BW 7. including Strategic Enterprise Management (SEM). these applications utilize complete business logic as an integral part of the solution. although quantifying these savings is problematic.3x delivered programs to convert existing data store objects (DSOs) and info cubes into SAP HANA-optimized DSOs and info cubes. In general. the most common question is whether info cubes are still needed. The result is much improved performance from multiple areas within the application. and Corporate Performance Management (CPM). This process is known as “flattening” the LSA model. Application Improvement There are a number of add-in applications for SAP BW. (2) when additional transformations are needed. the number of round trips to the database server can be extremely large. but their role and use are more defined. info cubes are utilized only in certain specific scenarios: (1) when multiple DSOs are consolidated. EDW systems added specific functionality to enable the RDBMS to process analytic operations on vast amounts of data. The lighter LSA model structure that allows for more flexibility makes data modeling easier and more efficient. As with dataactivation processes.As mentioned earlier. When the application server has to host the business logic. SAP HANA makes it possible for users to eliminate many of these artifacts. These add-in applications are now being “HANA-fied” to fully utilize SAP HANA to process the business logic inside the database rather than up in the application layer. or (3) when an add-in application requires an info cube for specific operations. Figure 6: Conversion of SAP BW Data Structures In this new structure. In addition to the features discussed above. This flexibility allows for maximum options in data consolidation and reporting. “non-active” data. SAP has configured SAP BW 7.30 SP8 and SAP HANA SP5 to flag all PSA tables and write-optimized DSOs as non-active. the non-active data will remain on disk persistence until they are needed.SAP In-Memory Planning Figure 7: Planning in SAP BW on SAP HANA SAP BW Operational Efficiency and SAP HANA Model Interoperability SAP BW 7. Consequently. Figure 8: Open Hub Services SAP BW on SAP HANA Performance & TCO Benchmarks . virtual provider. SAP has been re-evaluating which data need to be in memory — that is. they will be the first data to be flushed from memory when they are no longer needed. Customers who have implemented these new systems have reported that SAP HANA memory utilization has been reduced by roughly 20%. Some of these innovations provide a database connect (DB connection). and open hub services to consume SAP BW and SAP HANA data. As database sizes in SAP BW landscapes have increased. transient provider. Significantly.30 SP8 and SAP HANA SP5 have delivered new efficiency and flexibility capabilities. In addition. SAP has incorporated greater flexibility in utilizing SAP HANA data models with native SAP BW models. “active” data — and which data can be loaded as needed — that is. com/solutions/benchmark/bweml-results.SAP HANA Performance Benchmarks: Customers frequently ask SAP about benchmarks to verify performance claims for both SAP BW on SAP HANA and SAP HANA standalone.experiencesaphana. Both options have their benefits and their challenges.com/community/blogs/blog/2012/11/12/the-sap-hana-one-petabyte-test Whitepaper — SAP HANA Performance https://www. SAP has released a formal benchmark test called BW EML (Enhanced Mix Load) benchmark. which considers: Near real-time reporting Ad-hoc reporting capabilities Reduction of TCO. Customers with a mature SAP BW environment typically consider an OS/DB Migration. Please see these links for more details and results: http://www.experiencesaphana.3 and higher The purely technical aspect of the implementation or migration is generally only a portion of the overall project plan.com/docs/DOC-1755 SAP HANA Performance: 100TB Performance Test Results http://www. Below you will find several links to the various performance benchmarks relevant to SAP BW and SAP HANA.com/docs/DOC-1647 Whitepaper — SAP and HP Breaking Analytic Performance Barriers with SAP HANA and HP AppSystems https://www.com/docs/DOC-1755 SAP has also conducted individual benchmarks with SAP customers who migrated their BW systems on RDBMS to BW on SAP HANA.experiencesaphana.sap. Other customers perceive an SAP HANA deployment as an opportunity to cleanse an existing environment by setting up a new landscape and manually transferring the configurations from an existing implementation to a new installation.com/campaigns/benchmark/appbm_bweml.saphana.com/docs/DOC-1769 https://www.experiencesaphana.sap.experiencesaphana.epx http://www. Implementation and Migration SAP customers who are looking to implement SAP HANA in the SAP BW environment have several choices to make as to the most effective way to carry out that deployment. Please contact your account team for results from SAP reference customers.com/docs/DOC-1769 Performance Test Report — SAP HANA https://www.htm In addition you can access the SAP HANA One Petabyte Test with a similar data model to what many SAP BW customers are using: http://www.com/docs/DOC-2381 TCO for SAP BW on SAP HANA https://www. Customers who choose to manually move configurations from an existing . Recently. MUST READ: Upgrade/Migration/Implementation — SAP NetWeaver Business Warehouse 7.experiencesaphana. The PCA tool provides a wizard-style interface that details the post-copy and postmigration steps to deliver an optimized system. In contrast. and postmigration review. Even in these cases. the greater the required project resources. Every installation is unique and has specific areas that require attention. object optimization. time. and implementation of new features. This person does not have to be an external. When a customer performs a migration.installation to a new implementation will need to address a number of challenges. Software Prerequisites for SAP BW on SAP HANA . it is often still advisable to work with a specialist who has been specially trained and is proficient with the following SAP BW-specific tools: Dual-Stack Split Tool Combined Unicode conversion and Database Migration Post-Copy Automation (PCA) tool Software Update Manager http://service. all customers should perform an in-depth project scoping and system analysis to determine whether migration or re-implementation is the better option. SAP. the various business units will request and require specific functionality as part of funding the overall project. sizing. before selecting a project course of action. however. or consultant. Project scoping generally defines the initial technical phases where customers can determine what functional elements need to be included in the migration. the overall project will run more smoothly and with a greater certainty of achieving the expected results. Companies often employ staff who are certified in migrations. customers who implement new installations will not experience many problems in these areas. Often. SAP has provided some additional tools they can utilize to expedite some of the technical steps. These customers often have to reach the minimum requirements (listed below).sap. As a general rule. the greater the functional scope. Customers who have migrated have determined that functionality can be implemented in a number of areas without significantly impacting their existing system. Once the project direction has been fixed. the next step is to determine what additional functional changes can be implemented as part of the initial project scope. all migrations should include an Archiving/Near Line Storage review. Customers often choose to break up the technical and functional phases of the implementation into different projects. and costs. SAP requires that a Certified Migration Consultant execute the production system activities. Figure 9: SAP BW Migration Process For customers who decide to perform an OS/DB migration. When these items are documented and addressed. In general.com/sltoolset In addition. should include a sizing exercise to determine what resources will be required for a successful productive go-live. Not all add-on software had initial support for SAP BW Powered by SAP HANA. they can be categorized as elements of the overall expected results.3x Central Instance installed on separate hardware. Additional System Requirements: SAP NetWeaver BW => 7. Sizing — Any project.Now that we have defined the basics of SAP BW and the associated architecture.3x Analytic Authorizations (Upgrade Requirement) SAP BW Add-on software packages support confirmed. Always check the SAP notes. resources. and review the corresponding ABAP code to run the check on your own system. These areas will be identified throughout the rest of this chapter. These resources . planning.0 support. Scoping/Sizing Topics for SAP BW on SAP HANA In any implementation. and TCO benefits. Check your SAP NetWeaver BW system for SAP HANA Readiness — free Checklist tool! Use the Checklist Tool developed by SAP Customer Solution Adoption (CSA) and SAP Development to automate the check of best practice guidelines for operations and prerequisites for migrating an existing SAP NetWeaver BW deployment to the SAP HANA platform. Check SAP Business Objects 4. these steps frequently involve additional time. and system downtime. most add-ons are supported with release-level requirements.3x Unicode Only SAP NetWeaver BW =>7. SAP BW provides installation options for both clean installations and upgrades. SAP BW and BW JAVA must be a split-stack implementation.30 Service Pack 5 (Ramp-Up Release) SAP HANA 1.0 Service Pack 3 (Ramp-Up Release) SAP BW 7. SAP HANA does not currently support SAP JAVA Usage Type. Upgrades can require additional steps. there are several inputs that affect the project timeline and budget cycle. it is time to consider what it takes to run SAP BW Powered by SAP HANA. whether a new installation or an upgrade. Please see SAP Note 1729988 for detailed how-to documentation. At the time of this writing. Going further. No sharing with SAP HANA Appliance. Below we list the minimum software requirements: SAP NetWeaver BW 7. Although some of these TCO improvements will be soft in terms of business efficiency. Project planning should lay out the scope. Disk storage requirements for Unicode conversions can vary. One additional factor for SAP HANA appliance size is based on two additional factors: 1. the database is re-organized. In general. This will reduce the effective overall compression that SAP HANA will achieve after migration. Typically. memory (SAP BW and SAP HANA). the basic rule is to expect a 6:1 compression rate. additional RAM is required for work processing space. the SAP BW system will require more CPU and memory when running Unicode. That link is http://service. The SAP Service Market Place also has a quicksizer available that will help customers approximate their system requirements. Figure 10: SAP BW on SAP HANA Landscape Options Upgrade project sizing can be a bit more challenging. Customers need to take into consideration the scope of the upgrade to determine the resource requirements. but the makeup of the data and the source RDBMS plays a significant role in determining the effective compression rate. Some customers have reported much higher compression rates.sap. Their SAP account executive can assist them in determining what initial sizing is required. and disk storage. SAP HANA uses sophisticated compression algorithms to compress the data. When applying the working RAM space required. SAP BW and SAP HANA releases. In some cases. In addition. Customers who are performing new installations need to determine how much volume and what scenarios they will implement. When a Unicode conversion is performed. . the expected compression is 3:1. the size of the data on their existing system is a direct input as to what sizing they require for the appliance and the disk storage. Some RDBMS already have some amount of compression. The current rule for working space is twice the amount of data RAM. SAP has provided an ABAP-based sizing tool. this process reduces the database size. Through the course of many implementations. Because SAP HANA is an in-memory database. One example is whether the upgrade scope includes a phase to perform a Unicode conversion. The amount of RAM required for a system depends on the amount of source data and the brand of database in the current system. When a company upgrades to SAP HANA. This compression affects how much RAM is required for the data. Data-archiving strategy (Archive and Near Line Storage) 2.are CPU. Please see SAP Note 1736976 for the program and more details. SAP has observed varying levels of compression. and all empty space between data blocks is eliminated.com/quicksizer. Some elements of the system require specific tuning and configurations to provide optimal functionality. NLS solutions have the benefit of reducing the size of the online database while still allowing queries to access the archived data if needed. SAP has defined some limitations on these configurations. According to initial customer reviews. Archiving and near line storage (NLS) follow a fairly similar process. Near line storage solutions also export older data. there are a number of possible configurations. In an SAP BW Powered by SAP HANA landscape. The size of some SAP BW systems will require a “scale-out” implementation of the SAP HANA appliance. The most common question that SAP receives is whether multiple existing systems can be consolidated into a single physical system to minimize hardware/system costs. SAP provides extended monitoring for all scale-out projects. For example. Landscape Options When implementing SAP BW Powered by SAP HANA. From the SAP HANA appliance view. Customers are technically able to put multiple SIDs on a single SAP HANA appliance. For more technical details on scale-out for BW/HANA: SAP NetWeaver BW Powered by SAP HANA Scale-out — Best Practices Customers who create an effective archiving strategy and implement the latest SAP BW release will be better able to estimate the required initial system size. Note that SAP HANA Appliances must be certified by both SAP and the hardware vendor prior to implementation. the configuration has to be certified by the hardware partner. This is specifically important in Productive environments. BW now automatically marks all PSA tables and all write-optimized DSOs as not-active. The sooner a company develops an archiving strategy. They are also the first to be flushed when they are no longer being used.30 Service Pack 8 and SAP HANA 1. the not-active data concept reduced the SAP HANA system size by approximately 20%. In addition. SAP still recommends that customers utilize separate hardware for each system. as we explain below. As stated above. Archiving is the process of exporting older data into offline storage. Below we discuss a number of configurations that SAP often observes at customer sites. customers need to consider some specific configurations. By default. The not-active data are loaded into memory only when they are needed. The challenge in this scenario revolves around the software lifecycle . Nevertheless. certain data are not loaded into memory by default. the applications servers and central instance systems are separate from the SAP HANA Appliance system. customers frequently combine SAP SIDs on one server. With the release of the updated SAP BW and SAP HANA. SAP recommends that all customers implementing SAP BW Powered by SAP HANA in a scale-out scenario register for extended monitoring with SAP Active Global Support. As with all SAP HANA implementations. but to a compressed online storage facility. This functionality is referred to as Active/Not-Active data. With SAP BW 7. they need to understand what software elements need to be run on dedicated hardware and when they can combine scenarios. the more manageable their system will become. In addition.SAP recommends that customers create a data-archiving strategy.0 Service Pack 5. SAP introduced new functionality. The archive solution requires that the data are restored to the system before queries will show the archive data. SAP recommends that each system utilize dedicated hardware. DEV/SANDBOX/TRAIN Systems that fall into the DEV/SANDBOX/TRAIN groups are those that tend to have lighter workloads. customers can elect to flag certain content as not-active. it is possible to run other scenarios on the same SAP HANA appliance that is the database instance for SAP BW. this hardware is specified as fail-over equipment for production. QA/TEST The Quality Assurance and test systems usually perform multiple functions in a project. If a system restore was required. and they should have more-than-sufficient resources to support business operations. backup and restore of an SAP HANA system were restricted to ALL schemas. This limitation could result in unplanned data loss. it released an SAP HANA Database Only Edition specifically for the BW system.and system management. When SAP made SAP HANA support available for SAP BW. The configuration will be similar to a production system so that load testing will produce representative results for the live production hardware. rather. on system performance for the business. both the SAP BW system and the SAP HANA system have to be considered. From a licensing perspective. Performance — When customers utilize SAP HANA. SAP HANA was originally released as a data mart platform. At the time of this writing. production application servers should be dedicated. then the other connected systems will slow down dramatically or even stop. Applications as well as the SAP HANA system have to be updated. SAP ERP. then all systems that utilize that appliance will be affected. even if only one schema restore was necessary. To avoid this problem. Customers utilize their hardware vendor’s SAP competency center to determine the appropriate configuration. If one application needs to be patched that requires a SAP HANA system restart. In some cases. but. Based on this foundation. . PRODUCTION Customers often will configure servers in non-productive systems to make maximum use of the hardware. Production is limited in two specific areas: performance and lifecycle management. or restarted at various points in the process. Lifecycle Management — The other major production issue is software lifecycle management. The application can be SAP BW. customers often will utilize this hardware as a load-testing environment. From a technical perspective. However. they select the amounts of CPU and memory that provide the maximum system performance for their business. the system uses as many resources as possible to return the best performance. In this configuration. The SAP HANA appliance can be more complex. This delay could cause unpredictable performance behavior within the system. Besides the QA/consolidation functions that are the purpose of the system. the focus should not be on maximum use of resources. If the SAP HANA system has to be restarted. This scenario could cause other processes to become very slow or to stop completely and wait for resources to become available before they continue. this system supports SAP BW only as a use type. if a process runs away for one SID. even those that are operating effectively. SAP has limited this combination use (license permitting) to a single application and a single data mart. then all of the connected systems will be affected. Further. or SAP Business Suite applications. SAP support generally recommends separating the systems. then all schemas in the databases would be restored. In production. patched. SAP recommends that ONLY ONE system be running actively on both the SAP Application and the SAP HANA system. When operations are run against the SAP HANA appliance. SAP will assist customers in . and configuration backup) Patches. managed. Bare-Metal software. Regular administration duties include: Regular backups (Database. As a general rule. SAP BW on SAP HANA Administration As with all software systems. maintaining. and maintained by the hardware provider. Their recommendations will provide a system layout that will generate the performance the business requires. Many of the hardware tasks are provided. OS) Monitoring (automated or manual) The appliance model breaks up the traditional roles that are housed primarily as part of the internal IT Operations.sap. regardless of the database platform. SAP has made available a number of tools to make administering the system easier and more consistent. Every software system has tools and functionality for operating. On the whole. SAP HANA implementations require administration. Other areas are the customer’s responsibility.com/hana_appliance).Figure 11: SAP BW on SAP HANA Landscape Options Implementation teams from SAP and partners will help design and guide the optimal landscape design based on customer input. SAP has provided a Technical Operations Manual (TOM) that contains a variety of topics for managing SAP HANA as an appliance (http://help. and protecting those systems. The following list identifies the primary focus areas of most IT organizations: Database Administration High Availability Disaster Recovery Backup/Restore Security To assist organizations in readying the operations for SAP HANA. usually on demand in case of problems or known issues (DB. SAP HANA needs less administration than other databases. the vendor should be taking advantage of the most up-to-date SAP-delivered enhancements (e.monitoring all areas to best support the solutions. Solution Manager SP8 will further extend SAP HANA Support with End-to-End Workload Analysis. Additional administration for SAP HANA is performed via the SAP HANA Administration/Modeling Studio. SAP has updated and enhanced its database management tools to provide a consistent and proactive interface for managing SAP HANA systems.1 SP4). all support tools continue to operate normally independent of the underlying database. The implementation and details of these services are the responsibility of the hardware partner. The table below should provide an overview of where the various administration duties are defined. New with SAP HANA SPS5: SAP HANA synchronous system replication formerly known as warm standby solution). For example. . Database administrators have a selection of tools to choose from to manage the SAP HANA system. When sizing the system for implementation. Within SAP BW. SAP has updated its SAP DBA Cockpit and SAP Solution Manager to support SAP HANA and provide alerting and monitoring (Solution Manager 7. High availability (HA) and disaster recovery (DR) scenarios are generally considered to be critical to production implementation.. Below is an overview of the current HA/DR solution. The SAP system includes functionality that provides these services.g. Security is also a critical element in any system implementation. SAP has delivered additional security functionality in SAP HANA SP5. Meanwhile. SAP are developing and delivering additional solutions as an ongoing initiative to meet the needs of the SAP customer base. and it extends that performance to data-loading and software add- . partners deliver agents and tools that provide for backup. antivirus. recovery. This latest support release contains the following additions: Dynamic Analytical Privileges Reuse of Analytic Privileges for several users with customizable restrictions Support for Complex Logic and Situational Security Roles as Design Time objects New “Support Role” Used to secure and enhance compliance processes Audit logging enhancements New Audit Events Data Access Audit Configuration via SAP HANA Studio Summary SAP BW Powered by SAP HANA offers a number of advantages over traditional Relational Database Management Systems. SAP HANA provides a similar query performance as the SAP Business Warehouse Accelerator. Today. Many customers have to comply with both reporting and regulatory requirements. and more. scheduling. Partners work with SAP to develop and deliver solutions that integrate with the SAP HANA system. SAP provides the necessary system features and functionality within the software delivery. monitoring. As with HA and DR.Figure 12: SAP BW on SAP HANA Data Center Architecture Backup and recovery is an area that customers will routinely test to ensure that all systems are protected. It also reduces TCO by combining the RDBMS and the SAP BWA Appliance into a single platform. SAP TechEd. This architecture reduces redundancy and complexity in the system landscape. The most common channels for obtaining enhancement updates are through ASUG Webinars . As SAP BW is enhanced and extended to utilize the power and functionality of SAP HANA. The content delivered through each of these channels is updated regularly to be as current as possible. and the SAP Developer Network (SDN).on performance. SapphireNOW and ASUG Annual conference. saphana. SAP will continue to provide regular updates to its customers at regular intervals. FAQ area for SAP NetWeaver BW Powered by HANA Figure 13: SAP BW on SAP HANA Roadmap .com. Chapter 6 Data Provisioning with SAP HANA COMING FALL 2013 . Chapter 7 Data Modeling with SAP HANA COMING FALL 2013 . Some of these advantages involve the core technical capabilities of the database. . conceptually similar in most ways to every other database you’ve ever worked with. you could simply keep your existing applications. and so on. Most importantly. Instead. We plan to incorporate additional languages and programming approaches in subsequent revisions. It speaks SQL and MDX. SAP HANA is compliant with the standard interfaces of all databases. with rows and columns. Basic Concepts SAP HANA is an ACID-compliant database. this chapter discusses how to use ABAP and SQL programming concepts in the new SAP HANA programming paradigm. The problem with this scenario is that SAP HANA offers capabilities that other databases simply don’t. In addition. Product Management. it has JDBC and ODBC libraries. Nevertheless. Second. most developers should obtain value from the chapter content regardless of their programming language experience. First. Director. building an application with these SAP HANA-specific advantages in mind will provide you with the maximum opportunities for innovative and responsive applications. you’ll have to let go of some of the “rules of gravity” that existed in the “old world” order to take advantage of all of the new capabilities that SAP HANA provides. we’ll avoid getting into too many code samples or deep technical discussions in this chapter. SAP HANA goes well beyond the traditional database to offer a full application and development platform as well as to extend capabilities in areas such as search. Before we proceed. the chapter focuses specifically on development in SAP landscapes. Therefore. to implement this system. SAP HANA-Data and Analytics Engine Product Management Given the high-level focus of this book and the growing inventory of technical knowledge that we will link to. In addition. we’ll focus on some of the most salient features of programming applications for SAP HANA that can maximize its speed and computational power. we need to make two important points. Therefore. redirect the ODBC or JDBC configuration. we composed this chapter with the assumption that you’re familiar with these concepts. which are superior to those of other databases. predictive analysis. and then run them as-is with SAP HANA as their new database layer. However. we’ll present examples of some of the new capabilities that SAP HANA provides to developers. it stores data in tables. there are quite a few key philosophical differences and cutting-edge development concepts that you need to consider when you’re writing apps that leverage SAP HANA as a database. and it requires administration and backup.Chapter 8 Application Development with SAP HANA This chapter was contributed by Thomas Jung (@thomas_jung). Therefore. NET. It also knows that SAP HANA has been optimized to meet its needs. This extreme separation of application logic and data storage has been one of the cornerstones of ABAP application development for the past 20 years. thanks to ODBC/JDBC.No Constraints The primary philosophical difference between developing apps in the “old world” and developing apps for SAP HANA is probably the mindshift that is needed to program in a world without constraints. . these platforms often sacrifice capabilities for compatibility. primarily because this was the most effective strategy for SAP to compromise between broad support for many databases and performance of the applications. low-complexity platform to run the entire application? This is the type of philosophical shift required to make the leap from programing in a world of constraints into the new world of SAP HANA. you could collapse all of the other application and presentation layers down into the database to provide a simple. Abstraction In the SAP world (ABAP especially). ” Developers are taught from their very first “hello world” application that they have to achieve a compromise between maximum utility of the application and maximum usage of the base infrastructure supporting the app. The boundaries as to where the database ends and the application server begins are also strongly challenged.” The ABAP engine is the primary location for all application logic and SQL generation. unique tables simultaneously and performs an on-the-fly join would be considered foolish and impossible just a couple of years ago. what if it wasn’t foolish or impossible? What if that algorithm in the app would provide a huge amount of business value to the users? What if there were no “penalties” for writing that algorithm? What if you could get an answer to that calculation in a few milliseconds instead of several hours? What if you had a supercomputer dedicated to calculating that algorithm whenever you needed it? What if. ABAP developers literally have no idea what database their app is going to be run on. In a traditional disk-based architecture. Abstraction is also present in the JDBC interface for Java apps and ODBC for various other development platforms. so they have to assume the “lowest common denominator” and write to NO specific database. in the SAP HANA world. Several of the early developers who worked with SAP HANA referred to this psychological shift as “taking the red pill. Consequently. In the SAP HANA world. But. Unfortunately. it also prevents the developers from utilizing many of the database functions. so the database is used only for data storage. writing a complex algorithm that calls raw data from 200 large (100 million rows). and various other development platforms often utilize very similar abstraction approaches. . However. This “buffer” between the app logic and the data it needs works well to insulate the developers from the database engine. There are numerous books that teach these “best practices” (including quite a few from SAP) to help developers achieve this shaky balance. PHP. the ABAP engine knows EXACTLY which database it is going to interface with. the ABAP engine not only can take advantage of the native speed of memory-toprocessor. JAVA. developers are taught to abstract their applications completely from the database and treat them as a “black box. it can also take advantage of all of the “under-the-hood” capabilities that SAP HANA offers for calculations and business functions. In contrast. the old constraints of database I/O and computational power become largely irrelevant . in addition to performing these operations in the database. transform the data. and calculations are all executed INSIDE the database. that process is flipped upside down. companies that employ SAP HANA have seen their application performances improve by hundreds of thousands of times. In fact. developers would design the application and write the app logic. In SAP HANA. and algorithm/calculations while leaving the database largely untouched. In addition. A function call is inserted to fetch the ANSWER from the database. Figure 2: Paradigm Switch in Programming Models . data transformations. When the app ran. SAP HANA enables developers to get deep inside the data model. algorithm. The app contains only the business logic. many of the performance-related processing tasks are actually carried out deep inside the database (like stored procedures on steroids). Thus. it would fetch whatever data it needed from the database. and only the result is passed up to the application. bring it up to the app. Offloading all of the data-intensive operations to the database and calling those operations as functions from the application makes the entire architecture significantly more elegant and efficient.With SAP HANA. not inside the application as they do in disk-based databases. SAP HANA functions inside the database to program dataintensive operations at the data level. The data transformations. and then run them through the algorithm or calculations to present the results to the user. Figure 1: New Programing Paradigm In the old programming paradigm. Of course. In the next few sections we will look at various architectures where ABAP and SAP HANA work together to create innovative opportunities in the SAP Business Suite. In this section. Your ABAP applications can then be accelerated because they will read data from the SAP HANA copy instead of the local database. non-disruptive applications to accelerate a handful of problematic transactions or reports all the way to running the entire SAP Business Suite natively on SAP HANA as the primary database. you’ll not only simplify the architecture and streamline the application. Consequently. it plays an important role in SAP HANA’s adoption into SAP’s current customer base. If you delegate the data-intensive operations down to SAP HANA.00 and beyond. many people are interested in how they can utilize SAP HANA within the SAP Business Suite and. by connection. This functionality is extended to support SAP HANA for all the NetWeaver release levels from 7. you’ll also see SAP HANA really let loose its horsepower for supercharged performance in the applications. This capability allows ABAP programs to access a database system other than the local database. See Chapter 4 for more details on the SAP Business Suite Powered by SAP HANA. we will discuss several scenarios for leveraging the power of SAP HANA with both new and existing SAP Business Suite applications. even a database from a completely different DBMS vendor. You then use replication to move a copy of the data into the SAP HANA system. Figure 3: SAP HANA as a Secondary Database ABAP Secondary Database Connection ABAP has long possessed the capability to make a secondary database connection. you install SAP HANA as a secondary database instead of as a replacement for your current database. ABAP Programming for SAP HANA Because ABAP is the primary application programming language and application server foundation for the SAP Business Suite.This shift from data manipulation at the application level to data manipulation at the database level is necessary to take advantage of all of the power contained in SAP HANA. SAP HANA as a Secondary Database In this scenario. These scenarios range from very simple. Service Note 1597627 lists the preconditions and technical steps required to . however. how they can use ABAP to access SAP HANA logic and constructs. you can keep your old apps the way they are and obtain slightly faster response times simply because the database sits in memory. You have one central location where you maintain the database connection string. and 7. and password. Kernel 7. That isn’t a huge problem for this Accelerator scenario.11. In this situation we will always have local copies of the tables in the ABAP Data Dictionary. Secondary Database Connection Via Native SQL ABAP also has the ability to utilize Native SQL. that you can’t access SAP HANAspecific artifacts like Analytic Views and Database Procedures. The downside is that the table or view you are accessing must exist in the ABAP Data Dictionary.) SAP HANA DBSL is installed. Below we summarize the current state of SAP HANA Development tools at the time of publication of this book. Next. and perform it against our HANA database: The advantage of this approach is its simplicity. 7. however. however.20. username. In addition.10. You also can’t access any tables that use SAP HANA as their own/primary persistence. (This is the Database-specific library that is part of the ABAP Kernel. 7. and it should always be the master guide for these preconditions.connect to HANA systems. 7.) The SAP HANA DBSL is available only for the ABAP Kernel 7. Preconditions The SAP HANA Client is installed on each ABAP Application Server.20 is already the default kernel for NetWeaver 7. you must configure your ABAP system to connect to this alternative database. The ABAP Application Server Operating System must support the HANA Client. Your ABAP system must be Unicode or Single Code Page 1100 (Latin 1/ISO-8850-1) — See Service note 1700052 for Single Code Page Support instructions. Kernel 7. By making one minor addition to existing SQL Statements.30. and 7.31. thereby making the connection information application independent. because all of the data reside in the local ABAP DBMS and are replicated to SAP HANA.02. For instance. If we take the example from above. Note. Native SQL contains syntax that allows you to call Database Procedures.20 is backward compatible.00.01. If you supply the additional syntax of CONNECTION (dbcon).03. let’s take a simple Select. you can force the Open SQL statement to be performed against the alternative database connection.20 and higher. so it can also be applied to NetWeaver 7. 7. This process allows you to access tables and other artifacts that exist only in the underlying database. you can redirect your operation to SAP HANA. 7. Secondary Database Connection Via Open SQL The easiest solution for performing SQL operations from ABAP to your secondary database connection is to use the Open SQL statements that ABAP developers are already familiar with. (Check the Platform Availability Matrix for supported operating systems. In this situation you write database-specific SQL statements. we can rewrite it using Native SQL: . Your applications then need only to specify the configuration key for the database. The other disadvantage of using Native SQL via EXEC SQL is that there are few. For example. if any. The upside is that it provides access to features you wouldn’t otherwise have. you can insert data into a SAP HANA table and use the SAP HANA database sequence for the number range or for built-in database functions like now(). Secondary Database Connection via Native SQL — ADBC There is a third option that provides the benefits of the Native SQL connection via EXEC SQL but also eliminates some of the limitations.One disadvantage of using Native SQL via EXEC SQL in this example is that the statement contains significantly more code than the Open SQL option. This is the concept of ADBC — ABAP Database Connectivity. For example. This approach is essentially a series of classes (CL_SQL*) that simplify and abstract t he EXEC SQL blocks. we could once again rewrite our SELECT *FROM SFLIGHT example: . which can lead to short dumps if the exceptions aren’t properly handled. syntax checks on the SQL statements you create. This limitation makes testing absolutely essential when you’re using Native SQL. It is also a little less elegant because it utilizes database cursors to bring back an array of data. Errors aren’t caught until runtime. We’ve deliberately used very simplistic SQL statements in these examples so that we could focus on the details of how the technical integration works. However. With the SAP Business Suite powered by SAP HANA offering. SAP HANA as a Primary ABAP Database Of course. We’ve already examined how secondary database connections can be accessed via both Open SQL and Native SQL in ABAP. However. the real power comes when you execute more powerful statements (SELECT SUM … GROUP BY). which makes calling Stored Procedures very similar to calling ABAP Function Modules. The initial package size will return all of the resulting records by default. To address these limitations. Select-Options and Parameters. Developers can utilize Proxy Views to leverage the power and ease of use of ABAP Open SQL against these SAP HANA-specific view types. These features come with ABAP 7. Likewise. A new ABAP syntax (CALL PROCEDURE) was also introduced.40 has introduced a new concept known as Data Dictionary Proxy Views. access SAP HANA-specific artifacts (like OLAP Views upon OLTP tables). ABAP 7. Most importantly for SAP HANA situations. This capability is particularly useful when it is combined with ABAP range types — that is. SAP recommends that you always try to use the ADBC class-based interfaces. This is really just the beginning of what you could accomplish with this secondary database approach to ABAP integration into SAP HANA. ABAP has evolved to provide new tools and techniques that enable developers to directly access certain distinguishing features of SAP HANA. Both Proxy Views and Procedure Proxies make it unnecessary to drop into Native SQL within .40-based systems. Going further. thereby tuning processing for large return result sets. Attribute.In this iteration we remove the step-wise processing of the Database Cursor and instead read an entire package of data back into our internal table all at once. is the fact that ADBC also lets you access non-Data Dictionary artifacts including SAP HANA Stored Procedures. you can specify any package size you wish. We also learned that ABAP Open SQL is limited to objects that exist in the ABAP Data Dictionary. and Calculation views. Procedure Proxies generate both an ABAP interface and parameter data types for a SAP HANA Stored Procedure. SAP HANA can also be used as the primary DBMS under any ABAP-based system. or database procedures. Given the advantages of ADBC over EXEC SQL. however. ABAP-based Suite applications like ERP can be run with SAP HANA as the primary DBMS — no replication or other databases is needed. Proxy Views allow a developer to create an ABAP Data Dictionary entry for SAP HANA-specific view types — Analytic. ABAP 7.40 has introduced a parallel concept for Stored Procedures called Procedure Proxies. ABAP developers have to adopt different design strategies if they wish to take advantage of its full power. Keep in mind that we are comparing developer design patterns here. Therefore. ABAP developers tend to shy away from deeper aspects of SQL in favor of processing the data on the application server in ABAP. This approach has served ABAP developers well for many years. This situation has been exacerbated in recent years because ABAP contains a greater array of tools that will generate the SQL for us. they tend to trust the processing on the application server where they have total control instead of the “black box” of the DBMS.ABAP to leverage database-specific features. For ABAP developers who are reading this. Transition Closer to the Database Regardless of whether you are utilizing SAP HANA as your primary or secondary database connection. They also improve the data transfer efficiency between the ABAP Application Server and SAP HANA. In this case we want to load all of the flight details from SFLIGHT and also load the carrier details from SCARR. They streamline the amount of work the developer must perform to design applications for code push down into SAP HANA. when was the last time you used a sub-query or a join in ABAP? Or even a select sum? ABAP developers have been taught from early on to abstract the database as much as possible. not the actual technical merits of these specific . however. would adopt an alternative approach where they perform the join in memory on the application server via internal tables: Figure 5 — Typical ABAP Coding of Joining at the App Server This approach can be beneficial when it is combined with ABAP table buffering. In ABAP we could write an inner join: Figure 4 — ABAP Open SQL with Inner Join Many ABAP developers. Let’s take the typical situation of loading supporting details from a foreign key table. The database will no longer be a “bit bucket” to be minimized and abstracted. Storing the data columnar reduces that cost when performing operations that scan one or more columns as well as when optimizing compression routines. Ignoring the cost of updates. if we were to buffer both SFLIGHT and SCARR. Rather. ABAP leverages multiple cores/CPUs by running different user sessions in separate work processes. in contrast. developers need to write more SQL and to interact more frequently with the underlying database. Scans of unneeded data in memory aren’t nearly as expensive as performing the same operation on disk (because of the need to wait for platter rotation). The fact that the data are consolidated in memory only further supports this parallelization by making access from multiple CPUs more useful. our ABAP table loop join in the previous example would be pretty fast. we need to keep in mind that SAP HANA is an in-memory database. and development environment within the SAP HANA appliance itself. Before SAP HANA SP5 was introduced. Instead.examples. SAP HANA. it will become another tool in the developer’s toolset to be fully leveraged. The other key points of SAP HANA’s architecture are that in addition to being in-memory. developers (and especially ABAP developers) must re-think their applications designs. Instead. After all. each record in the table has to be processed sequentially. although it still wouldn’t be as fast as SAP HANA. but there is a cost all the same. The current version of ABAP statements. SAP has decided to truly integrate this new application services functionality directly into the deepest parts of the SAP HANA database. If this were the only advantage that SAP HANA offers. The other technical aspect at play here is the columnar architecture of SAP HANA. one record at a time. If we now added SAP HANA to the mixture. Almost any developer can appreciate the advantages of consolidating all of your data in fast memory as opposed to relatively slow disk-based storage. all of the data for a single column are stored together in memory. The core concept of XS Engine is to embed a full-featured application server. To accomplish this task. how would the developer approach change? In HANA the developer should strive to push more of the processing into the database. just isn’t designed for parallel processing. we wouldn’t notice a huge difference compared to processing in ABAP. however. parallization isn’t useful if the CPUs spend most of their cycles waiting for data to process. row storage — as even ABAP internal tables are processed — places data in memory one row at a time. However. this technology isn’t just another piece of software installed on the same hardware as SAP HANA. ABAP has full table buffering. why? To answer this question. the CARRID column in each table can be scanned faster because of the arrangement of data. it is designed for columnar storage and parallel processing. After all. When tabular data are stored in columns. however. SAP has introduced an exciting new capability called SAP HANA Extended Application Services (sometimes referred to unofficially as XS or XS Engine). for the join condition mentioned above. The question might be. For these reasons. In the ABAP table loop. To extract the maximum benefit of SAP HANA. they will also need to push more of the processing from ABAP down into the database. Web server. This architecture will enhance the performance of the app and enable it to access SAP HANA differentiating features that no other application server has. because data can be “fed” to the CPUs that much faster. In contrast. SAP HANA Extended Application Services (XS) With SAP HANA SP5*. can parallelize blocks of data within a single request. Thus. if you wanted to build a lightweight Web page or REST . Service that consumes SAP HANA data or logic, you would need another application server in your system landscape. For example, you might use SAP NetWeaver ABAP or SAP NetWeaver Java to connect to your SAP HANA system via a network connection and use ADBC (ABAP Database Connectivity) or JDBC (Java Database Connectivity) to pass SQL Statements to SAP HANA. Because of SAP HANA’s openness, you might also use Dot Net or any number of other environments or languages that support Open Database Connectivity (ODBC) as well. These scenarios are all still perfectly valid. In particular, when you are extending an existing application with new SAP HANA functionality, these approaches are very appealing because you can integrate this SAP HANA functionality into your current architecture easily and with minimal disruption. When you are building a new SAP HANA-specific application from scratch, however, it makes sense to consider the option of the SAP HANA Extended Application Services. This architecture enables you to build and deploy your application completely self-contained within SAP HANA. This approach can lower your costs of development and ownership while providing performance advantages because the application and control flow logic are located so close to the database. Applications designed specifically to leverage the power of SAP HANA are frequently designed to push as much of the logic down into the database as possible. It makes sense to place all of your data-intensive logic into SQL, SQLScript Procedures, and SAP HANA Views, because these techniques will leverage SAP HANA’s in-memory, columnar table optimizations as well as massively parallel processing (MPP). For the end-user experience, we are increasingly targeting HTML5 and mobile-based applications where the complete UI logic is executed on the client side. Therefore, we need an application server in the middle that is significantly smaller than the traditional application server. This server needs to provide only some basic validation logic and service enablement. The reduced scope of the application server lends further credit to the approach of a lightweight embedded approach like that of the SAP HANA Extended Application Services. Figure 6 — Paradigm Shift in Runtime Layers SAP HANA Studio Becomes a Development Workbench To support developers in creating applications and services directly within SAP HANA Extended Application Services, SAP has enhanced the SAP HANA Studio to include all of the necessary tools. SAP HANA Studio was already based upon Eclipse; therefore, SAP was able to extend the Studio via an Eclipse Team Provider plug-in that sees the SAP HANA Repository as a remote source code repository similar to Git or Perforce. This arrangement empors the SAP HANA Database to manage the entire lifecycle of all of the development resources (everything from SAP HANA Views, SQLScript Procedures, Roles, Server Side Logic, HTML and JavaScript content, etc.). These management capabilities include versioning, language translation export/import, and software delivery/transport. The SAP HANA Studio is extended with a new perspective called SAP HANA Development. As Figure 7 illustrates, this new perspective combines existing tools (e.g., the Navigator view from the Modeler perspective) with standard Eclipse tools (e.g., the Project Explorer) and new tools specifically created for SAP HANA Extended Application Services development (e.g., the Server Side JavaScript editor shown in the figure or the SAP HANA Repository browser). Because SAP HANA Studio is based on Eclipse, SAP can also integrate other Eclipse-based tools into it. For example, the SAP UI Development Toolkit for HTML5 (SAPUI5) is a standard feature in SAP HANA Extended Application Services. SAP HANA 1.0 SP5 comes preloaded with the 1.8 version of the SAPUI5 runtime, and the SAPUI5 development tools are integrated into SAP HANA Studio and managed by the SAP HANA Repository, like all other XS-based artifacts. Figure 7 — SAP HANA Development Perspective These extensions to the SAP HANA Studio include features that enhance developer productivity; for example, project wizards (Figure 8), resource wizards, code completion and syntax highlighting for SAP HANA Extended Application Services server side APIs, integrated debuggers, and so much more. Figure 8 — SAP HANA Specific Project Wizards These features also include team management functionality. All development work is performed based on standard Eclipse projects. The project files are then stored within the SAP HANA Repository along with all the other resources. Team members can utilize the SAP HANA Repository browser view to examine existing projects and import them directly into their local Eclipse workspace. Developers can then work on these projects offline. In addition, multiple developers can work on the same resources at the same time. Upon commit back to the SAP HANA Repository, the tool will detect any conflicts, and developers can access a merge tool to integrate the conflicts back into the Repository. The SAP HANA Repository also supports the concept of active/inactive workspace objects. This feature allows developers to safely commit their work back to the server and store it there without immediately overwriting the current runtime version. The new runtime version isn’t created until the developer chooses to activate the Repository object. SQLScript As we have described, the cornerstone of the architectural optimization for applications designed for SAP HANA is the concept of code push down. Execution of data-intensive logic within the database begins with the usage of standard SQL and views. Developers, however, also need semantics that exceed the capabilities of SQL if they wish to create business logic within the database. To this end, SAP delivers just such an extension to SQL, called SQLScript. SQLScript is the primary language for creating stored procedures and functions in SAP HANA. The extensions that form SQLScript allow the developer to push down more of the data-intensive logic into the database. Typical SQL statements are often well suited to parallel processing because of their declarative nature. The primary weakness of SQL becomes apparent when you need to pass the result set of one SQL operation into the input of a second operation. In this scenario, developers traditionally had only two options: copy the result set to the application server, or write complex, nested SQL statements utilizing sub-queries or multiple join conditions. Procedures can return multiple results. When compared to standard SQL. SQLScript can decompose complex functions into smaller chunks. In addition to all of these benefits.SQLScript solves this problem by providing a feature that describes the data flow from one SQL operation to another. The execution takes place on the R server. open-source R server. reuse. R Stored Procedures serve a second purpose within SAP HANA: They are the mechanism that integrates other programming languages and interfaces directly into the database execution layer. and imperative logic constructs. SQLScript has several advantages. This feature enables developers to continue to write logic as they would with an application server and also to declare and use intermediate result sets and variables. This feature offers developers a syntax that is easier for a person to read and write while still providing a logic flow that is well suited to database execution. It also brings the data-intensive application logic close to the database by combining the existing Declarative logic of SQL with its own built-in functions as well as with orchestration logic such as Data Definition Language (DDL). standard SQL allows only the definition of SQL views. With the R integration into SAP HANA. This capability enables modular programming. Going further. Finally. The best example of this integration of third-party languages is the introduction of R Language within Stored Procedures. Data Manipulation Language (DML). are sent to the remote. Another advantage of SQLScript over SQL is that it supports local variables for intermediate results with implicitly defined types. whereas an SQL query can return only a single result set. For structuring complex queries. Overall. SQLScript provides enhanced control flow capabilities as well as some limited procedural logic constructs. developers can write their R Scripts directly within a stored procedure. With standard SQL. R covers a wide range of topics from Cluster Analysis to Probability Distributions to Graphic Displays to Machine Learning — to name just a few. SAP provides the interfaces in both SAP HANA and the R server to make this integration completely transparent to the application developer. R is an open-source software language and environment for statistical computing and graphics that includes more than 3000 add-on packages. and the results are sent back to SAP HANA. Going further. the R script. These views have neither parameters nor a fixed interface. During execution. and a better understandability by functional abstraction. At the same time. . SQLScript will improve the readability and structure of your data-intensive logic (compared to complex SQL alone) by passing the results of one SQL statement to another and by breaking complex SQL into smaller chunks. These features make it possible to rewrite some of the more complex parts of the application logic and push them down into the database layer as well. [thereby] leveraging sophisticated parallel execution strategies within the database. Yet it SQLScript often can be compiled down to database joins and sub-queries. SQLScript has control logic such as if/else that is not available in the SQL standard. SQLScript can increase overall performance by utilizing parallel processing within most of its executions. globally visible views have to be defined even for intermediate steps. SQLScript avoids [sending] massive data copies to an application server. along with any input data. you’re probably sick of reading. Next Steps By this point. including depreciation. parameter-driven. AFL AFL stands for Application Function Library. basic building block library of calculations delivered at high performance. SAP’s long-term goal is to safely wrap the most useful abilities of L and integrate them into the SQLScript language. with the introduction of SAP HANA 1. In time. BFL is a prebuilt. consuming one of the powerful functions of the Application Function Library is now as easy as working with any other SQLScript procedure. L is a robust. The AFLs are written in C/C++. SAP plans to release additional tools that make the consumption of these AFL-based procedures even easier. SAP also has the language L. Customers and partners should use L only in close cooperation with SAP development resources. It represents multiple function libraries — like Business Function Library (BFL) and Predictive Analytics Library (PAL). high-performance programming language located inside SAP HANA that allows code to be created at runtime. Significantly. However. the direct access that makes L very powerful also makes it rather dangerous. customers and partners can easily access and reuse these libraries because. Luckily for you. Because the AFLs interact so closely with the database kernel. and want to get your hands dirty playing with SAP HANA. . capacity optimization. SAP offers FREE developer instances of SAP HANA as well as all of the development tools you need to experiment with everything discussed in this chapter (and more). low-level. it can be roughly characterized as a safe subset of C/C++ that is enriched by SAP HANA data types and concepts to simplify the manipulation of and interaction with database objects. Therefore. and they become closely linked with the database kernel itself.Figure 9 — R Language Integration L In addition to SQLScript language for the implementation of Stored Procedures. At this point. Therefore. Nevertheless.0 SP5. they operate without a virtual machine abstraction. The L language is based on concepts from the C/C++ world. SAP may even open up development of new AFL functions to select partners. only SAP can write these libraries. SAP can now generate a Stored Procedure interface for them. direct access to L will become unnecessary. L provides direct access to the table and column objects that are utilized in the Calculation Engine. and time-based functions such as year over year (YoY) and delay. L is currently restricted to SAP internal usage. and start writing code. Additional Resources Application development with SAP HANA is such a huge topic that it could fill up several books. It takes about 15 minutes to sign up. provision your instance on the cloud.Simply head over to the SAP HANA One Developer Edition site to get started. you can pop over to the SAP HANA Academy to watch hundreds of tutorials on how to build your first “hello world” application or to do any number of other things with SAP HANA — for free. ODBO and Python DB API. When you download the SAP HANA Client. In this chapter we’ve tried to cover some of the most critical aspects of working with SAP HANA as an application developer. We highly recommend that you continue learning about development topics at the following sites: SAP HANA Developer Center SAP HANA Documentation (help portal) ABAP for SAP HANA SAP HANA Academy (educational videos) The Road to HANA (the ultimate link collection for beginners and experts) Development Resources on SAPHANA. it includes SDKs for JDBC. ODBC. While the Client is downloading.com SAP Business Suite Powered by SAP HANA . Chapter 9 SAP HANA Administration & Operations COMING FALL 2013 . Chapter 10 SAP HANA Hardware Overview SAP HANA is the first SAP solution that has been built to be specifically run as an appliance and optimized for a very specific combination of processor. At a certain point in the mid-2000s. Solaris. building out a robust certification laboratory in its headquarters to constantly test and validate new hardware and software combinations that were being released by its partners for customer use. the small number of combinations that SAP began with had exploded into a truly dizzying collection. This approach represents a departure from SAP’s long history of broad platform support. In addition. memory. This made sense because many companies were employing existing landscapes from a preferred hardware vendor and had developed expertise in certain versions of operating system and database that they wanted to leverage for their SAP environment. the UNIX platform began to splinter into multiple dialects. This “technology-neutral” strategy worked very well for SAP for more than 30 years. SAP believed that providing customers with such a broad choice would help them achieve lower TCO of their SAP solutions by reusing technology and resources that were already in place. with each hardware vendor putting its efforts behind its preferred variant (HPUX. SAP happily obliged. and the costs for SAP and its customers of this broad coverage were becoming unsustainable. x86 platforms from Intel and AMD began to displace the RISC-based platforms of the early . we need to look back historically at some of the hardware platform changes that led SAP to adopt this policy this strategy and explore why this path offers SAP customers the best balance of broad hardware partner options and focused innovation around a stable set of key components. When the mass-adoption of SAP R/3 took off. two of the critical benefits were the lower costs and the more standardized options associated with the UNIX-based servers that had just become available. and operating system. AIX. SAP implemented this new policy to still provide customers with multiple choices in hardware platforms while avoiding the TCO implications of multiple OS and processor support combinations. etc). SAP also felt that being hardware and OS/DB “agnostic” would be the best strategy to set itself apart from the other enterprise app vendors. In order to understand why. After SAP R/3 was released. When SAP shifted from mainframe to client-server architecture with SAP R/3. Customers no longer benefited significantly from such a broad list of hardware and technology choices. however. customers began asking SAP to certify more and more new combinations of operating system and database on various hardware platforms. At the time. Some of the most visible: . Because Linux is so technically similar to UNIX. SAP laid out its strategy for the shift to in-memory computing to Intel’s executives. SAP could invest all its development and testing resources into a single platform while still allowing customers to choose which hardware vendor would deliver and support the appliance. SAP decided to bet on open-source and industry standards as the core platform for SAP HANA. the company made a strategic decision to avoid all of the costs and complexity of supporting so many variations of hardware and technology platforms. almost any UNIX engineer could transition his or her skills easily. SAP had been working with Novell/SUSE for many years to support Novell SLES Linux as a certified operating system for SAP applications. Later. RAM. Soon. Although there were many chips on the market that could handle SAP’s traditional application-processing requirements. growing to include a broad set of collaborations and initiatives. The latest success from that tradition of co-innovation is available to customers of all sizes in SAP HANA. Intel sent a team of their best software and chip engineers to SAP HQ to begin the work of jointly optimizing each successive version of the industry-standard Intel Xeon chips for the needs of SAP’s evolving in-memory database. So. SAP had to settle on a single processor family for the new solution. At a certain point. choice became a liability for SAP and its customers rather than the benefit that it was originally intended to be. In addition to selecting a single OS. which is delivered on the Intel® Xeon ® processor. with a vast number of hardware platforms for those combinations. and the two parties discussed the level of co-innovation that would be needed to jointly engineer both an inmemory database and optimized processors that could handle the unique needs of this new architecture. Intel and SAP have worked together to deliver industry-leading performance of SAP solutions on Intel® architecture. the Product Availability Matrix (PAM) for SAP ERP exceeded 200 combinations of OS and database. and a large proportion of new SAP implementations are now deployed on Intel ® platforms. Since that time. The top executives from each company agreed that the they would have to establish a new level of co-innovation partnership and starting in 2005. and processors. because Linux was open-source and easily supported by third parties. Moreover. The relationship between Intel and SAP has become even stronger over the years. there weren’t any processors that had been designed to handle in-memory processing tasks (because enterprise-scale in-memory computing didn’t exist yet).UNIX hardware vendors due to their lower costs and their support for industry standards. it was clearly the lowest TCO option for running an SAP system. and Intel has a long history of innovating for the future needs of the enterprise. and Intel has incorporated SAP’s unique in-memory processing requirements into its chip capabilities. Linux began to displace the original UNIX operating systems due to its lower costs and the advantages of open-source code. SAP has benefitted from early access to each new generation of Xeon processor from Intel. SAP was primarily concerned with the three pieces of technology that had the greatest impact on performance and would be the largest drivers of TCO reduction: operating system (OS). By supporting only ONE combination of OS and processors. Intel and SAP: A History of Co-Innovation For more than 10 years. The initial SAP HANA conversations that SAP’s executives held with anyone outside the company were with Intel because SAP realized that shifting to in-memory computing would require a new breed of processors that were optimized for the new architecture. when SAP began development on the precursors of SAP HANA. and continuous early access to nextgeneration technologies from all of its partners. researchers from Intel and SAP continually explore and drive the future of business computing As a result of these efforts. RAM. customer solutions achieve performance. SAP realized that even though the core components of the SAP HANA servers would be nearly identical (OS. This broad support from industry-leading hardware vendors provides customers with a choice of seven hardware partners to deploy their SAP HANA solution. In early 2011. lowering TCO). IBM. and processors) for SAP HANA. SAP needed to reach out to the server manufacturers to package the software and hardware into industry-standard appliances in a way that would remove as much configuration and integration work from the customers as possible (again. Plus. and performance of the certified systems through a rigorous process of end-to-end quality testing. Dell. for increased business value. So. Cisco. Hitachi joined the list later that year. reliability. management and operations of the hardware. Together. and NEC was certified in early 2012. SUSE Linux SLES 11 is the only supported operating system. scalability.” multivendor hardware support for SAP HANA has been received extremely well by customers because it eliminates the confusing number of hardware combinations and focuses on the value-added solutions that each vendor can offer on top of the “solid core. Combined research efforts.Joint roadmap enablement. availability. they engaged seven of their primary hardware vendors (see the next paragraph) to build certified SAP HANA appliances and create packaged services to implement SAP HANA quickly and easily at customer sites. and those insights help to direct the development cycle for maximum value. each with unique service and support offerings to fit their customers’ needs. Intel engineers located on-site at SAP work with their SAP counterparts to provide tuning expertise that enables SAP HANA and other software solutions to take advantage of the latest hardware features. pre-installed appliance that is delivered directly from the hardware partner. Early in the design process. Here is the August 2012 SAP HANA PAM. RAM. SAP’s strategy of “solid core. the hardware vendors provide a great deal of additional value in the implementation. and processors). Most partner systems use on-board 15k RPM hard disks (4x ratio for main memory) for datavolume backup and Fusion I/O SSD cards (1:1 ratio for main memory) for log-volume backup. Fujitsu. Collaborative product optimization. and HP all jumped on the SAP HANA bandwagon and had their flagship Intel-based servers certified and in production. Having created an optimized “core” (operating system. Samsung RAM is currently the primary memory used by all of the hardware partners. and Intel E7 processors are the only supported chips. Single-Node Configuration . performance testing. SAP HANA Product Availability Matrix (PAM) The latest and most accurate PAM can always be downloaded from the SAP Service Marketplace.” General SAP HANA Hardware Specifications SAP HANA is sold as a pre-configured. and energy efficiency that translate into favorable ROI and TCO. Intel and SAP decision makers identify complementary features and capabilities in their upcoming products. SAP ensures the quality. customers typically have a preferred hardware vendor for their enterprise landscapes. This is really where SAP felt that customer choice would have the most value. . rather. Multi-Node and Scale-Out Options . it is determined by the server vendor. SAP has no preference on external storage/SAN.Multi-Node Scale Out Configuration Additional Infrastructure SAP recommends that customers deploy 10 gb network data connections. Currently. going from 100TB on disk to 3. the closest competitive database is roughly 1000x slower in the same benchmark and several times more expensive. meaning. A standby host is not used for database processing. Alternatively. All of the database processes run on the standby host. meaning a standby host is kept ready in the event that a failover situation occurs during production operation. In a distributed system. you can string together multiple physical servers into a single logical database instance and achieve linear performance results for every additional server added to the landscape. Literally. To put that in context. SAP HANA’s compression algorithms were able to achieve 20x compression on the raw data when loading into memory. you can group together multiple servers to create a dedicated standby host for each group. Refer to the SAP HANA hardware partner section of this chapter for more information on the various scale-out offerings from the individual partners.40 GHz. indexing or caching were needed to achieve these results. running at 2. Significantly. and you immediately enjoy an exponential increase in performance. and others as standby hosts. The total cost of the 16 node system was roughly USD$640K. but they are idle and do not enable SQL connections. you just add another node/server to the landscape. The data set consisted of five years of Sales and Distribution Records (100 Billion records) and was run on a single logical server consisting of 16 nodes. . SAP HANA was able to scan 100 Billion rows/Sec on the 100 TB dataset and was able to load 16 million records/min. Each node was a certified IBM X5 machine with eight Intel E7-8870 processors with 10 cores. High Availability SAP HANA supports cold standby hosts. in addition to the additional memory. In 2012. some of the servers are designated as worker hosts. SAP recently completed the first 100TB benchmark for the 16 node scale out solution. SAP HANA has certified several vendors for multi-node scale out.SAP HANA is a linearly scalable database.8TB in memory. you can assign multiple standby hosts to each group. Typical query results were: BW Workload: 300ms — 500ms Ad-Hoc Analytics: 800ms — 2s No database tuning. The impact of the backups on system performance is negligible. After a power failure. Protecting against data loss due to disk failures requires backups. Additionally.Disaster Recovery The SAP HANA database holds the bulk of its data in memory to ensure optimal performance. Although save-points and log writing protect your data against power failures. the database can be restarted in the same way as a disk-based database. they do not help if the persistent storage itself is damaged. The log is saved from memory to SSD after each committed database transaction. If the SAP HANA system detects a failover situation. but it still uses persistent storage to provide a fallback in case of failure. The failed volume and all the included tables are reassigned and loaded into memory in accordance with the failover strategy defined for the . These backups are performed while the database is running. data are automatically saved from memory to disk at regular save-points. the work of the services on the failed server is reassigned to the services running on the standby host. During normal database operations. Backups save the contents of the data and log areas to different locations. and it returns to its last consistent state by replaying the log since the last save-point. so users can continue to work normally. all data changes are recorded in the log. We encourage you to speak directly to the hardware partners for more details about their products and services for SAP HANA. support. Before a failover is performed. each Certified SAP HANA hardware partner was given the opportunity to briefly describe their SAP HANA offering and discuss their value-added services for SAP HANA implementation. For more information on HA and DR with SAP HANA.” This procedure can take up to a minute. the system waits for a few seconds to determine whether the service can be restarted. This reassignment can be performed without moving any data. because all the persistency of the servers is stored on a shared disk. Links: Intel Cisco Dell Fujitsu Hitachi HP Huawei IBM NEC . Data and logs are stored on shared storage. refer to this note. and operations. where every server has access to the same disks. The entire process of failover detection and loading may take several minutes to complete. SAP Hardware Partner Details In the remaining section of this chapter. the status is displayed as ”Waiting. During this time.system. Those features eliminate many I/O bottlenecks. and a large proportion of new SAP implementations are now deployed on Intel platforms. Features of the Intel Xeon processor E7 family such as 30MB of L3 cache.Intel & SAP: Co-innovation for Real-Time Computing For more than 10 years. growing to include a broad set of collaborations and initiatives. Intel and SAP decision-makers identify complementary features and capabilities in their upcoming products. Together. SAP HANA is also engineered to take particular advantage of RAS (reliability. The relationship between Intel and SAP has become even stronger over the years. availability. the value of which depends on the ability to distill it into actionable intelligence. Early in the design process. The latest success from that tradition of co-innovation is available to customers of all sizes in the SAP HANA. so processor headroom is available to generate excellent throughput and responsiveness. for increased business value. As a result of these efforts. and quad-channel integrated memory controllers deliver extraordinary capabilities for businesses of all sizes that implement SAP HANA for functionality such as business intelligence and data analytics. and energy efficiency that translate into favorable ROI and TCO. customer solutions achieve performance. and those insights help to direct the development cycle for maximum value. which is fully supported only on the Intel Xeon® processor E7 family. Intel and SAP have worked together to deliver industry-leading performance of SAP solutions on Intel architecture. researchers from Intel and SAP continually explore and drive the future of business computing. You can also model “what if” scenarios to structure sales and promotions for optimal outcomes based on the latest sales and pipeline information. Streaming SIMD Extensions. scalability. and serviceability) features of the Intel Xeon processor E7family. Intel engineers located on-site at SAP work with their SAP counterparts to provide tuning expertise that enables SAP HANA and other software solutions to take advantage of the latest hardware features. Scenarios such as monitoring customer and supplier activity can generate petabytes of data. especially error . Operational Success and Management of Real-Time Events In-memory computing based on SAP solutions on the Intel Xeon® processor E7 family enables greater business agility and innovative usage models that let companies respond to changing conditions in real time. reliability. Intel® QuickPath Interconnects. Combined research efforts. Performance Optimizations of SAP HANA with the Intel Xeon® Processor E7 Family SAP HANA benefits dramatically from high-speed Intel ® QuickPath processor-to-memory interconnects and the latest processor instructions. SAP HANA and the Intel Xeon® processor E7 family deliver rapid data analysis that discerns patterns and trends so you can adjust your just-in-time supply chain rapidly. Collaborative product optimization. Some of the most visible include the following: Joint roadmap enablement. Assured Performance with Mission-Critical Advanced Reliability of the Intel Xeon Processor E7 Family Machine Check Architecture Recovery. SAP HANA can provide businesses of all sizes superior results for data warehousing implementations such as business intelligence and data analytics. enables the hardware platform to generate Machine Check Exceptions. As a result of the high level of performance optimization for servers based on the Intel Xeon processor E7 family. availability. Copyright© 2012 Intel Corporation. .correction through Machine Check Architecture Recovery. these notifications enable the system to take corrective action that allows SAP HANA to keep running where an outage would otherwise occur. a reliability. for mission-critical implementations. All rights reserved. Hardware based on the Intel Xeon® processor E7 family enables SAP HANA to fail over from one processor socket to another in the event of a processor failure and to handle memory errors with as little impact to workloads as possible. In many cases. and serviceability (RAS) feature built into the Intel Xeon® processor E7 family. The model-based management applies personality and configures server. single management plane across multiple Cisco UCS rack and blade servers (Figure 1). Depending on the compression factors. manage. which corresponds to uncompressed databases up to 100 TB or more. self-integrating information technology that reduces staff costs and increases uptime through automation. Cisco UCS helps organizations go beyond efficiency: it helps them become more effective through technologies that breed simplicity rather than complexity. supporting as low as 64 GB memory. network. and storage connectivity resources. The configuration is applied quickly. providing a more rapid return on investment. Using Cisco service profiles. Cisco has developed a full portfolio of SAP HANA appliances based on Cisco Unified Computing System™ (Cisco UCS™) spanning from the smallest Tshirt sizing. but with massive scalability. and automatically. and eliminating a major source of errors that can cause downtime. reducing capital and operating costs while increasing business agility. accurately. This represents a radical simplification over traditional systems. The result is flexible.Cisco Systems SAP HANA Solutions As part of the “Unified Appliance Environment”. and improving performance. simplifying and speeding deployment. The Cisco Fabric Extender Architecture reduces the number of system components to purchase. This radically simplifies operations and lowers costs. configure. highperformance. All Cisco UCS SAP HANA appliances are intelligent infrastructure that can be managed through the embedded. . and maintain by condensing three network layers into one. The excellent performance combined with the broad range of usable memory make the Cisco UCS SAP Appliances an excellent. agile. it is simple to provision servers by applying a desired configuration to physical infrastructure. which define the model. improving business agility. However the Cisco technology can support up to 20 TB of usable memory. Cisco UCS: A Unique SAP HANA Solution Cisco UCS is a single unified system entirely programmable through unified. It eliminates both blade server and hypervisor-based switches by connecting fabric interconnect ports directly to individual blade servers and virtual machines. the largest currently supported by SAP. the Cisco appliances can support databases up to 56 TB. up to large scale-out solutions which can support up to 8 TB of usable memory. staff productivity. Virtual networks are now managed exactly as physical networks are. easy-to-manage choice for analyzing massive amounts of business data. model-based management to simplify and speed deployment of enterprise-class applications and services. The persistency layer is provided by two Fusion IO cards to avoid possible bottlenecks in duo card configurations sharing the same PCI slot. depending on customer preference. as needed. and one enclosure with support for up to 4 Cisco B440 blades. However. and small production SAP HANA systems with uncompressed datasets up to 1. SAP HANA Scale-out offering The Cisco UCS solution that has been certified for large SAP HANA implementations is a uniquely scalable appliance. any spare Cisco UCS server .4 GHz) and up to 256 GB of usable memory.75 TB. It allows customers to easily adapt to the growing demands of their individual environment by incrementally adding Cisco B440 M2 blade servers with 4 Intel® Xeon® Processors E7-4870 (2. This configuration is ideal for use in mid-sized and larger production environments such as the one used by Medtronic. the persistency layer is provided by an EMC VNX 5300 or a NetApp FAS 3240. High Availability SAP HANA Solution Cisco UCS SAP HANA appliances have redundancy designed-in providing no single point of failure. The basic configuration can easily scale by adding up to 3 extension bundles each providing an additional blade enclosure for up to 4 more Cisco B440 M2 blade servers each and the correspondent storage from EMC or NetApp. The Medium (M)-size appliance is based on the Cisco C460 M2 rack mount server with 4 Intel® Xeon® Processor E7-4870 (2. based on internal SSD drives that require no additional drivers tainting the Linux kernel. a Cisco 2911 for secure remote management. The “basic configuration” of the Cisco scale-out offering is made up of redundant fabric interconnects with embedded infrastructure management. a large. The Cisco UCS appliance incorporates a persistency layer. a Cisco UCS C200 server for SAP HANA studio. For every four Cisco UCS blade servers. This configuration is primarily used for development. worldwide manufacturer of medical devices (see customer example).4 GHz) and up to 512 GB of usable memory.4 GHz) and up to 512 GB usable memory each.Cisco UCS SAP HANA Architecture SAP HANA T-Shirt Sizes Offered The Extra Small (XS) and Small (S)-size appliances are based on the Cisco C260 M2 rack mount server with 2 Intel® Xeon® Processor E7-4870 (2. test. in the event of a hardware failure on a blade or rack server. This reduces energy consumption and operational costs resulting in much lower total cost of ownership. Cisco UCS drivers. and the average index read time at blade level Automating quarterly maintenance. Customer Success Story . instead of days SAP HANA Installation and Support Services Cisco SAP HANA installation services includes the assembly of all necessary hardware and software required for a SAP HANA appliance. Cisco’s SAP HANA engineers will install the appliance into the customer’s network and connect it to source system(s). The Cisco Fabric Interconnect. with embedded management. and network adapters required by legacy platforms. replication. Also included are the necessary SuSe Linux Licenses. is the core of the Cisco UCS and reduces both the number of network “hops” and network latency. However Cisco Intelligent Automation for SAP HANA is highly recommended. data load. Additional software The operating system. high performance. Implementation of solutions based on Cisco SAP HANA appliances are provided through Cisco Advanced Services and Cisco’s ecosystem of systems integrators and partners.can take over the role of the failed server in minutes by simply applying the service profile to the spare server. high-bandwidth 10-Gbps unified Ethernet fabric. as well as licenses. The unified fabric radically reduces the number of cables. memory. The Cisco Intelligent Automation software solution supports the daily operation of a SAP HANA appliance by: Monitoring the CPU and memory workload. therefore no additional software is necessary to manage the entire system. These solutions include data modeling. including firmware updates and file system validation Ensuring configuration management assurance for all appliance components Monitoring data services availability Proactively monitoring SAP HANA subsystem components status Monitoring query execution response times using the SAP HANA index for the query execution SAP HANA Query Response Time Executing sample queries and recording total execution time and query component performance breakdown Proactively monitoring the SAP TREX services statistics based on thresholds Alerting CPU. and SAP HANA application configuration. low-latency Cisco Fabric Interconnects. and first-year maintenance for EMC or NetApp storage as required. inter-chassis switches. or throughput thresholds for SAP TREX services Automating Cisco UCS blade and rack server provisioning for use in the appliance in minutes. Smartnet 24x7x4 day 2 support for the Cisco hardware. and Cisco UCS management software are all part of the appliance. SAP HANA Support infrastructure All Cisco UCS servers are interconnected with a low-latency. critical to SAP HANA performance. Disaster recovery (DR) scenarios can be easily implemented by using service profiles to quickly provision servers at the DR site in conjunction with the “classical” replication technologies of EMC and NetApp. The unified fabric supports both IP and Fibre Channel over Ethernet (FCoE) connections through redundant. Medtronic dramatically improved reporting performance. increasing the value of its customer information. increasing employee efficiency and enabling smarter decision making. users of an “un-tuned” system observed query times just one-third as long as those with existing production systems.cisco. Solution: The company deployed the SAP HANA platform on the Cisco UCS server platform based on the Intel® Xeon® processor E7 family.cisco.com/go/sap To learn more about Cisco Solutions.com . please visit http://www.com/go/ucs For more information on Cisco UCS SAP HANA Appliances.html To contact Cisco for addition information on SAP on Cisco UCS please email saponcisco@cisco. Because employees couldn’t generate some types of reports (particularly using unstructured data). whether on SAP or non-SAP systems. With the fully scaled and optimized implementation now in place. For More Information For more information on Cisco UCS. such as customer feedback. scalability.cisco.com/en/US/netsol/ns340/ns394/ns224/solutions. BI reporting on its fast-growing data warehouse was straining the capabilities of the company’s computer infrastructure. please visit http://www. wherever it resides. Medtronic hopes to cut response times even further. Customer Benefit: BI operations at Medtronic will use the SAP HANA platform to report on structured and unstructured data. with the SAP HANA™ platform and Cisco Unified Computing System™ (Cisco UCS™) server platform. their ability to draw conclusions from existing data was limited. Challenge: Medtronic needed to increase its ability to analyze large amounts of data. please visit http://www. and flexibility of this new architecture will increase the value of company data as it continues to proliferate. The added performance. In preliminary testing. Dell’s innovative platforms can dramatically increase the availability and speed of business to insightful decision making using SAP HANA. Dell’s Center of Excellence (CoE) is wellestablished for SAP HANA. and high availability features that simplify backups. Dell has collaborated with SAP to deliver hundreds of solutions to customers across many industries. Dell offers customers a portfolio of end-to-end solutions and services in support of SAP HANA applications. implementation. expansion. hosting. management. This solution is both reliable and scalable. SAP Business Warehouse Accelerator (BWA). and data migration provide tangible enhancements to the SAP HANA analytics engine infrastructure. Dell’s end-to-end solutions give your organization full access to the power of SAP HANA. and includes everything needed to support your SAP HANA solution. and mobile solution complements. consulting. Our complement of assessment. and application management services designed to enhance value for customer investments in SAP solutions. . and a full range of services. data modeling. Dell helps organizations achieve rapid and sustainable business results with standards-based solutions that are high-performing and end-to-end. World-class support — Dell’s ProSupport™ and Mission Critical Services help keep your SAP HANA solution running smoothly. Dell’s SAP HANA appliance solution includes: Powerful technology — Dell’s PowerEdge R910 incorporates Intel E7 technology. leading-edge hardware platforms. Automated data tiering manages persistent storage to provide the quickest access to the data sets most needed for analysis. This allin-one solution includes powerful system-management features that provide for seamless implementation and management. Our knowledge experts incorporate their vast experience and the knowledge they have acquired over the course of many years into an enterprise solution delivery model that spans hardware. Dell offers access to thousands of enterprise computing solutions consultants. and solutions. is certified for SAP HANA. and use case assistance services helps to reduce IT costs while helping organizations transform their business. strategies. implementation. Comprehensive services — Dell’s portfolio of SAP full lifecycle services leverage industry best practices to provide better business outcomes for SAP clients. Dell’s Unique SAP HANA Value Proposition Dell and SAP have teamed up to offer an optimally configured SAP HANA solution that includes a hardware appliance. a virtualized environment that provides tremendous flexibility in storage management. and it is offered in multiple configurations to address your specific business needs. Established methodology — Dell’s In-Memory Computing and Analytic Methodology (DIMCAM) incorporates best practices and guides customers through a streamlined and successful implementation process. Large-scale enterprise-consulting expertise — Dell leverages its experience in delivering enterprise IT and solving “big data” issues for global companies to provide actionable and realworld technology. In addition to innovative.Dell SAP HANA Solutions For more than a decade. Enterprise class SAN storage — Dell Compellent SAN Storage offers the Fluid Data storage system. preloaded software. While solid state drives are used to maintain the system’s logs. The logical component layout of the internal components aids with airflow direction. Enterprise customers taking advantage of Dell’s SAP HANA platform get a cost-effective. up to 512GB of DDR3 memory. these solutions enable a business to respond more rapidly to events that are impacting their operations. helping to keep the server cooler. optimized in-memory computing solution that can increase availability and reduce risk. four-socket server allowing large workload consolidation and scale for the SAP HANA in-memory database. By implementing Dell’s SAP HANA solution. Processing power using high-performing Intel E7 Series processors. an organization can position itself to identify and analyze trends and patterns in order to improve planning.The combination of Dell’s PowerEdge R910 platform and SAP HANA software enables users to conduct analytics. Energy-efficient system design built with Energy Smart technologies that enable power capping. thus offering customers a powerful and flexible way to query and analyze large volumes of data with great speed. Solid state technology from Dell offers high IOPs and low latency performance for the in-memory SAP HANA database. performance management. Dell’s SAP HANA appliance provides: Performance and reliability in a scalable 4U. enabling them to best address rapidly evolving market environments. Dell’s SAP HANA Product The Dell PowerEdge Server R910 platform has been certified by SAP to run SAP HANA software. making use of fast internal disks for storage and solid state cards. power efficiency. and operations in a single system. all of which are based on the Dell PowerEdge R910 server platform. . serviceability) Technology. and memory scalability. including performance resources. Together. power inventory. and 2 x 10Gb Optional LOM with 10 PCIe slots. a RAID group made up of internally held 15K RPM disks is used to maintain a copy of the data image. Robust infrastructure. Dell customers running SAP HANA on PowerEdge R910 servers can gain real-time access to information and analytics. forecasting and price optimization. The SAP HANA appliance from Dell is fully contained in the PowerEdge R910 server. Integrated diagnostics with Intel® Advanced RAS (reliability. This solution unites business analytics and transactions on a single in-memory platform. availability. Dell has also been certified by SAP to deliver the SAP Business Suite for HANA. T-Shirt sizes offered Dell offers several different sizes of HANA appliances to meet your needs. and power budgeting within your environment. I/O. Automated tiering of data — standard with Dell Compellent storage software — manages persistent storage to provide the quickest access to the data sets that are most necessary for analysis. In Jan-uary 2013. it offers highavailability features that simplify backups. Using the same PowerEdge R910 servers.5TB. utilizing 10GbE networking. and in May 2013. 2 and 4 terabyte scaleout configurations. and data migration provide tangible enhancements to the SAP HANA analytics engine infrastructure. with growth increments as small as . Dell announced 1. performance. and sharing data across Dell Compel-lent SAN Storage. This flexible scalability gives customers the ability buy exactly what they need today with the confi-dence that their infrastructure can keep pace as their needs increase. Dell further enhanced its SAP HANA appliance plat-form to support incremental. High Availability The Dell™ PowerEdge™ R910 is a high-performance 4-socket 4U rack server designed for reliability and scalability for mission-critical applications. Dell engineers its components to provide a completely integrated and fully supported ecosystem for high-performance data analytics. Dell combines the superior scalability and RAS features of this platform into a multi-node configura-tion. As always. expansion. non-disruptive growth from 1 to 8 terabytes. To supplement the power. and manageability of the Dell PowerEdge servers. Dell Compellent SAN Storage offers the additional benefit of the Fluid Data storage system. a virtualized environment that provides tremendous flexibility in storage management. Its high-availability features include: . In addition.Larger Scale-Out Configurations The linear scalability of the SAP HANA software platform makes scaling to meet larger workload demands a very straightforward process. Dell’s ProSupport Mission Critical services are designed to accelerate rapid resolution of your technical problems by ensuring that parts and/or technicians will arrive promptly and by providing access to Dell’s Critical Situation Process. and hypervisor levels Intel advanced reliability. Lifecycle Controller. SAP HANA Virtualized Dell’s platform allows customers to run their development and test envi-ronments in virtualized instances of SAP HANA. Key support features: Onsite Response — 4 hour onsite service with 6-hour hardware repair available 24x7. hardware. Disaster recovery is supported through SAP HANA’s Synchronous Replication functionality and provides remote disaster re-covery capability for any size SAP HANA system.1 virtualization environment. and networking capabilities. and serviceability (RAS) capabilities Redundant power supplies Remote iDRAC6 connectivity Integrated systems management. Virtualization lowers development infrastructure total cost of ownership and simplifies deployment for projects and testing.Built-in reliability features at the CPU. escalation management. Dell’s SAP HANA appliance comes with 3 years of Dell’s award-winning ProSupport Mission Critical services and a 3-year extended hardware warranty. Synchronous Replica-tion fully mirrors the operations of the SAP HANA system to another platform in a remote location.000 technicians supporting more than 100 countries in 55 languages. Customers receive 24x7x365 phone support. Support infrastructure Dell’s SAP HANA appliance is designed to be an all-inclusive solution that comes as a preintegrated unit with all of the necessary hardware. Dell has a strong systems management and support practice as well as an in-depth understanding of SAP hardware and software solutions. Dell’s SAP HANA solution leverages SAP HANA System Replication to deliver high availability SAP HANA implementations within a data center and disaster recovery for SAP HANA systems be-tween data centers. customers can deploy multiple virtual machines on a single server SAP HANA platform. Additional software needed Dell’s SAP HANA appliance is an end-to-end and all-in-one solution that comes pre-loaded with all of the software and management tools necessary. including holidays. availability. This ensures the customer’s SAP HANA operations provide not only business continuity but also the capacity to withstand a potentially crippling data center disaster. and collaborative support leveraging Dell’s global ProSupport infrastructure of more than 30. Support Services Dell is an expert in SAP HANA system support. memory. storage. Using the VMware vSphere 5. and embedded diagnostics to help maximize uptime Internal Dual SD Module providing hypervisor redundancy Dell’s focus on reliability starts with product design and ends only when it has delivered a solution that meets strict testing and quality con-trol standards. . I.B. which enables businesses to analyze SAP data faster and in real time. data center credibility.B). and mobile applications. SAP HANA Proof of Concept — Using the Dell DIMCAM methodology and IMPROVE jump start process.B clients can now analyze critical data in seconds. real-time analytics.I. G.I.B installed an SAP HANA appliance based on Dell ™ PowerEdge™ servers. based in Siegen.B customers want faster access to supply chain data to help them increase efficiency and make better decisions. Germany. Customer success stories Gesellschaft für Information und Bildung (G.I. Optional SAP HANA services Dell offers optional SAP HANA services to assist with your implementation.B meet its business needs G. is an expert in SAP software.B drives SAP HANA success globally with customer support Dell’s technical expertise ensures that work stays on schedule .I. G. The benefits the new system provided to G. Emergency dispatch — Onsite service technicians are dispatched in parallel with phone-based troubleshooting when you declare a Severity Level 1 incident. which improves supply chain management.CritSit Procedures — Severity Level 1 issues will be reviewed by Dell and may be nominated for CritSit incident coverage through Dell Global Command Centers. The company builds add-ons for SAP environments. it turned to its long-standing IT partner: Dell.I. as was previously the case Business ensures SAP HANA demonstration is ready for key event Flexible support helps G. Together with Dell. SAP HANA Executive Workshop — This workshop helps you develop the Use Case and Business justification for a SAP HANA solution. expert resource teams are mobilized to get you back up and running as quickly as possible. So. it assists organizations in determining whether SAP HANA is a fit for their situation. Analytics Factory — Dell offers global business intelligence consulting and support.I. They specifically needed to meet a very tight deadline to develop a SAP HANA platform for their new Dispo-Cockpit application for an upcoming customer demonstration event. G. include: G.I.B Dispo-Cockpit solution. In addition. To achieve these objectives.B welcomed the development of SAP® HANA™.I. and they collaborated with Dell ProSupport™ to help the project stay on schedule. and an accredited SAP HANA appliance. SAP Modernization Services — Dell has developed a portfolio of Modernization Services for SAP applications that features cloud computing. and not minutes. During a CritSit incident. Implementation — SAP HANA Implementation workshops facilitate the planning and creation of the Business Justification for the rest of the deployment. robust support and consulting services. customers can quickly appreciate the value that SAP HANA can bring to the decision-making process. and is experiencing growing success with its G. The company was looking for a partner with significant SAP expertise. 000 tons of paper each year. G. Not only was the level of expertise impressive. everyone collaborated well to make the project a success.B Koehler Paper Group is a manufacturing company based in Germany. — Karl Schindler. . “Our Dispo-Cockpit solution running on a Dell SAP HANA appliance offers customers even more value.” — Nikolaj Schmitz. but on a personal level. including: New system cuts data loading times from five minutes to five seconds Firm reduces cost of business warehouse by one-third Ease of use simplifies reporting process Efficient reporting helps employees make smarter decisions faster Strong partnership provides expert consultancy I was very pleased with the technical know-how of the Dell and SAP teams. Dell’s SAP HANA solution delivered many benefits to Koehler Paper Group. It employs around 1.I. Germany Contact information for inquiries Dell offers customers a complete portfolio of end-to-end solutions in support of SAP HANA applications that reduce IT costs while helping organizations transform their business.I. Head of IT. G. Contact your Dell Sales or Services Account Executive to learn more. The company worked with Dell and SAP to introduce a new database solution based on SAP HANA and Dell PowerEdge servers in three days. Koehler wanted to replace its conventional database environment with a more efficient infrastructure. highlighting the close relationship we have with our technology partners. The response of customers has been positive and we are looking for pilot customers to jointly install the solution. Koehler Paper Group.800 staff and reports an annual turnover of more than €700 million. Koehler Paper Group sells 500.As a result of its collaboration with Dell.B successfully completed its demonstration environment to show customers how much faster its Dispo-Cockpit software operates with SAN HANA. Dell supported us well. IT Manager. World leaders in specialist paper manufacturing. and migration. This outstanding engagement and excellence in driving in-memory technology has been recognized by the bestowing of several prestigious awards. The Fujitsu Power Appliance for SAP HANA is designed as an optimal foundation for the SAP HANA database. and availability Rapid time to value and a quick return on investment thanks to a unique high-quality preinstallation and staging process Dedicated services that go far beyond traditional infrastructure services and that support decision making. for example.Fujitsu SAP HANA Solutions The global partnership between Fujitsu and SAP has functioned as an innovation engine for customers for decades. which represent a unique combination of Japanese-style innovation and German quality standards. It comprises both single-node and multi-node configurations that are suitable for all existing usage scenarios. and the entire set of accelerator options. including SAP HANA. financing. All Fujitsu infrastructure solutions for SAP HANA are based on industry-standard PRIMERGY servers. Business Suite on HANA. The features of our broad approach to support SAP’s in-memory technology are: A smart HANA infrastructure architecture for highest flexibility. and innovative. Solid reliability and excellent price performance contribute to the very favorable lifecycle costs. Fujitsu Compact Appliance for SAP HANA (designed for SAP Business One in combination with SAP HANA or SAP Business All-in-One with SAP HANA) Fujitsu’s portfolio for SAP Business One or SAP Business All-in-One in combination with SAP HANA is the product of the company’s experience as the exclusive SAP infrastructure partner in the . scalability. Fujitsu professionally supports SAP HANA projects in every respect. The Fujitsu SAP HANA Global Demo Center. Fujitsu offers solutions and services that deliver optimal support towards a SAP real-time data platform. benchmark-proven energy efficiency. market-leading technology.” Fujitsu SAP HANA Infrastructure Offering The Fujitsu portfolio for SAP HANA addresses the requirements of various customer segments — from specific turnkey appliances for small and midsize companies to customized solutions for large enterprises: The Fujitsu Compact Appliance is optimized for HANA implementations in combination with SAP Business One and SAP Business All-in-One. which customers can access remotely to test and tangibly experience the business impact of SAP HANA The innovative FlexFrame Orchestrator. SAP Pinnacle Awards in the category “Technology Innovator of the Year. SAP NetWeaver BW on HANA. In its role as a pioneering SAP HANA partner. a consistent and uniform management platform for SAP landscapes. for example. project preparation. that reduces the overall administration work and helps customers to save money By combining expertise in infrastructure solutions with BI knowledge. Fujitsu solutions reduce operational costs through server management. and additional services. The staging options are: SAP Business One. Finally.1 ideally suited to drive several development and test projects simultaneously. partner coaching. Alternatively. tests. that pre-installation is an optional service. quality assurance. Fujitsu Power Appliance — Single-Node (Scale-up) The single-node configurations based on Fujitsu PRIMERGY RX600 S6 and RX900 S2 server technology represent an attractive TCO-optimized entry-level offering that provides high performance and capacity. The Fujitsu offering has been designed based on a building-block principle to ensure optimal flexibility. SAP Business One on HANA Appliance software and SUSE Linux installation plus all necessary HW settings. Note. and many others. analytics powered by SAP HANA SW stack. the partner can install the software components onsite. Fujitsu’s high-quality pre-installation ensures a ready-to-connect delivery for fast and non-disruptive HANA implementation. and SUSE Linux installation plus all necessary HW settings. and for SAP Business One on HANA. customers can employ HANA single-node systems as building blocks in multi-node environments should they decide to shift from a scale-up to a scale-out scenario. which are available with four different main memory options—64 GB. SUSE Linux installation only plus all necessary HW settings The Fujitsu Compact Appliance for SAP HANA is rounded off by a set of optional services including SAP Business One Migration. .ramp-up phase of more than 100 successful implementations over a 12-month period. Going further. extended maintenance for hardware or the SUSE Linux operating system. The tower and rack systems. 96 GB. and training Initial SAP HANA implementations with limited scope Business Suite on HANA The single-node systems are available in different T-shirt sizes and also as a virtualized system with VMware vSphere 5. 128 GB and 256 GB—enable customers to tailor their configurations to suit their distinctive environments and use cases. for analytics powered by SAP HANA. These offerings are ideal for: SAP HANA proof of concept/proof of value projects SAP HANA environments for development. It allows more than 100 combinations of certified infrastructures. staging options. Fujitsu PRIMERGY TX300 S7 and PRIMERGY RX350 S7 servers are SAP-certified platforms for SAP Business One. however. even in the event of a complete data center failure. It is then automatically distributed within the entire server environment. Support Infrastructure As an additional. The concept is based on industry-standard PRIMERGY RX600 or RX900 building blocks combined with a shared NetApp FAS storage system. This mono-socket rack server supports the following functions: Efficient SAP HANA software maintenance: initial installation and upgrade Seamless integration into the customer’s systems management landscape Easy remote support access as a key element of the solution-maintenance offering (SolutionContract) System administrators benefit from the IMS component when software updates are required in multi-node environments because the update needs to be started only once from the IMS. the architecture is designed for almost unlimited scalability. High availability is thus already built into the smart concept.Fujitsu Power Appliance — Multi-Node (scale-out) Fujitsu designed its multi-node offering concept for SAP HANA for productive environments and mission-critical use. the Fujitsu SAP HANA infrastructure solution always includes a PRIMERGY RX 100 Infrastructure Management Server (IMS). if the main memory experiences a data loss. certified component. thanks to the differentiation between the worker nodes and the standby nodes that take over when a productive server fails. The existing solution is certified for up to 16 TB of main memory. One major benefit of the multi-node system is that it enables customers to start small and then easily add and integrate PRIMERGY servers and storage capacity as their requirements expand. This architecture guarantees disaster resilience with continuous operation. Fujitsu paid special attention to high availability as a major component for mission-critical readiness of the overall SAP HANA solution. which ensure that all data are constantly mirrored. Significantly. Thus. It is . Additional Required Software The AISConnect software enables customers to remotely access to the SAP HANA landscape. customers can satisfy their greatest system availability demands by expanding the infrastructure to a two-site concept. then the data can be copied back from the storage system. The second pillar ensuring high availability is the Network File System (NFS) and the shared NetApp FAS storage system. in which all of the infrastructure components and data are mirrored in a second data center. However. In developing this system. All of these services are based on proven methods. which is operated by our subsidiary . It represents a mix of proactive and reactive services that ensure that malfunctions are solved before they can have any impact on the customer’s operations. test offerings. Consequently. However. and comprehensively tested system on the customer’s premises. and network products provided by multiple vendors. Consequently. Fujitsu is the single-point-of-contact for all of the infrastructure components involved in a Fujitsu solution as well as their interactions. The SolutionContract offers several service level options depending on individual requirements. individually staged. Fujitsu values a sophisticated and unique approach that goes well beyond the mere assembly of hardware components and the pre-installation of the HANA software stack and the SUSE Linux operating system. Additional Information on the Fujitsu SolutionContract (Solution Support) The Fujitsu SolutionContract is the maintenance and support service for specific Fujitsu solutions. Multi-nodes typically require a few days. Support Services Fujitsu offers its customers a complete set of infrastructure-related services that cover all project phases — from a customer-specific solution concept to continuous solution support ensured by the Fujitsu SolutionContract. Additional information on the Fujitsu Pre-installation (Solution Implementation) Pre-installation allows fast time-to-value and a rapid return on investment. it can be implemented and integrated rapidly using proven methods. The Fujitsu Power Appliance for SAP HANA is delivered as a completely installed. software. depending on the project size and complexity. and professional database optimization and migration as well as decision-making support based on cost estimates and financing options. Customer-specific settings such as IP addresses and switch configurations are also prepared in the dedicated Fujitsu staging center. Single-node implementations are generally completed within 48 hours. This concept takes into account the fact that Fujitsu solutions consist of hardware. The installation is steered by dedicated scripts that help to avoid human failure and ensure the highest possible quality.therefore a prerequisite component for the solution-maintenance offering (SolutionContract). Additional SAP HANA Services The SmartStart Toolbox is a Fujitsu service portfolio that helps customers answer typical questions such as: How can SAP HANA help me solve specific problems in my business enterprise? How can we migrate our existing data securely? How much will the SAP HANA implementation actually cost? The portfolio includes demos. One caveat: SAP software support is not part of this contract. and they follow strict guidelines to ensure high-quality projects. The services are partly provided by the Fujitsu SAP HANA Global Demo Center. thus adding even more comprehensive high-availability and disaster-recovery capabilities. and Arezzo—and 49 municipalities. After considering a number of alternatives. BI. This solution is designed for all enterprise environments and for every kind of IT provisioning model. Overall it serves roughly 1. The process of updating Publiacqua’s business services required a major effort from the IT Systems Department. FlexFrame for SAP increases efficiency and reduces costs by more than 50% when it manages environments running SAP Enterprise Resource Planning (ERP) applications.p. Prato. and helps optimize business processes. Customer Success Story Publiacqua Since January 1. which had to perform to extraordinary standards while maintaining a tight focus . FlexFrame Orchestrator supports consistent and uniform management of all SAP landscapes. regardless of whether the applications are run in the customer’s data center. including SAP HANA infrastructures. Publiacqua launched a technology audit with an eye to building a business intelligence environment that is flexible.A. delivered as a managed service or a hosting service from an external provider. Smart Start Toolbox Overview This offering is under constant development and extension.000 properties.000 people across more than 380. Pistoia. The company has 648 employees and turnover of €160 million. or deployed from the cloud. fast. Innovation — Uniform Management for All SAP Environments including SAP HANA with FlexFrame Orchestrator This new Fujitsu platform solution is based on knowledge accumulated from more than 300 projects that successfully utilized the Fujitsu FlexFrame for SAP solution. Publiacqua opted to integrate SAP HANA into its existing SAP infrastructure. database.TDS. Publiacqua S. The demo center hosts a remotely accessible environment comprised of a system landscape for SAP HANA applications that is maintained by a professional team of developers and consultants for solution. has been contracted to manage the integrated water services for Italy’s Local Authority Water Board No 3 – Medio Valdarno. and business process matters.277. 2002. It provides services across four Italian provinces—Florence. The company was convinced that SAP HANA was the perfect system to create an environment that would ensure maximum infrastructure stability while providing the most flexible and rapid processing functions. The project’s primary goal was to consolidate operating and management reporting – together with strategic planning — within a single data warehouse architecture that was capable of handling a growing number of users. the complete network infrastructure — NICs. the project has achieved all of its investment containment goals. Last but not least. For this system.com/fts/flexframe www. The solution’s key features are: The HANA scale-out infrastructure is designed so there is no single point of failure. its functions are taken over by a standby node. Fujitsu and TAI (Top SELECT Expert Partner of Fujitsu) were the perfect technology partners to help Publiacqua successfully complete this phase of its development. . network — will be corrected automatically with minimal. If a server fails.fujitsu. all levels of management have easy. Consequently. “The choice was made to go with SAP HANA technology and Fujitsu Technology Solutions systems. More than one standby node can be configured as an option. Furthermore. The storage is designed for highest availability — many disks or even a storage controller can fail without causing operations to stop. downtime. storage. In addition.com/fts/hana www.fujitsu.fujitsu. Technology Infrastructure Manager at Publiacqua. then.sap@ts. the new architecture has reduced the TCO of the business intelligence infrastructure. any failure in the infrastructure — server. SAP Internal Project: SAP NetWeaver BW Powered by SAP HANA The new SAP Internal SAP NetWeaver BW powered by SAP HANA performs a central role in the corporate analytics architecture.” says Mauro Cacciafani. cables. and flexible access to all of the necessary reporting functions. or contact us at: expert. fast. if any. for the combined and integrated planning with BW IP and SAP BusinessObjects Planning and Consolidation. For further information see SAP Blog Further Information For more information please visit: www. for example. switches — is designed to cope with component failures without the user even noticing that something has broken.com/fts/sap Feel free to get in touch with your local Fujitsu sales representative. In sum. Thanks to the updated infrastructure provided by Fujitsu and TAI. an ever-increasing number of users can now utilize the business’s data assets.fujitsu.on the principles outlined in the business plan. which ensure simple and certified native recovery of environments in the event of failure.com. SAP decided to implement a Fujitsu Scale-Out HANA solution based on PRIMERGY servers. With this in mind. including SUSE Linux 11 (for SAP) and SAP HANA. SAN: Fibre Channel host bus adaptors Blade servers: Hitachi Compute Blade 2000 offers the considerable I/O capacity and onboard memory that are required for effective implementation of SAP HANA. As additional applications and business units use SAP HANA or the organization’s data volumes increase. The HDS SAP HANA Solution is pre-integrated in Hitachi Data Systems distribution centers and is architected to meet SAP’s high standards. optimized.999% uptime rating. Intelligent automation of complex tasks enables rapid provisioning of resources with the assurance that the appropriate underlying infrastructure components are in place. and targeted provisioning to help ensure consistent.Hitachi Unified Compute Platform Select for SAP HANA Hitachi Unified Compute Platform Select for SAP HANA is an SAP-certified. Pre-configuration and SAP validation of key components drastically reduce onsite deployment time. down to the dual battery backup that protects the cache during power outages. pre-packaged solutions with enterprise-class components across the entire stack. reliable results: Pre-validated reference architectures. and ‘Large’ —enable users to easily scale system processing capability without “forklift upgrades” or complete system overhauls. ‘Medium’. simpler deployment offered from a single source for ordering and for providing services for planning and implementation. predictable results as organizations look to manage and store massive volumes of rapidly changing data. all three Hitachi SAP HANA appliances sizes — ‘Small’. repeatable.999% uptime with SAP in-memory computing technology for a broad range of high-speed analytic capabilities. is designed for high availability. Hitachi SAP HANA Appliances Sizes Each Hitachi Data Systems Converged Platform for SAP HANA – ‘Small’. This platform is comprised of Hitachi Compute Blade 2000 and Hitachi Unified Storage (HUS) 130. intuitive access to data. each platform offers a scalable patch to easily increase the system’s processing capability. Customers may elect to start with a ‘Small’ configuration and easily scale to ‘Medium’ or ‘Large’ by inserting additional blades into the server chassis. Systems include 4-way . and converged infrastructure platform for SAP HANA that enhances an organization’s decision-making capabilities while providing advanced business insights based on instant. Faster time-to-value: Quicker. and ‘Large’– is delivered as a single unit that is ready to plug into the customer network. ‘Medium’. There is no need to change server models because scaling requires a ‘Medium’ or ‘Large’ appliance size. Exceptional performance: High-density computing and throughput with wide-striping technology for enhanced utilization. Hitachi Unified Compute Platform Select for SAP HANA includes: Operating System: SUSE Linux Enterprise Server 11 SP1 for SAP Storage: Hitachi Unified Storage 130. In addition. Customers can derive the following benefits from Hitachi Unified Compute Platform Select for SAP HANA: Predictable. It contains symmetric active-active controllers that self-balance workloads. Customers benefit from flexible server management capabilities and scalable architectures. with a 99. an enterprise-class storage system rated at 99. 0 SAP IMCE Server 1. Operating System: SUSE Linux Enterprise Server 11 for SAP Storage: Hitachi HUS 130. All three options come with Hitachi Unified Storage 130 storage subsystems and with SAP HANA pre-loaded. Studio SAP Host Agent Sybase Replication Server 15. It contains symmetric active-active controllers that self-balance workloads. SAP HANA: SAP HANA Load Controller 1.0 terabytes of RAM. down to the dual battery backup that protects the cache during power outage. which is designed for high availability.0. Hitachi supports SAP HANA from the smallest configuration with a single Compute Blade and 256 GB of RAM to the largest configuration of 4 Compute Blade 2000s and 1.5 +ECDA Hitachi Unified Compute Platform Select for SAP HANA — Small. Medium. Network: Fibre Channel host bus adaptors Compute: Hitachi Compute Blade 2000 offers the large I/O capacity and onboard memory required for effective implementation of SAP HANA . Client. Large — meets varying performance requirements.x86 blade servers with Intel 10-core processors. Development.. and Support Services for a HANA initiative. Hitachi has won numerous SAP awards for exceptional customer satisfaction. and HANA Appliance. Hitachi also ensures the necessary storage performance and high throughput to meet the stringent demands of in-memory computing. The HANA Implementation Service ensures a smooth integration with lower risk and accelerated deployment of the Hitachi Unified Compute Platform Select for SAP HANA tailored to our customer’s specific needs. Along with our consulting partners such as Hitachi Consulting. During this time. and comprehensive services for converged platforms to help customers further streamline their SAP environments. In addition.Figure 1 — Hitachi SAP HANA Appliance Architecture Hitachi-SAP Alliance Since 1994. and its subsidiaries. Ltd. have had a strategic relationship with SAP that includes the sale. this platform helps business leaders gain near real-time insights and information to make smarter business decisions. software. and . Support Infrastructure Hitachi Data Systems Global Services and Hitachi Consulting are equipped to support every aspect of an SAP HANA solution. infrastructure. proven methodologies. Modern information technologies have blurred the lines between infrastructure. the highest level of partnership SAP offers. faster. Services Hitachi Data Systems Global Solution Services (GSS) offers experienced infrastructure consultants. Integration. Hitachi became an SAP Global Technology Partner. they provide strategy. and implementation of SAP solutions. Hitachi. integration. including Hitachi Data Systems. In 2011. By dramatically reducing the traditional delay between operations and analytics. we can integrate and customize the solution into the customer’s SAP environment. Many large global enterprises run their business on SAP and Hitachi. highlyoptimized environment that ensures the desired results in a lower-cost. lower-risk. fully integrated solution is a tremendous benefit. . having one partner who provides a single.hds.com. Contact Hitachi If you would like to get in touch with the SAP team at Hitachi.applications. high-businessvalue HANA initiative. You can find additional information at www.hitachiconsulting. Hitachi’s full breadth of capabilities delivers one fully integrated. please email sap@hds. Given this reality.com/hana.com/go/sap or Hitachi Consulting: http://www. . S. M.000 SAP installations worldwide. This strategic partnership has ultimately resulted in product offerings like HP AppSystems for SAP HANA as well as value-added services to implement rapid-deployment solutions for SAP HANA. HP and SAP have worked together to offer an innovative and comprehensive portfolio of products and services that help more than 25. During this partnership. in addition.000 joint customers around the world of all sizes. successfully implementing them on customer sites. integrated solutions that address the growing and complex needs of our customers. SAP HANA HP has also recently received the following Pinnacle awards: Run SAP Partner of the Year winner Global Software Solution Partner of the Year finalist Global Technology Partner of the Year finalist HP AppSystems for SAP HANA are built on an HP converged infrastructure for purpose-built. solve their business problems. collaborative partnership that spans more than 20 years. based on industry-leading HP BladeSystem Servers. The company offers a portfolio of six configurations (XS. M. The portfolio includes: Multiple single-node configurations (XS. S. M+. with fully automated failover for high availability HP’s Unique Value Proposition for SAP HANA HP has collaborated with SAP on in-memory technologies from the beginning In 2006 it became the first SAP partner to design and deliver SAP NetWeaver ® Business Warehouse Accelerator. and HP infrastructure runs nearly half of all SAP installations in the world. HP received numerous SAP Innovation and Impact awards across all three geographic regions. L. This solution portfolio incorporates hardware. In fact.7 million users in more than 50 countries. Based on that experience. it has developed a core competency for designing and building SAP appliance-based solutions. with the most recent ones being: Technology Partner of the Year/SAP HANA Impact Award (APJ) Innovation Partner of the Year Award (EMEA/DACH) North American SAP Services Partner of the Year for SAP HANA SAP Services Partner of the Year.HP SAP HANA Solutions Through a close. and offering industry-leading support services to ensure optimal performance throughout their lifecycle. and services into predefined configurations for a powerful and comprehensive set of solutions that are designed to work together. XL) to meet the needs of any-sized business. supporting 1. HP has developed the core competencies to deliver successful implementations of HP AppSystems for SAP HANA. M+. in all industries. HP is a global leader in SAP operations. software. HP has implemented more than 77. L) based on industry-leading HP ProLiant DL580 and DL980 G7 Servers An XL scale-out configuration. the industry-leading blade solution that is ideal for SAP HANA scale-out implementations. and on HP ProLiant BL680 G7 Server Blades for larger scale-out requirements. L. S. HP delivers a unique storage platform based on the HP X9300 Network Storage System that offers unlimited scale-out capability and disaster-tolerant features. For the SAP HANA scale-out technology. HP X9300 Network Storage Systems deliver excellent performance and a modular storage infrastructure to accommodate unprecedented storage growth and performance. M. XL) HP ProLiant DL580 G7 Servers or HP ProLiant DL980 G7 Servers for XS to L singlenode configurations HP ProLiant BL680 G7 Server Blades for XL highly scalable configurations for up to 8 TB of compressed data HP Storage for log files and data files HP X9300 Network Storage Systems for scale-out cluster file systems HP Networking with HP Virtual Connect and ProCurve HP ProLiant Service packages and HP Insight Control management software HP Fast Start Service HP Technology Support Services SAP HANA T-Shirt Sizes Offered .Industry-Leading Technology—Optimized for SAP HANA HP designed the HP AppSystems for SAP HANA on industry-leading x86 HP ProLiant DL580 and DL980 G7 Servers for single-node SAP HANA implementations. HP AppSystems for SAP HANA Based on HP Converged Infrastructure products Multiple configuration choices. Designed to be extremely scalable. flexible. sized for your company’s needs (XS. providing a large contiguous memory footprint for faster in-memory applications. and cost-efficient. The scale-out solution in the portfolio of HP AppSystems for SAP HANA is based on HP ProLiant BL680c G7 Server Blades. M+. HP offers both synchronous and asynchronous disaster-tolerance solutions. HP P6500 Enterprise Virtual Arrays (EVA) delivers high-throughput. High Availability and Disaster Recovery .Scale-out Offering HP offers a unique scale-out offering that provides the high availability your business demands today. and reduce the costs of downtime. config files. HP’s scale-out solution provides high availability through a stand-by blade with automatic failover. redundant storage for data and log files. and down-time associated with future field upgrades. difficulties. SYS files. as well as a future-ready solution that can grow as your needs grow. and the shared storage. and more. traces. In doing so they help to mitigate risk. in addition to disaster-tolerant technology. This design significantly reduces the costs. industry-leading technology including: HP BL680c G7 Server Blades are the blade solution that is ideal for SAP HANA scale-out implementations for balanced computing to handle the most demanding enterprise class applications. These solutions are designed to protect your information systems in the event of a catastrophic event. HP’s scale-out solution is based on proven. The HP X9300 IBRIX Network Storage System is a unique storage platform that offers unlimited scale-out capability and disaster-tolerant features. HP networking solutions like HP Virtual Connect for simplifying and virtualizing the connectivity between the HANA blade nodes. available either as standard integrated functionality of the scale-out solution or as an add-on. the network. improve IT availability. mission-critical. This includes the sizing of the appropriate system. For mission-critical deployments and shared-storage infrastructures. deploy and migrate servers quickly. and control servers from anywhere. HP has delivered a fully automated failover mechanism for high availability. Based on Multi-Level Cell (MLC) and Single-Level Cell (SLC) NAND Flash technology. solid-state PCIe card-based solution for enhancing application performance. high availability. optimize power consumption and performance. As mentioned earlier. where we integrate the hardware.With HP AppSystems for SAP HANA. and they include all required components. HP includes its core competency process for factory integration. HP also provides monitoring and backup software solutions HP to further enhance your solution. SIM is also available as a component of the Insight Control suite of management software. which is available for purchase from HP. a stand-by blade that automatically is activated upon a failure of any node in the cluster. This system is designed for high availability and extreme scalability while delivering excellent performance and a modular storage infrastructure to accommodate unprecedented storage growth. and services from a single resource. load all of the software components. Design and Build With every SAP HANA system. HP includes the resources to assist with the sizing and configuration of an SAP HANA environment. Additional Software HP ensures global quality standards by preloading and configuring SAP HANA software at the factory before delivery. the HP X9300 IBRIX Network Storage System features an NFS cluster file system and support for single-node high availability. and disaster tolerance. Consequently. HP’s scaleout solution is already equipped to enable this functionality. services and support. from any location. Support Services HP delivers a comprehensive solution that encompasses hardware. and apply your unique environmental settings for network and source . these devices are ideal for accelerating I/O performance and maintaining SAP HANA log file data. software. This powerful yet intuitive solution provides hardware-level management for system administrators to improve system uptime and health. Insight Control integrates specific management functionality into HP Systems Insight Manager to manage server health. regardless of the number of nodes in the cluster. No additional software is necessary for the HP AppSystems for SAP HANA. The result is superior management of physical and virtual servers. Storage Infrastructure HP PCIe IO Accelerator for HP ProLiant Servers is a direct-attach. available both with HP ProLiant servers and as a free download from HP. HP AppSystems for SAP HANA can be easily monitored utilizing HP Systems Insight Manager (SIM). HP Insight Control server management software unleashes the management capabilities built into every HP ProLiant server. in addition to recommendations concerning the configurations to address your requirements for multiple SAP landscapes. All solutions are built to your specifications. implementation. HP delivers the full lifecyle of services required to progress from the assessment and design of an SAP HANA solution to the build. once SAP HANA software is released with disaster-tolerance capability. and support of the solution. Then. disaster tolerance is designed into HP’s SAP HANA technology today. with every SAP HANA order. Only one node is needed. regular system health checks. Proactive Care Service features remote and onsite support. critical to successfully getting SAP HANA up and running. the system completes a burn-in test before we ship the order to your location. The HP Impact Analysis for SAP HANA helps you understand the technical feasibility of introducing SAP HANA to meet your real-time and high-volume data analysis requirements. computing your ROI. HP can take the first call on any SAP HANA support issue.systems. and use of. It is highly recommended for each SAP HANA implementation. Beyond the design and build of a SAP HANA solution. Based on this well-established process. proactive scans and reports. integration of the solution into your environment is equally. and implementing an HP AppSystem for SAP HANA into your SAP landscape. HP delivers enhanced support from trained specialists in its Advanced Solution Center. The basic foundational service includes the following: Incorporation of SAP HANA in the local network Connection of SAP HANA to source systems Implementation of basic security and authorizations Configuration of SAP BusinessObjects front end or Microsoft® Excel to communicate with SAP HANA Validation of the integrated environment and the end-to-end functionality of the SAP HANA system Review of the access to. the SAP in-memory computing studio Installation and configuration troubleshooting Support After a successful implementation. HP is able to deliver industry-leading support and help improve performance of SAP HANA solutions. and cloud-based environments. Proactive Care Service includes proactive support as well as hardware and software support to provide an additional level of support for organizations that are managing complex IT environments. You can purchase an option that includes an assigned local HP specialist who delivers an “Account Support Plan” customized to fit your needs. HP turns over support of your SAP HANA solution to HP’s support services team. and setup of remote monitoring. Implementation Delivery of the SAP HANA appliance is not the final step. For hardware and software support. so they include installation. if not more. quantify your business opportunity. and regular consultations with HP technology experts. This service includes a roadmap for implementation. virtualized. Each customized plan includes delivering updates to your hardware firmware and operating system. implementation. They include the following services. Geared for converged. HP understands this. The HP Business Intelligence Master Plan Service is an overarching BI strategy-development service designed to help you define a BI strategy and a landscape to enable your organization to realize that strategy. These services were designed exclusively for SAP HANA. . which delivers HP Proactive Care Service. Additional SAP HANA services from HP HP provides services to help you identify your strategy. and training with every SAP HANA solution we deliver. Finally. With a connection to SAP’s support operation. while minimizing risk and aggressively managing costs. global solution that recovers value from older assets.hp. Migration Assistance For existing SAP NetWeaver BW and SAP NetWeaver BW Accelerator software customers. The HP Implementation Service for SAP HANA is a complete end-to-end SAP HANA implementation based on a solution blueprint designed by a team of HP consultants. HP Migration Services—SAP HANA Appliance Software Service Pack 3 supports the deployment of an HP AppSystem for SAP HANA as the database for SAP NetWeaver Business Warehouse. On-site migration assessment workshops SAP NetWeaver BW upgrade service SAP NetWeaver BW 7. This service includes upgrading or installing SAP and non-SAP components in the landscape. It is formatted to be suitable for use in supporting budgeting processes. HP and SAP offer a migration-assistance package that . For further information please go to: www. In addition to migration services. database connections are made. This solution also helps safeguard privacy. These consultants follow the HP Global Implementation Methodology for Business Intelligence for all SAP HANA implementation projects Implementation services for rapid-deployment solutions covering a wide range of business reporting and analytics. load (ETL) of data from the source systems have been tested and confirmed as fully functional. HP is offering a migration package for current SAP NetWeaver BW customers to assist them in migrating from their existing database to an HP AppSystem for SAP HANA. The HP Landscape Preparation Service for SAP HANA is designed to ensure that the surrounding solution landscape is in place and is optimized to allow for the inclusion of the SAP HANA appliance and to speed time-to-value of the SAP HANA solution. HP Financial Services offers new HP hardware leasing and SAP software license loans plus a complete. and it complies with applicable environmental regulations for disposing of SAP infrastructure assets that are displaced by your new HP AppSystems for SAP HANA.com/go/asset_recovery. The HP Solution Assessment for SAP HANA is an engagement during which HP consultants will assess your existing information landscape in detail. identify data sets for use with SAP HANA. and create a solution blueprint based on the findings. and financial services.3 migration to a database built on SAP HANA SAP NetWeaver BW optimization for the SAP HANA database HP Financial Services HP Financial Services can make your transition to SAP HANA easy and cost effective. effective way to maximum return from IT and BI solutions. and it can help you get started even sooner. HP Fast Start Service includes required services that accompany the appliance to ensure that the appliance is properly installed. You can expand your organization’s SAP HANA initiatives by taking advantage of an efficient.The HP Financial Assessment for SAP HANA provides granular information to support your decision-making process. transform. and the replication and extract. detect any gaps in the current environment. HP and SAP recognize that migrating your environment to SAP HANA will involve extra effort and incremental costs. as listed below. To help ease the transition. asset recovery services. this package includes complimentary phone assessment services. HP Leads the Way with First-ever Benchmark Results for SAP HANA SAP partnered with HP to co-develop the new SAP standard application benchmark for the SAP NetWeaver Business Warehouse application. sales. “HP and SAP quickly delivered a turnkey solution that provides simplicity. consider the case of T-Mobile.990 ad-hoc query navigation steps per hour with 1 billion records (certification number 2012023) on the SAP HANA platform. called the enhanced mixed load (EML) benchmark. and they deliver outstanding. executive vice president and general manager of Global Database and Technology.” explained Paul Miller. SAP standard application benchmarks are designed to represent customer-relevant scenarios in many different business contexts. As the company expanded and constantly added new branches in different cities. dispatching. 2012.” “SAP. a single-node. and marketing. accurate data its executives needed to make informed business decisions. planning. in cooperation with HP. powerful performance of its HP ProLiant DL980 server and the professional services provided by the HP team. “T-Mobile needed faster and better customer insight from its varied data systems. medium-sized HP AppSystem for SAP HANA configuration achieved an amazing 65. Unfortunately. it needed to implement a database solution that could keep pace with its impressive growth while providing the real-time. T-Mobile provides more than 33 million customers with customized wireless plans that reflect their smartphone and data needs. performance. These demands are shaped primarily by three major requirements: near real-time reporting. Nongfu Spring’s manufacturing environment now runs more . “With SAP HANA. T-Mobile can more effectively track its marketing campaigns’ success. and reduction of TCO. an established and expanding national consumer brand in China with a vast scope of operations encompassing production. A key component of the company’s marketing strategy is to conduct highly targeted customer communications concerning mobile phone services and offers. Posting the FIRST RESULT on the SAP EML standard application benchmark. manages. SAP. This new SAP EML standard application benchmark simulates the current demands of typical SAP NetWeaver BW customers.sap. and measures its wireless plan offers. The U.) Additional details can be found at http://www. worked to support the creation and delivery of a unique and differentiated customer-tracking solution for T-Mobile. logistics. wireless operation of Deutsche Telekom AG. ad-hoc reporting capabilities. its previous analytics solution was too complex and could not track customer offers in a timely way. These systems have revolutionized user access to data. The results achieved by HP on the standard performance benchmark demonstrate the ability of an HP AppSystem for the SAP HANA database to deliver on today’s new customer requirements. (These are the results as of May 16. To accomplish this task.com/benchmark Customer Success Stories For an example of the outstanding results that can flow from an HP–SAP collaboration. The solution—built on HP Converged Infrastructure in collaboration with SAP AG and deployed in just two weeks—enhances T-Mobile’s ability to deliver targeted marketing campaigns to customers by transforming the way it delivers.” Another illuminating example is Nongfu Spring. multidimensional databases. vice president of Converged Systems at HP. scalable analytic performance in seconds versus hours on massive. and faster time-to-value.features a combination of HP financing options and a portfolio of migration services you can use to clear the path to faster data analysis. With the new system in place.” revealed Steve Lucas. Nongfu Spring chose HP AppSystems for SAP HANA due to the stable.S. which had affected our business. For example.” asserts Nongfu Spring CIO Patrick Hoo. It also built a solid foundation for our IT department to provide strong support for the company’s rapid future business development. visit http://www. .com/go/sap/hana or contact your HP sales representative. Another benefit: Financial reporting times have reduced from seven to three days.” Contact information for inquiries For more information. we have proven that HANA is a high-speed in-memory computing column-storage database product that is mature and practical. “By cooperating with HP on SAP HANA 1.0. It fundamentally solved the problem of slow computing and presentation of data caused by having too much data.smoothly—and with more accurate data. the increased computing speeds enable the company to analyze data 200-300 times faster than with their previous database platform. “The market today is changing constantly.hp. and companies and the market environment have more new IT requirements. Huawei has partnered with SAP to create an appliance based on Huawei’s high-end Tecal RH5885 V2 rack server. RH5885 V2 offers enhanced system reliability thanks to its 35 RAS features.000x faster than disk-based DB. RH5885 V2 is a high-end 4-socket rack server that is expandable to 8 sockets. It is a revolutionary platform that is ideally suited to run real-time analytics and to develop and deploy realtime applications. The RH5885 V2-based appliance for SAP HAHA is able to deliver the fastest write performance in the industry for SAP HANA write patterns. No. and ERP.1 writing performance with 15% less latency and 20% more bandwidth Pre-optimized and one-stop maintenance Powered by RH5885 with 35 RAS features. 1 in 12 SPEC tests Infrastructure The RH5885 V2 for SAP HANA offers a preinstalled. Highlights 100-100. Figure 1: Tecal RH5885 V2 Front View Figure 2: Tecal RH5885 V2 Rear View . These features combine with scalable I/O to make RH5885 V2 an ideal choice to deploy mission-critical applications such as large-scale databases. optimized appliance ranging from XS to L Size that supports the SAP HANA application stack in a single host. business intelligence.Huawei SAP HANA Solutions The SAP HANA is a data platform that can be deployed either as an appliance or in the cloud. It has less than 15% latency as well as 20% more bandwidth. It offers solutions ranging from entry-level supporting 128 GB of memory to large-scale supporting up to 100 TB of usable memory with 100 nodes. preconfigured. and it can accommodate up to 80 cores with 4 TB of memory. It enables real-time processing of massive amounts of data in the main memory of a server. It supports Intel® Xeon® E7-8800/4800 series CPUs. No. This appliance provides outstanding performance when it is used in combination with SAP HANA. Model Specifications Table 1: Tecal RH5885 V2 for SAP HANA M-Size Included Software and Driver SLES for SAP Applications 11.2 SAP HANA Appliance software (license is sold separately by SAP) Huawei Tecal ES3000 driver More information http://enterprise.huawei.com/en/products/itapp/server/rh-series-rack-servers/hw-145982.htm http://enterprise.huawei.com/en/products/itapp/server/high-performance-pcIe-card/hw-194918.htm IBM Systems and Services Solutions for SAP HANA SAP HANA deployed on IBM System x Workload Optimized Solutions with the IBM General Parallel File System (GPFS) offer simple, seamless scalability for your SAP HANA environment. In addition, IBM offers installation and managed services to help you manage your SAP HANA infrastructure cost-effectively. IBM Global Business Services (GBS) can help you extract the business value out of your SAP HANA implementation. IBM and SAP team for long-term business innovation With a unique combination of expertise, experience and proven methodologies — and a history of shared innovation — IBM can help strengthen and optimize your information infrastructure to support your SAP applications. IBM and SAP have worked together for 40 years to deliver innovation to their shared customers. Since 2006, IBM has been the market leader for implementing SAP’s original in-memory appliance, the SAP NetWeaver Business Warehouse Accelerator (BWA). Hundreds of BWA deployments have been successfully completed in multiple industries and countries. These BWA appliances have been successfully deployed in many of SAP’s largest business warehouse implementations, which are based on IBM hardware and DB2 — optimized for SAP. IBM and SAP offer solutions that move business forward and anticipate organizational change by strengthening your business analytics information infrastructure for greater operational efficiency and offering a way to make smarter decisions faster. IBM eX5 Systems with GPFS Power SAP HANA SAP HANA, delivered on IBM eX5 enterprise servers with fifth-generation IBM® Enterprise XArchitecture® technology (eX5), helps transform the enterprise by addressing current needs while delivering the robust scalability and performance needed to accommodate growth. SAP HANA running on powerful IBM eX5 enterprise servers with the Intel Xeon processor E7 family combines the speed and efficiency of in-memory processing with the ability to analyze massive amounts of business data — enabling companies to eliminate barriers between real-time events and real-time business decisions. IBM is the first to decouple memory and input/output (I/O) from the processor — moving processing power from what’s theoretically possible to what’s actually possible. IBM System x servers with fifth-generation IBM eX5 technology enable SAP HANA customers to benefit from a shared vision that delivers simplicity and automation designed to help organizations accelerate business outcomes while lowering TCO. IBM eX5 enterprise servers with Intel Xeon processors offer extreme memory and performance scalability. With improved hardware economics and new technology offerings, IBM is helping SAP realize a real-time enterprise with in-memory business applications. IBM eX5 enterprise servers deliver a long history of leading SAP benchmark performance. These System x servers are equipped with processors from the Intel Xeon processor E7 family, which combine exceptional raw compute power with increased memory bandwidth and support for significantly greater memory capacity to deliver superior performance to previous-generation processors. With up to ten cores in each processor, the four-socket x3850 X5 can be scaled to 40 cores and 80 threads with the use of Intel Hyper-Threading Technology. Organizations can achieve extreme scaling within each node for running demanding workloads on a compact system. SAP HANA is a business-critical technology and requires a robust and reliable enterprise computing platform. Sophisticated eX5 features such as Predictive Failure Alerts warn ahead of potential hardware failures, trigger preemptive action, and help maintain application availability. In addition, eX5 features such as eXFlash solid-state disk technology can yield significant performance improvements in storage access, helping deliver an optimized system solution for SAP HANA. Standard features in the solution such as the High IOPS MLC Duo Adapter for IBM System x can also provide fast access to storage. Workload Optimized Solutions IBM offers several Workload Optimized Solution models for SAP HANA. These models, based on the 2-socket x3690 X5 and 4-socket x3950 X5, are optimally designed and certified by SAP and can be ordered as a single appliance part number. They are delivered preconfigured with key software components preinstalled to help speed delivery and deployment of the solution. The IBM System x3690 X5 is a 2U rack-optimized server. This machine brings the eX5 features and performance to the mid tier. It is an ideal match for the smaller, two-CPU configurations for SAP HANA. The x3690 X5–based configurations offer 128 to 256 GB of memory and the choice of only solid-state disk or a combination of spinning disk and solid-state disk. The x3950 X5–based configurations leverage the scalability of eX5 and offer the capability to pay as you grow — starting with a 2-processor, 256 GB configuration and growing to a 8-processor, 1 TB configuration. The IBM System x3950 X5 is the workload-optimized version of the 4U x3850 X5 server, the new flagship server of the IBM x86 server family. These systems are designed for maximum utilization, reliability, and performance for compute-intensive and memory-intensive workloads such as SAP HANA. This server is ideal for the medium- and large-scale SAP HANA implementations. The x3950 X5–based configurations integrate either the 320 GB High IOPS SD Class SSD PCIe adapter or the 640 GB High IOPS MLC Duo Adapter. Note: An 8-socket configuration uses a scalability kit that combines the 7143-H2x* with the 7143-H3x* to create a single 8-socket, 1 TB system. IBM and SAP have worked closely together to validate each of the workload-optimized configurations and have also collaborated on performance testing. Performance testing of SAP HANA running on IBM eX5 enterprise servers and have demonstrated the ability to handle 10,000 queries per hour against 1.3 TB of data, returning results within seconds. Outstanding results like this are founded on years of joint product development which allows IBM and SAP offerings to be integrated for simplified implementation. This is true of IBM’s DB2 database which is tightly aligned with SAP HANA for seamless replication of data when using the Sybase replication server. Simple and Seamless Scalability Using the workload-optimized solution models you can combine multiple models together to create multi-node scale-out configurations. These multi-node scale-out configurations enable you to achieve larger SAP HANA memory sizes simply by adding compute nodes. IBM was the first vendor to have multi-node scale-out configurations and currently has 4-node x3690 X5 and x3950 X5 and 16 node x3950 X5 solutions validated. You can start with one 256GB node, upgrade to a 512GB node, and grow your environment to 16 nodes. This modular approach enables you to invest in a WorkloadOptimized solution for SAP HANA and grow your infrastructure as your SAP HANA environment grows. In addition, you can handle unplanned outages by including an additional High-Availability (HA) node in your configuration. These multi-node scale-out configurations do not require an external Storage Area Network (SAN) or multiple SANs. The IBM General Parallel File System™ (GPFS™) software in these configurations has the unique capability to use the storage contained within each node helping to simplify the They need a partner to help them assess their current capabilities. For more information about the IBM Systems solution for SAP HANA and the IBM System x Workload Optimized Solutions for SAP HANA. IBM also offers skills and enablement services for administration and management of IBM eX5 enterprise servers. you can realize faster performance. IBM Lab Services and IBM Global Technology Services offer quick-start services to help set up and configure the appliance and health-check services to ensure it continues to run optimally. These workload-optimized solutions for SAP HANA can help simplify operations. IBM also offers skills enablement services to provide technical training to your teams that need to manage the HANA appliance. can help move beyond simply adding storage to optimizing data management for SAP HANA. If you determine that you do not want to manage the SAP HANA appliance. while delivering the ability to quickly change the way users look at mass amounts of data without compromising data integrity or security.infrastructure required for SAP HANA. identify areas for improvement and develop a strategy for moving . less complexity and greater efficiency from a powerful and proven converged infrastructure environment of integrated technologies. consolidate resources and dynamically migrate functionality as business changes. High-performance enterprise file management using GPFS gives SAP HANA applications: Performance to satisfy the most demanding SAP HANA applications Seamless capacity expansion to handle the explosive growth of data SAP HANA environments High reliability and availability to help eliminate production outages and provide disruptionfree maintenance and capacity upgrades Seamless capacity and performance scaling — along with the proven reliability features and flexible architecture of GPFS — help your company foster innovation by simplifying your environment and streamlining data workflows for increased efficiency for SAP HANA applications. with its high-performance enterprise file management. A trusted service partner Many clients require more than software and hardware products. GPFS™. In addition. IBM offers Quick Start implementation services to help you install and configure your SAP HANA appliance and HealthCheck services to help you manage and maintain your SAP HANA appliance. please read the IBM Redpaper: SAP In-Memory Computing on IBM eX5 Systems Services to speed deployment To help speed deployment and simplify maintenance of your x3690 X5 and x3950 X5: Workload Optimized Solution for SAP HANA. Only IBM has a High-Availability concept which allows customers to seamlessly extend their installation to enable High Availability using GPFS replication and an additional stand-by node. then IBM offers a Managed Service that can provide 24x7 monitoring and management of the SAP HANA appliance. IBM Intelligent Cluster integrated packaging and assembly can help speed installation and deployment of multi-node scale-out HA configurations as well as reduce implementation risk if you require all of your HANA server nodes preassembled and packaged in a rack. By implementing SAP HANA on eX5 enterprise servers with GPFS. including industry best practices These services have been grouped into four key offerings as shown in the table below: . GBS combines its SAP implementation experience and skills with the broader IBM business intelligence competencies to create an unparalleled opportunity for our clients to not only implement SAP HANA solutions. The GBS HANA team within IBM has leveraged the experiences gained to date on SAP HANA offerings and grouped efforts into two main opportunities for clients who wish to deploy SAP HANA — “Do New Things” and “Run Existing Things Faster”. The GBS Consulting Practice offers a broad range of services for SAP HANA such as: Discovery and assessment services to maximize business impact Architecture assessment and benchmark services Proof of concept services Express deployment offerings.forward. This is where IBM Global Business Services (GBS) provides immeasurable value with thousands of SAP consultants in 80 countries. but to then take that implementation to new heights and identify transformational opportunities. IBM can also offer financing options helping clients to acquire IT solutions that are tailored to their individual goals and budget.Combining the strengths of GBS with IBM System x Workload Optimized Solutions for SAP HANA allows our customers to gain the maximum benefits of their investment in SAP HANA — and to bring those solutions to life to address immediate information needs and identify the transformational opportunities that can bring the organization to the highest levels of insight and action.com/hana.ibm-sap. or visit: www. For more information To learn more about the IBM Systems and Services solutions for SAP HANA and IBM eX5 Workload Optimized Systems. please contact your IBM marketing representative or IBM Business Partner. . .1 market share in PC-servers in the Japan market for 16 years. Why Express5800 is ideal platform for SAP HANA High-performance Express5800 Scalable Enterprise Servers. which leverage NEC’s long heritage in the development of supercomputer and mainframe technologies to achieve highly fault tolerant and flexible system expandability. One noteworthy hardware feature is its EXPRESSSCOPE® Engine SP2. All the NEC SAP HANA appliances are constructed on the Express5800 Scalable Enterprise Server that offers upward scalability to 8 sockets and 2TB memory. and ViridentTM FlashMax device for high-workload environments on scale-up configuration. It significantly increases maintainability and reduces downtime of SAP HANA. Currently. on top of NEC iStorage M500 which is highly reliable. a uniquely developed device by NEC based on our experience in UNIX servers. NEC offers both of scale-up (XS.NEC SAP HANA Solutions NEC delivers SAP HANA as a key platform to realize a world where people can reach all the information they need or want and to discover something new and worthwhile from massive amount of data produced daily. are leveraged as the platform for SAP HANA. that has 40Gb/sec theoretical bandwidth. The NEC High-Performance Appliance for SAP HANA incorporates the truly innovative inmemory computing technology of SAP and the truly dependable hardware platform of NEC which has kept the No. Also. NEC’s certified configuration aggregates four 10Gb-ethernet channels with a bonding channel for load balancing and fault tolerant. Speed of inter-node communication network is one of key factors at distributed cluster configuration. and NEC Express5800/A1040a also has capabilities to mount up to 4CPU and 1TB RAM. S and L-size. including OLTP special purpose configuration) and scale-out high-availability clustered configurations. The flagship NEC Express5800/A1080a model has capabilities to mount up to 8CPUs and 2TB RAM within a single 7U chassis. scalable and power-effective storage system. data and log volumes of clustered configuration is constructed on OCFS2 filesystem that fully leverages open source technology. fault-management functionalities through EXPRESSSCOPE® Engine SP2. enables to monitor and control Express5800/A1080a and A1040a with remote and centralized interface regardless of the power status of servers. NEC provides missioncritical class support for SAP HANA. It also offers supreme performance without compromise over the entire lifetime of the device. to collect the run-time information of both hardware and software. NEC has a lot of experience providing mission-critical grade support on Linux systems. which leverage many fast CPU cores and the PCI Express interconnect bus to deliver maximum application performance. NEC High-Performance Appliance for SAP HANA uses SUSE Linux Enterprise Server for SAP Applications. SUSE Linux Enterprise Server for SAP Applications — is a fine-tuned and supported operating system based on fully open source technology towards the nature of SAP application’s workload and its system lifecycle. The scale-up configurations of NEC High-Performance Appliance for SAP HANA leverage Virident FlashMax to implement Log volume backup which is a key component to achieving smooth collaboration with existing database tools. including its priority support.SAP HANA T-Shirt sizes offered Support Infrastructure Virident FlashMax — is a Storage Class Memory (SCM) solution that offers enterprises unconditional performance combined with the industry’s highest storage capacity in the smallest footprint. Its priority support provides unlimited 24hx7d technical support from SUSE. and its extended support offers additional 18 months for package maintenance. even when the device is full or nearly full. which enables administrators to identify issues quickly if and when something should happen. Additional software supported NEC ESMPRO/ServerManager — is server management software that provides administrators a centralized view to manage or monitor distributed multiple nodes. such as SAP HANA. . across all application workloads. It leverages EXPRESSSCOPE® Engine SP2 of Express5800 servers and ESMPRO/ServerAgent installed on the system. only packages that affect SAP system shall be upgraded. Through the long-standing partnership with SUSE. and has contributed various kind of open source community including Linux kernel development. It also maximizes system uptime with highly-selected package-updates. FlashMAX has been designed from the ground up to fully exploit modern computer architectures. Support Service For more information. . and NEC has experience supporting more than 500 installations with help of our sales. please contact NEC sales representative in your region. support and consulting organizations.Support and Additional Services Through the longstanding partnership with SAP and SUSE. which is the front-end tool for visualization and analytics for SAP HANA. NEC was one of the first distributors of SAP BusinessObjects™ Business Intelligence (BI) solutions in Japan market. NEC will offer mission-critical grade support service from hardware to applications. In addition. NEC has established an evaluation team of SAP HANA to make the latest technology commercially available as soon as possible. for the global market. ” — Winston Churchill Introduction So. powered by SAP HANA. organizational barriers. and managing a robust architecture complete with system landscapes and solutions. Although the specific questions will vary by engagement. and return-on-investment concerns — highlight the need for a service provider who is highly experienced with in-memory technologies. that partner must ask the critical questions that mean the difference between success and failure — and be able to answer these questions correctly. and how it can serve as a basis for growth and innovation in the future. a leading Indian consumer products company. a good implementation partner should help you develop a comprehensive roadmap detailing how in-memory computing can help your company run at maximum speed and solve specific business problems. you’ve decided to move forward with SAP HANA. and development services are available that can help ensure that you get the maximum business value from SAP HANA. you should start by identifying the right . Selecting the Right SAP HANA Service Partner It’s important to choose a partner who can help you be successful with SAP HANA. First and foremost. Usha International: http://youtu.Chapter 11 SAP HANA Projects and Implementation “He who fails to plan is planning to fail. and development. The right partner should also provide you with access to experienced. deployment.be/B3TRsEpwI0 It All Starts with Good Planning The more attention you devote to planning your implementation. certified experts in areas such as architecture. the more you will benefit from your SAP HANA investment. Great! But how do you get started? SAP HANA is a new technology. Fortunately. A recent IDC report found that four of the top six impediments to implementing in-memory technologies — lack of skills. whatever your situation. expert project planning. you’ll need to think about how SAP HANA fits into your overall IT strategy now. as quickly as possible. delivering real-time analytics and business processes. so your organization may lack the in-house expertise to implement it on their own. to improve supply chain productivity and provide real-time insight to respond quickly to consumer demands. implementation. utilized SAP Netweaver Business Warehouse. and use SAP HANA to create value across the organization — harnessing the power of big data.9 Such a partner should be able to help your company plan. risk. To accomplish these goals. Listen to how USHA International. Throughout the implementation process. deploy. with the help of SAP Services. extend existing solutions. Want to get the most from your SAP HANA platform? The SAP Education organization offers courses and certifications to give technical consultants and internal IT staff the knowledge and skills they need to fully leverage the power of SAP HANA. one who understands your unique issues and has a track record for delivering custom solutions that successfully address their clients’ needs. content. For many projects. you need to make certain that your business users know the full extent of what is now possible and how to best adapt for your environment. At SAP. can accelerate deployment while limiting costs. such as SAP Rapid Deployment solutions. Ask yourself: How can we realize the solution in the shortest time with the least risk? Does either SAP or its implementation partners offer any predefined services or application solutions that can help? What does the high-level project plan look like. The best technology in the world will not necessarily create value if it isn’t aligned with the proper business scenario.com/us/en/curriculum/hana-g-en Service Provider Selection Checklist . it’s especially important that you select a partner with deep knowledge and skilled resources. Proper risk assessment is also crucial. Rapid Implementation — But How? Once you’ve documented and received signoff on the planning phase. you need to manage large amounts of data. we often distinguish between business intelligence and technology intelligence. The goal: an efficient. whether internal or external (or both). How Will We Ever Get up to Speed on This New Technology? It is imperative for you to learn as much as possible about SAP HANA in order to fully reap the benefits of this new technology. What about Highly Complex Projects? If your business problem is really complex — for example. To accomplish these tasks.sap. and how well does it align with our business requirements and expectations? What personnel do we need to ensure successful planning and delivery? Everyone Wants a Low-Cost. In addition to educating your technical and IT staff. work with highly-customized systems. and end user enablement that together can radically accelerate time to value — delivering benefits in weeks rather than months. Your solution partner should be able to offer a wide range of solution scenarios including end-toend project implementation experience coupled with a holistic delivery methodology.business use case for SAP HANA in your company. lowcost implementation that mitigates risk to both business and IT. implementation services. the first question to consider is: Where can an in-memory solution create the most value for the least investment in the shortest timeframe. If you choose this option. prepackaged fixed-price offerings based on globally compiled best practices. it’s time to identify the expertise and skill sets you need. with the least disruption for business users? The answer to that question will help you align desires (what you want) and needs (what you actually need). or build new solutions specific to your needs — you may want to consider specialized services. For more information visit the SAP Learning and Software Services for HANA website: https://training. Thus. Such solutions include preconfigured software. you should select a service provider that offers skillstransfer opportunities. At that point you can begin mapping the solution back to a technical landscape. These use cases are: Agile data marts SAP Business Suite accelerator Primary database for SAP NetWeaver Business Warehouse Custom application development Learn how the experts from SAP can assist you with all aspects of your SAP HANA Project with their end-to-end services. SAP HANA can also complement existing landscapes and replace outdated solutions. we’ll review four typical use cases for SAP HANA deployments today.html#/page/1 For More information. We’ve just discussed the importance of selecting a qualified solution implementation partner. It can add value to a wide range of business scenarios. The next step is to determine how best to use SAP HANA within your current environment to deliver maximum value in your organization. SAP HANA Use Cases We’ve reviewed many of the key factors that you need to consider when you select an SAP HANA implementation partner. and it can be deployed in myriad ways to meet your project expectations and technical requirements.be/TE0ZDgckXYQ. please visit the SAP HANA Services website: Agile Data Mart One way to quickly get the most value from in-memory technology is to use SAP HANA as a .sap.com/community/ebook/2012_05_HANA_Services/en/index. Now we’ll turn our attention to how best to use this powerful new technology to generate the most business value for this investment. With that versatility in mind. They can help you to: Design and plan your roadmap or solution Implement and migrate SAP HANA into your environment Innovate and develop new and exciting solutions to your unique business issues Support the technical and business environment and educate your technical and end users Link: http://www. SAP HANA is incredibly versatile. on time and within budget ____ Ensure skill transfer to in-house stakeholders ____ Execute installation so as to reduce risk To learn more about ARI’s SAP HANA implementation project. as well as some of the potential scenarios for the future.The right service provider for your project should be able to: ____ Ensure appropriate due diligence during planning ____ Build a bridge between business and technology ____ Contribute the necessary resources and skill sets ____ Validate the value attained from your investment ____ Ensure that your SAP HANA installation fits well into your overall IT landscape and architecture ____ Identify additional business benefits that might be gained with a SAP HANA installation ____ Execute completely on the selected strategy. click here: ARI: http://youtu. However. SAP HANA acts as a central hub. though it is not used as the primary database under the application. These reports consist of three preconfigured reporting dashboards and 23 reports from the following business areas: Financial reporting Sales reporting Purchasing reporting Shipping reporting Master data reporting These dashboards and reports leverage existing reporting capabilities from SAP ERP. Such projects are usually completed quickly: The business problem is understood. and the required data and source systems are easily identified. a typical budgeting or planning transaction in SAP must collect data from many different tables in the system. Such installations offer instant value — making previously difficult and time-consuming tasks fast and easy. they offload the physical processing of the reports to a dedicated SAP HANA system that sits beside the live SAP ERP system. Let’s review the key elements of each bundle. side by side with the database under the SAP Business Suite applications. which is then used to generate the reports and display them to users in a variety of user interfaces. Accelerated Sales & Distribution Reporting The SAP HANA business content for Sales and Distribution (SD) enables sales managers and sales representatives to check basic key figures for sales in real time. SAP HANA is set up as a standalone system. This arrangement has the advantage of providing a focused solution to an immediate business problem while minimizing disruption to the existing landscape. however. certain transactions or reports inside the SAP Business Suite can run slowly. Reports can also be very data-intensive. As with the agile data mart scenario. and then display the results to users. To overcome system latency that slows down these common reports. Whereas sales managers use sales analytics to access instant overview information regarding the various performance indicators for their sales teams. requiring extensive data from many tables dispersed throughout the database.standalone data mart for a specific use case. the sales representatives focus on detailed information relating to the results of their sales activities. primarily due to the slow I/O of the underlying disk-based database and the huge data requests required by these transactions or reports. load it into a buffer table in the SAP application server. In both of these cases. SAP Business Suite Accelerator SAP HANA is frequently used to accelerate transactions and reports inside the SAP Business Suite. As we explained previous chapters. SAP has developed “HANAfied” versions of several existing reports. In this scenario. The data can then be used in multiple ways. To run its calculations and present a result. In this scenario. All relevant tables for each dashboard or report are physically copied from the SAP ERP system onto the SAP HANA system. collecting source-system data from multiple sources via in-memory technology and then displaying focused reports and analytics via a reporting front end. . depending on the organization’s reporting requirements and formats. SAP HANA is used to “offload” some transactions or reports that typically take hours or days to run. the application must request the data from the database. run the algorithm or calculation. Accelerated Financial Reporting The SAP HANA Financials content package provides the prerequisites for building reports that provide the following analysis data: Real-time analysis of the subledger for Accounts Payable (FI-AP) and Accounts Receivable (FI-AR) Flexible analysis of customer and vendor items based on the single line items from the back-end ERP system Calculation and analysis of the days sales outstanding (DSO) Note that currently only General Ledger Accounting (new) is supported. . SAP HANA can reduce a report’s run time from several hours to minutes or even seconds. many reports could not provide real-time data analysis — and therefore could not be used to make proactive business decisions. SAP BW is the first SAP application that was optimized to run with SAP HANA as its primary underlying database. In addition. Procurement managers use spending key figures along different dimensions including Material Groups. the managers can get an up-to-date overview on materials stock at any time. The master data in this package concentrate on master data objects that are available in SAP ERP. Accelerated Master Data Reporting Master data are essential for nearly all business transactions. such as material. Accelerated Shipping Reporting The SAP HANA content for Shipping enables shipping and warehouse managers to check basic shipping and stock key figures in real time. SAP BW can leverage in-memory capabilities for improved . irrespective of the business area. The IT team can perform a standard DB migration over to SAP HANA and then enable specific objects to be inmemory optimized as necessary depending on the company’s requirements. With SAP HANA. Primary Database for SAP NetWeaver Business Warehouse In our third use case example. Vendors.Accelerated Procurement Reporting The purchasing content package for SAP HANA enables procurement managers to analyze key procurement processes in real time. Managers use shipping analytics to obtain instant information for planning and monitoring outbound delivery-related activities. and Purchasing Organizations to gain instant insight into inefficiencies that may point to savings potentials or internal and external process improvements. Plants. one that’s been an ongoing problem for users. In this scenario a company replaces the previously underlying database for their SAP BW system with SAP HANA. customer. As a result of system latency. and vendor. making the information much more current and valuable. SAP BW is powered by SAP HANA. SAP HANA Accelerates Reports Imagine a “long-running” ABAP report within a particular business function. the sky truly is the limit when it comes to imagining what to build with SAP HANA. SAP HANA is a great choice. SAP HANA Implementation Scenarios . By now you should have a good understanding of how typical use cases take advantage of SAP HANA. do-just-about-anything-you-want application platform. It speaks pure SQL. click here: Home Trust: http://youtu. This arrangement simplifies the data modeling and query design. needs detailed/granular data analysis. without the need for any sidecar accelerators or extensive modeling workarounds. you can expect to see nearly every SAP product supported natively on SAP HANA as a primary database — plus many more “native SAP HANA” applications.performance. or suffers from latency between transactional recording and reporting. it “shines” particularly well in a few unique situations. needs to search or aggregate huge data volumes. In fact. SAP HANA is a full-blown. requires complex algorithmic or statistical calculations. To watch a video of Home Trust’s BW migration project. The next step is to ensure that you understand the best ways to deploy this new technology in your environment to drive maximum value. First. eliminating the need for in-memory aggregation. Although SAP HANA is valuable for a broad range of applications. so you can literally write any type of application you want on top of it. If you’re building an enterprise-scale application for a business scenario that has high data volumes. The entire database physically sits under the SAP BW system.be/Q6057Cpr8V4 Custom Applications for SAP HANA As stated earlier. from both a user and an administrator perspective. running SAP BW on SAP HANA eliminates most of the problematic issues that slow down the system. however. There are a few rules and “guide rails” that are designed to keep things from going wrong. which in turn greatly enhances system performance while lowering IT ownership costs. and it includes all of the most common APIs. Overall. Future Use Case Scenarios As SAP HANA matures and SAP updates its portfolio of solutions to take advantage of the extensive horsepower of SAP HANA. thereby reducing latency. keeping the entire database in memory eliminates the need to send large amounts of data between the application and DB servers. Replacing an old database with SAP HANA generates speed and flexibility for two key reasons. technical content. reacting more quickly to events. for each use case. there isn’t a one-to-one correlation between a use case and an implementation scenario. if your business issue is a more common or typical one.com/solutions/rds. and it stands to reason that there are also many different implementation scenarios. there are many different ways to use SAP HANA. If. SAP Application Deployment SAP is delivering a new class of solutions on top of the SAP HANA platform — solutions that combine real-time insights into big data with state-of-the-art analysis. SAP has created packaged solutions such as SAP Rapid Deployment solutions or accelerators. or suffer from latency between transactional recording and reporting? If you answered yes to any of these questions. In contrast. and implementation services. data-driven business models and processes — options that would be difficult or even impossible with disk-based databases. powered by SAP HANA SAP BusinessObjects Sales Analysis for Retail. and end user enablement plus implementation services. Custom Development Although there are standard best practices that must be considered when developing custom solutions. there are also many possibilities when it comes to imagining what to build with SAP HANA. . Clearly priced and scoped implementation services help you speed up time to value and limit risk. then SAP may have already created a new SAP HANA application to meet your needs. which will typically dictate the most appropriate implementation scenario. Companies can utilize these solutions to take advantage of new. These solutions contain preconfigured software. visit: www. your use case is for a specific need not addressed by an SAP application. For many repeatable business issues. These innovative real-time solutions can help organizations transform their business by making smarter and faster decisions. Rather. powered by SAP HANA Packaged Solutions Do you have to address an urgent business need? Do you prefer working with a fixed scope? SAP Rapid Deployment solutions can help you implement SAP HANA using a package of preconfigured software. and they are priced and scoped for rapid implementation.sap. you need to look at the business problem you are trying to solve.As we’ve discussed. then SAP HANA is a great choice. you’ll likely need a custom development project. SAP HANA aligns well with several specific requirements and situations. Are you building an enterprise-scale application for a business scenario with high data volumes? Do you need detailed or granular data analysis? Do you have to query large data volumes? Do you require complex algorithmic or statistical calculations. for example. However. powered by SAP HANA SAP Smart Meter Analytics. content. These solutions include: SAP Sales Pipeline Analysis. Examples are: SAP ERP Rapid Deployment solution for accelerated finance and controlling with SAP HANA SAP ERP rapid-deployment solution for profitability analysis with SAP HANA SAP Rapid Deployment solution for customer segmentation with SAP HANA SAP is continuously adding more Rapid Deployment solutions. To see what’s available today. and unlocking new opportunities. with new use cases being created almost daily. Both the project team and the executive sponsors must be educated so they understand what SAP HANA can do and how it works. The SAP HANA solution must be designed and documented so that if your . Customer education.Now that we’ve reviewed typical implementation scenarios. The amount of emphasis you place on each step will be dictated by the type of SAP HANA project you are implementing. you must follow a structured implementation methodology. and where might the company make improvements? Where could the technology have the biggest impact on corporate objectives or unlock deeper insights into the reported data? Once you have defined a use case. including guidebooks and accelerators to support team members and increase project predictability. deliverable-oriented implementation plan based in project and organizational change management. Your solution partner should approach the solution with a phased. you should perform a comprehensive requirements gathering to ensure that the end solution addresses all of your company’s needs and maps back to your original use case expectations. let’s review what a successful implementation requires. Workshops can help determine where to apply the power of SAP HANA within the organization. (Hint: Give them a copy of this book!) 2. The technology is also rapidly evolving. minimize risk. tools. questionnaires. the capabilities. and best practices for implementation. The goals here: to streamline implementation. Education is especially important for an SAP HANA project. 3. Taking a Systematic Approach for Your Implementation You may be familiar with the traditional ASAP methodology used by SAP — and the fact that a complex ERP implementation can last for months. to stay on top of its learning curve you need to work with a solution implementation partner who has a deep understanding of the technology. and reduce the total costs of implementation. To successfully implement SAP HANA. Ask yourself: What are the possible scenarios for SAP HANA. A robust methodology should include templates. The technology is new. and checklists. Use case identification. Solution approach. so the relevant knowledge is not yet widespread. There are six basic steps that need to be a part of any SAP HANA implementation. Because SAP HANA is a new technology. 1. if not years. the customer may have to consider prerequisites for delivering in-memory solutions. Depending on the current landscape. These models are adapted. 6. QA/testing. modified. Quality assurance continues. Reviewing the original form of a current report can be very helpful because you can see what the business user is accustomed to seeing. map the sources from which the data are drawn. and performance. this will be an iterative process. After you’ve outlined a systematic approach to implementation. timelines. a change to a field may require changing a data model. For packaged applications this content is delivered by SAP. but can be adapted to your specific needs. such as the SAP ASAP implementation methodology. even small changes to a report can have a large impact on underlying systems. The production system is up and running. each has distinctive contributing factors and characteristics. and implementation tools have also been updated or developed to shorten the project timeline and reduce risk. data quality may need to be addressed. 4. or the organization may first need to upgrade some applications that work in conjunction with SAP HANA. it is important to fully define requirements and to ask about any proposed report modifications. and deliverables that are necessary for success. as a result of dependencies. data quality. they may want to introduce additional functionality. Each project is different. As customers learn more about the capabilities of in-memory solutions. . You should also perform a proper data decomposition to document how the current report is built and how it is working. Finally. SAP HANA is delivered as a production solution. Custom development projects will include both traditional application development and modeling aspects. data integration. Most likely. This is the final test of all front-end reporting. In addition. the solution approach will evolve into a comprehensive deliverable. Methodology. to ensure that a project addresses all of the critical activities. Often. Go live. As new information becomes available. Modeling / Development A key task to implement your SAP HANA solution is creation of the data models and the different views to it. as well as how it might be improved. and how the data are imported into a formal deliverable for signoff. Accelerators. Timelines and Key Activity Considerations Just as there is no one size fits all. For example. you need to identify the key timelines and activities for your SAP HANA implementation.personnel or solution partners change. It is important to manage this need and to consider it during the initial requirements phase. phases. and enhanced to improve performance. It is SAP best practice to use a standard project methodology. Expectations for in-memory functionality. The right services partner can provide the needed level of due diligence in this area during planning. then expectations must be managed. and business processes begin to operate in the new SAP HANA environment. Common Scoping Pitfalls to Avoid If changes are required for front-end reports or analytics. there is no single timeline for an SAP HANA project. 5. the new resources will understand how to support the solution. identify any custom code within the business rules that may be difficult to replicate inside the SAP HANA modeler. looking closely at use cases and their supporting infrastructure. best practices. and key activities vary based on three considerations: Current technical landscape. Because of this factor. for instance. The SAP ASAP methodology has been updated to incorporate the SAP HANA activities required for a standard in-memory project. along with end-user training and support. audit. He or she gathers requirements for the use case(s) and creates the technical design documentation. memory. and also monitors and processes backup log files. This expert on SAP HANA technology collaborates with the project manager to plan technical requirements for the project. and project review. The following roles are specific to agile data mart use case implementations: System architect/system administrator. as identified in the original use case scenario. Business Function Library. which includes steps contained in moving from development to production. or which use case you select. Critical SAP HANA Skills Needed for Successful Projects Because SAP HANA is a new technology the success of any implementation will depend in large part on your ability to locate experts who can fill any skill gaps on your team. design. and disk usage. . and load data into SAP HANA via data services or SLT. Certified OS/DB migration consultant. and manages the SAP Landscape Transformation (SLT) replication server. transform. including CPU. Finally. SAP HANA data modeler. As the name implies.). The SAP HANA data modeler is responsible primarily for modeling solution design and development and unit testing of all SAP HANA models. you’ll need to identify the key skills required to ensure your implementation of SAP HANA is a success. This expert builds your applications beyond pure data modeling using the different development capabilities of SAP HANA (SQLScript. SAP technology consultant. Solution architect. The system architect also performs SAP source system configuration and replication. along with configuration and application of any necessary patches. In addition to defining an implementation methodology. He or she performs maintenance and system monitoring.Original requirements per use case(s) identified during assessment. project organization. he or she ensures that the SAP HANA database is backed up regularly. A key component of the successful delivery of SAP HANA is ensuring that the final solution meets the company’s requirements and expectations. Two other roles are specific to implementations of SAP BW powered by SAP HANA. the solution architect is responsible for solution design. including database planning. you will need additional development skills: SAP HANA developer. He or she then implements these required technical tasks within the system. etc. The developer also performs lifecycle management. Data services/SLT developer. The data services developer is responsible primarily for design and development of jobs to extract. which includes the various steps contained in the process of moving from development to production. This individual is responsible for technical planning and design of the in-memory infrastructure. If you perform a custom development. He or she also performs SAP HANA model lifecycle management. Critical resources for an SAP HANA project will also vary depending on how you choose to leverage the SAP HANA inmemory solution. This resource is responsible for the physical SAP HANA landscape. Custom SAP HANA Application in Use at a University Hospital With a mature analytics program in place. the biggest university hospital in Europe provides 150. and diagnoses. and study results and make a positive impact on patient care and healthcare research. a financial services company used SAP HANA as a primary database for SAP Business Warehouse. The second example involves a large university hospital that successfully implemented SAP HANA as the engine of a new custom application. Data query speeds have increased on average 8-12 times. with impressive results. This information enables the hospital to quickly identify the best candidates for each clinical study. age.000 data points per patient in real time. gender. the hospital now uses SAP HANA Oncolyzer to search for and examine information involving cancer patients. powered by SAP HANA. scripting languages. treatments.” The first example is a chemicals company that was able to improve compliance reporting by accelerating its standard SAP system. Let’s conclude this discussion by examining some truly stellar examples of successful SAP HANA implementations. and performance of SAP HANA. This vastly improved performance enhances their scientists’ productivity while simultaneously driving down the costs of new product development. With the right service provider.000 inpatient and 600. medical records. you’ll be able to enjoy the power.Depending on the specific scope and architecture of your project. migrating a half-terabyte of data from a competitive database to the SAP HANA database and upgrading to SAP NetWeaver Business Warehouse. when DNA is added to the data set. The hospital invested in SAP HANA to harness the big data associated with its vast inventory of patient data. Using SAP HANA to augment support of existing processes. the Oncolyzer will analyze up to 500. Finally. To resolve this problem. speed. the company simply became unable to scale its compliance checking. risk factors. Putting it All Together — Examples of Stellar Projects Now that we have discussed the SAP HANA technology and how to obtain the best business value from this technology. SAP Business Suite Accelerator at a Chemicals Company Our first example is a European consumer chemicals company that specializes in developing new fragrances and flavors. For example. Primary Database for SAP Business Warehouse in Use at a Financial Institution A leading North American mortgage lender has successfully completed proof of concept. simple queries run up to 450 times faster. As the demand for these chemicals increased and their recipes became more complex. use case. the company collaborated with SAP to build an application that enables it to quickly check new recipes while they are still in development to ensure that they comply with a vast array of local legal regulations. . Implementing SAP HANA is a major step in dramatically improving your ability to obtain optimal value from your big data. etc. you may need development experts in the specific application domain and advanced technologies. such as predictive analytics. such as tumor types. we have demonstrated how the new application can cut processing time from 20 minutes to less than 4 seconds. enabling it to dramatically increase the speed with which it analyzed medical records. Every one of its hundreds of new recipes — each with unique ingredients and compositions — must be checked for compliance with legal regulations.000 outpatient treatments every year. implementation methodology. and skilled resources. SAP HANA analyzes both structured and unstructured data and greatly accelerates the identification process. The result has been a dramatic improvement in reporting runtimes in the data warehouse and business intelligence environments. In the future. we will present some innovative ways that customers have “put it all together. solution approach. Final Words of Wisdom on SAP HANA Implementation We’ve reviewed the importance of selecting the right SAP HANA services partner — one who can help you plan and implement your solution and provide the right set of skill resources to ensure your implementation delivers on the value of SAP HANA. . The key is planning and ensuring you understand the entire scope of the implementation. Build them into the project/solution to ensure that success can be properly measured and quantified.). 7. modeling. Make sure that data quality is considered as part of overall SAP HANA solution planning. Ensure proper collaboration across application delivery teams (EPR. Define (or redefine) specific in-memory terminology with all users to make certain that each term is understood by — and means the same thing to — IT. reporting. It really helps get everyone “on the same page” and ensures you’re all speaking the same language.and data store object activation is 19 times faster. Remember. Make certain that business requirements are completely understood and that the use case complements the technical requirements. Small clarifications on such terms as “real-time” and “self-serve” can go a long way toward preventing misunderstandings concerning both the functionality to be delivered and the value it brings. primary database for SAP Business Warehouse. and go-live best practices. We’ve also reviewed common use cases. including the agile data mart. and skilled resources needed to implement SAP HANA. etc. 3. and executive sponsors. while remaining flexible enough to leverage the latest in SAP HANA use cases. you’ll also need to identify your timeline. Based on these impressive results. the customer is re-architecting its entire reporting environment to leverage the power of SAP HANA. 4. use case identification. subscribe to SAPServices on Twitter band review the details on the SAP HANA services website. Next we reviewed the importance of taking a systematic approach to your implementation and the benefits of following a methodology built on education. Establish ROI metrics early in the scoping process. In conclusion. developers. 5. technology intelligence doesn’t necessarily equal business intelligence! 2. depending on project requirements. For more information about SAP HANA services offerings. SAP HANA implementation scenarios can vary depending on your business need — from custom development to SAP application development to rapid deployment solutions. Prior to implementation. 6. Start with a focused use case to demonstrate business value. Establishing a quick win helps with sponsorship and funding for additional in-memory projects. BW. and custom SAP HANA applications. and then expand across other functional areas of the business. Acquiring data quickly can’t help the business if the data are not accurate. Bonus Advice: Encourage everyone involved with the project (Technical & Business) to download and read a copy of this book. we’d like to leave you with a short list of six key takeaways to ensure a successful SAP HANA implementation: 1. SAP Business Suite accelerator. CRM. business users. QA and testing. key activities. All SAP Mentors are hands-on experts of an SAP product or service. They provide their best tips and tricks for a successful SAP HANA project. Pay attention. as well as true project champions. The majority of SAP Mentors work for customers or partners of SAP. The following three SAP Mentors are experts in SAP HANA implementations. these guys really know their stuff! . They comprise a super-smart and engaged global cohort of nearly 110 bloggers.Top Advice from SAP Mentors for SAP HANA Projects SAP Mentors are the most influential community participants in the SAP ecosystem. consultants. and technical wizards nominated by SAP Community Network peers and selected by SAP. 7. Find the best data modeler you can for your SAP HANA projects. Last but not least — poor data quality is even more damaging when the data come at you in “lightning speed. Do not jump into a POC (Proof-of-Concept) just to prove loading/ reporting works faster in a data mart. and a good design is needed to make it work for all your use cases consistently.Vijay Vijayasankar Associate Partner IBM Global Business Services Twitter: @vijayasankarv 1. they will require some lead time to acquire. Check SAP HANA performance under a variety of situations — reporting performance while heavy loads happen. 2. That is the make-or-break issue for most SAP HANA projects. then you will not see the expected results. . This helps reduce wasteful scoping efforts during the project. Engage closely with your SI (system integrator) and SAP while the project is going on. If you do not. and fix them at the source or as close to the source as possible before sending them to SAP HANA.” 8. 10. Consequently. logging on from different parts of network. 3. while multiple people are working on system. and they can advise you and help minimize time spent “reinventing the wheel. Make sure you understand that before investing in HW. 9. Even if you want to scale out and buy new boxes. 4. Size the hardware correctly. An important part of this step is to accurately define success up front. Your SI and SAP will probably have seen your issues before. SAP HANA security/administration is a specialized skill. etc. SAP or IBM can easily show you how quickly their systems can report and load data. SAP HANA is fairly new. Plan to spend time refining the model. Each HW vendor has some “secret sauce” on what makes them special for SAP HANA. If you are going to migrate to SAP NetWeaver Business Warehouse on SAP HANA. 5. test as you go when migrating objects to their in-memory versions so that you can spot challenges sooner. you should be aware that these boxes are not available off the shelf. and it will probably need a few workarounds. Definitely consider re-engineering the design of SAP BW to take advantage of SAP HANA and avoid doing only an en-masse migration and leaving it at that. Profile the data. 6. Spend a lot of time refining your use case offline before you start the project. and it will help the project team focus on specific targets.” Garbage In/Garbage Out still applies. Team composition is key for successful implementations. and ask different questions to uncover anomalies in your data. Define what you really want. achieve success. c. quickly run scenarios. Pilot early a. Establish priorities a. Don’t try to throw all the data into the database just because you can. Focus your efforts. and don’t forget basic due diligence. d. be simplified. 2. 6. b. Begin cultivating talent a. Move from theory to reality — real-time BI delivers true value. 4. Don’t forget about change management. b. Embed statistical models and predictive analysis into your daily operations to detect risk. Eliminate the data volume and speed barriers from the equation. losses. or negative exposure. . Revisit your data quality initiatives using SAP HANA to quickly identify issues that result from processing massive data sets in one pass. Don’t underestimate the importance of data quality. Don’t forget to look at unstructured data in your organization. though. Be proactive to influence the product development. Make it dynamic to adapt quickly to new capabilities and integration options. Processes can now actually change. these data can provide a new perspective. c. and focus on the real business needs. Incorporating unstructured data and rapid processing enables meaningful and timely analysis to minimize risk. c. and make certain your objectives have a positive impact on your organization b. c. Rethink what is possible a. Get used to rapid development cycles and capabilities. Start with the hard stuff a. Correlation of results without complex partitioning and staging areas can uncover skewed results. and anomalies. negative trending. or be minimized because you don’t need as big a staff to conduct the analysis. c. and build on that success iteratively. Focus on changes for end users because they can be empowered to do agile reporting as well as on changes for administrative staff due to technology and implementation tools. 3. This allows you to change your assumptions. Be realistic — don’t assume you go through fewer cycles of data analysis to find the best answer (or question). Revisit analytics that previously were not possible or were too difficult to perform. b. Make sure there is a measureable ROI 5. b. define what is really important. Align business and IT goals. and make your voice heard to ensure timely delivery of new capabilities. b. Don’t get caught up in all the hype and excitement — be pragmatic. you will be able to do the cycles faster.Harald Reiter Senior Manager — SAP Deloitte Consulting Twitter: @hreiter 1. Develop a roadmap a. move up one T-shirt size. Scale-out capability mitigates the risk of not sizing correctly. . Revisit your technology architecture a. Identify your must-have requirements. Reveal bad data model designs. Size right a. Data composition and data source impact the compression rate and thus the sizing estimation. Examine your overall landscape. Continuous monitoring of key metrics is a reality using mobility and SAP HANA 8. c. c. d. and address any shortcomings. c. 9. Tuning and performance testing can make the fast even faster. Identify the best tool for each job. Understand the database operations capabilities of SAP HANA. Don’t forget about SLAs (service-level agreements). Incorporate mobility a.c. but it should not be relied on. b. Resources can now be assigned real value-added tasks instead of time-consuming administrative tasks just to obtain basic information. and identify all areas that can benefit from technology modernization. e. One size does not fit all b. Establish metrics and plan for tuning and performance testing a. 10. d. b. The quality of the data model impacts the available size for data versus workspace. 7. When in doubt. you are already on the right track. 2. and cheaper. 5. Understand the technology a. Your solution will live a long time after the go-live date and will need to accomodate new requirements. “The devil is in the details. Question your old habits. Build for the long run. but always consider them in the context of the big picture a. Open your mind to the “New World” a. project team. unexpected cases. partners. Think about details. Technology makes things faster. better. 4. At the same time. but technology itself is still just a tool. forget about your “15 years of technical/project experience under the belt.Vitaliy Rudnytskiy Lead BI Architect HP Enterprise Information Solutions Twitter: @Sygyzmundovych 1. never lose sight of the complete picture of where all the details fit into. 3. If you are reading this book. Accept nothing less than excellence from your project team and partners a. however.” so think them through. Don’t build the solutions for “Go Live” a. . Make sure you assemble an excellent team: business.” Old techniques do not necessarily work well or at all with new paradigms. and SAP support. and a surrounding environment that is in constant transition. make certain they are involved in all follow-on endeavors. Instead. For example. Apply metrics to these savings. To enable customers to take advantage of this new functionality quickly and efficiently. It is also a new database technology – one that is evolving as SAP customers find new ways to challenge the speed and performance of the database. To secure and maintain this sponsorship. Invest in hardware that can be scaled instead of being replaced. Executive sponsorship helps drive the vision for SAP HANA in your organization. IT. SAP has made the process of upgrading very simple.com/community/services/blog/2012/08/23/thevalue-in-value-management Cutting-edge Technology SAP HANA represents a paradigm shift in how we know and use an RDBMS. If you don’t identify.sap. Ultimately they will enable your business to report more quickly and efficiently. The well-known adage “You can’t manage what you can’t measure” is especially relevant to value management. include the executives in project reviews at regular intervals to keep them up to date on project status. and memory. Although switching the database underneath BW is part of the formula for success with SAP HANA. Adopt realistic goals on sharing an SAP HANA appliance between applications. Learn more about how strategy management helps you track and realize the full value of your organizational objectives by reading this article: http://scn. Examine solutions like near-line storage (NLS) that may help mitigate rapid data growth in SAP HANA. resources. Such activities will help you save not only on the maintenance of these objects. Also. analyze ways to reduce redundant data before loading/migrating into SAP HANA. Too often. track. Executive Sponsorship Buy-in at the highest level brings the authority and credibility that can mean the difference between success and failure for your SAP HANA project. or infrastructure savings. and ensure the ongoing value of a project.Ranjeet Panicker Practice Manager SAP Next Generation Services HANA/In-Memory Center of Excellence Total Cost of Ownership (TCO) & Return on Investment (ROI) Analysis Do not limit analysis of TCO and ROI to technical. Engage SAP Value Engineering teams who can help translate the speed of SAP HANA into true business value. but also on storage. look into items such as backup and . Avoid this mistake! Be bold! Explore the holistic value of SAP HANA to your business processes. you’re unlikely to achieve its financial and operational objectives. The SAP HANA platform is evolving very quickly. and it facilitates the change management that is required when you adopt a new technology. and SAP continuously adds new and innovative functionality. Finally. reducing the time it takes to run a BW analytic report from 4 hours to 5 minutes means something to the business. Size Does Matter Do not rely purely on the size of the data set on source systems to predict the size of the SAP HANA appliance. when customers generate a business case to justify the acquisition of SAP HANA. they apply only those savings related to infrastructure items such as storage and hardware. HANA Should Not Be Only an IT Project Recognize the business drivers which catalyzed the decision to make SAP HANA the platform for your business. the full value of a BW powered by SAP HANA solution is realized through additional activities such as optimizing in-memory objects and examining processes to re-architect the information layers. March 2012.restore. and performance when you are considering sharing a single appliance. patching. Help Rethinking the Art of the Possible with SAP HANA Services. . IDC. 9 Gard Little and Elaina Stergiades. Chapter 12 SAP HANA Resources COMING FALL 2013 . . Please share the website and voucher code with your colleagues so they can benefit from the information in this book as well. it will be continuously updated as new chapters are completed and content revisions are added. Make sure to register for the mailing list on www.The rest of the story….com to be informed when new chapters are available and follow the book on twitter @EpistemyPress and @jeff_word. Since the SAP HANA Essentials book is being written in “real time”.saphanabook. Word earned his PhD in Information Systems at Manchester Business School in England.D. he worked in the high tech industry for several hardware and software vendors throughout the Americas and Europe in a variety of leadership roles. Follow Jeff on : @jeff_word Jeffrey is responsible for creating and communicating thought leadership on SAP’s In-Memory database strategy globally. Jeffrey has more than 18 years experience in IT strategy and business consulting working with Fortune 1000 companies. Essentials of Business Processes and Information Systems (2009) . His research focus was on event-driven business process design and next-generation enterprise architecture. He also earned an MBA in International Management from the Thunderbird School of Global Management and a BA in European Studies/Spanish from the University of Oklahoma. He is also the co-author of the bestselling books. . Ph.About the Author Jeffrey Word. Prior to joining SAP. was released in early 2013. His newest book book. Dr. Over the last 13 years at SAP. Integrated Business Processes with ERP Systems (2011). Business Process Integration with SAP ERP. Business Network Transformation: Strategies to Reconfigure Your Business Relationships for Competitive Advantage (2009) and SAP NetWeaver for Dummies (2004). he has worked on technology strategy with focus on corporate innovation initiatives and enterprise architecture design.