§Foreword to the Third Edition ... 17§§Introduction ... 19§§Acknowledgments ... 21§§PART I What, Why, and When§§1 In-Memory Computing, Big Data, and SAP HANA ... 25§§1.1 Introduction to In-Memory Computing and Big Data ... 26§§1.2 Introduction to SAP HANA ... 34§§1.3 Introduction to Implementation Options ... 52§§1.4 Summary ... 55§§2 SAP HANA On-Premise Implementation Options ... 57§§2.1 SAP HANA as a Data Warehouse for Analytics ... 57§§2.2 SAP BW on SAP HANA ... 70§§2.3 SAP Business Suite on SAP HANA ... 85§§2.4 Choosing an SAP HANA Implementation Option ... 95§§2.5 Summary ... 99§§3 SAP HANA in the Cloud ... 103§§3.1 Cloud Basics ... 103§§3.2 SAP HANA Cloud Platform and SAP HANA Enterprise Cloud ... 105§§3.3 Choosing SAP HANA in the Cloud ... 109§§3.4 Summary ... 115§§4 Advanced Applications for SAP HANA ... 117§§4.1 SAP HANA Live ... 117§§4.2 SAP Predictive Analysis for SAP HANA ...120§§4.3 SAP Business Planning and Consolidation for SAP HANA ... 124§§4.4 SAP Simple Solutions ... 127§§4.5 Summary ... 128§§5 SAP HANA and Your Business Strategy ... 129§§5.1 Identifying Transformational Opportunities ... 131§§5.2 Understanding Your Needs ... 134§§5.3 Working with Existing Solutions: SAP HANA versus SAP BWA ... 140§§5.4 Writing a Business Case, Budgeting, and Staffing for§§SAP HANA ... 148§§5.5 Frequently Asked Questions about SAP HANA ... 160§§5.6 Summary ... 165§§PART II How§§6 Planning an SAP HANA Implementation ... 169§§6.1 Implementation-Independent Considerations ... 169§§6.2 SAP HANA as a Data Warehouse ... 182§§6.3 SAP Business Suite on SAP HANA ... 190§§6.4 SAP Business Warehouse on SAP HANA ... 203§§6.5 Summary ... 230§§7 SAP HANA and SAP Business Intelligence ... 233§§7.1 Overview of Tools ... 233§§7.2 Connecting SAP BusinessObjects BI Tools to SAP HANA ... 249§§7.3 Summary ... 263§§8 Developer Tools for SAP HANA ... 265§§8.1 UI Development Toolkit for HTML5 (SAPUI5) ... 265§§8.2 SAP HANA Extended Application Services (XS) ... 275§§8.3 SAP HANA Live ... 280§§8.4 SAP HANA Cloud Platform ... 282§§8.5 SAP River ... 288§§8.6 Summary ... 295§§9 Data Modeling with Information Composer ... 297§§9.1 Getting Started with Information Composer ... 299§§9.2 Uploading Data to SAP HANA ... 304§§9.3 Composing Information Views ... 315§§9.4 Viewing Uploaded Data and Composed Information Views ... 326§§9.5 Summary ... 329§§10 Data Modeling with SAP HANA Studio ... 331§§10.1 SAP HANA Studio Overview and Terminology ... 332§§10.2 Getting Started with SAP HANA Information Modeler ... 337§§10.3 Building Attribute Views ... 345§§10.4 Building Analytic Views ... 356§§10.5 Building Calculation Views Using the Graphical Method ... 364§§10.6 SQL and SQLScript ... 376§§10.7 Summary ... 389§§11 Advanced Concepts in SAP HANA Studio ... 391§§11.1 Data Mart Virtualization ... 391§§11.2 Derived Attribute Views ... 393§§11.3 Calculated Attributes ... 399§§11.4 Restricted and Calculated Measures ... 402§§11.5 Filter and Variable Operations ... 408§§11.6 Currency Conversion ... 422§§11.7 Hierarchies ... 427§§11.8 Personalizing Studio ... 435§§11.9 Summary ... 441§§12 Data Provisioning ... 443§§12.1 Choosing a Data Provisioning Method ... 444§§12.2 Trigger-Based Replication: SAP Landscape Transformation ... 456§§12.3 ETL-Based Replication: SAP Data Services ... 480§§12.4 Log-Based Replication: SAP (Sybase) Replication Server and Load Controller ... 505§§12.5 Direct Extractor Connection ... 509§§12.6 Summary ... 519§§13 SAP HANA Administration ... 521§§13.1 Using the SAP HANA Administration Console ... 522§§13.2 System Monitoring ... 532§§13.3 Updates ... 546§§13.4 Security ... 548§§13.5 License Keys ... 556§§13.6 Backup and High Availability ... 559§§13.7 SAP Solution Manager and SAP HANA ... 564§§13.8 DBA Cockpit for SAP HANA ... 565§§13.9 Summary ... 568§§The Autho