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 Authors ... 569
Index ... 571
