SAP HANA

Dr. Bjarne Berg is VP of ComeritLabs and has implemented in-memory solutions for SAP analytics in Europe and in the USA. In addition to his SAP HANA work at ComeritLabs, he has also collaborated with IBM at the Research Triangle Park in North Carolina with testing, development, and benchmarking SAP HANA on SAP BW solutions. In the past, he has implemented in-memory systems for Fortune 500 companies, and has managed over 50 SAP NetWeaver performance tuning engagements for large organizations. He is a frequent speaker at SAP conferences and also teaches in the SAP University Alliance. Penny Silvia is the SAP analytics and HANA leader for IBM's Global SAP iCoC. She has extensive experience in implementing advanced and in-memory analytic solutions for SAP customers. She works closely with clients to help them understand and develop SAP HANA roadmaps, strategies, and implementation plans, as well as identifying data and analytic needs that can benefit from an in-memory solution. She is a frequent speaker at SAP conferences and is on the Advisory Board for multiple SAP publications.

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