SAP HANA
An Introduction
4th Edition
Published on 2. March 2017
Book
Hardback
549 pages
978-1-4932-1407-5 (ISBN)
Description
What does SAP HANA mean for you? This book is your introduction to all the essentials: from implementation options to the basics of data modeling and administration. With cutting-edge coverage of Smart Data Access, Vora, and more, this best-seller has everything you need to take your first steps with SAP HANA.
SAP HANA as a Database
Explore your options! Find out how SAP HANA can be used as a database for SAP BW, SAP Business Suite, SAP S/4HANA, and more-and what this means for your landscape.
SAP HANA as an Application Platform
SAP HANA is a developer's playground. Learn what you can do with SAP HANA Extended Application Server Advanced (XSA) and SAP HANA Cloud Platform.
New Developments in Data Modeling and Provisioning
Make sure you're up to date! Understand all the core concepts and also get the latest information on calculation views, the SAP HANA Web IDE, and Smart Data Access.
Highlights:
In-memory computing
SAP Business Warehouse on SAP HANA (SAP BW on SAP HANA)
SAP Business Suite on SAP HANA
SAP HANA Cloud Platform
SAP S/4HANA
SAP BusinessObjects BI
SAP HANA Live
Data modeling
Data provisioning
Administration
SAP HANA Studio
More details
Other editions
Previous edition
Book
10/2014
3rd Edition
SAP PRESS
€69.95
Article exhausted; check for reprint
Persons
Author
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.
Rob Frye served in the NC Army National Guard for nearly two decades, and is a combat veteran of Operation Iraqi Freedom. After retiring from military service, he completed his Bachelor's degree in Computer Science from Lenoir-Rhyne University, where he was the First Honor Graduate with a 4.0 overall GPA. More recently, Rob has managed ComeritLabs, in Huntersville, NC, for the past 4 years. ComeritLabs provides infrastructure, remote development, and training services for COMERIT, Inc. Rob is an experienced SAP HANA and SAP BusinessObjects developer, and has created SAP HANA content, training material, and processes, as well as SAP BW on HANA InfoObjects for Fortune 500 companies. Rob was the lead author for The SAP BW to HANA Migration Handbook, one of the first books to provide comprehensive, step-by-step instructions for completing the DMO (database migration option) process. Rob has delivered training in SAP HANA and the BusinessObjects toolset in the United States, Canada, Mexico, and South Africa. Rob is also a PhD student at the University of North Carolina in Charlotte, where he is conducting research into recommender systems for artificial intelligence.
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.
Content
... Acknowledgments ... 15
... Introduction ... 17
1 ... In-Memory Computing, Big Data, and SAP HANA ... 19
1.1 ... Introduction to In-Memory Computing and Big Data ... 20
1.2 ... Column-Based versus Row-Based Storage ... 31
1.3 ... Summary ... 38
2 ... SAP HANA as a Database ... 39
2.1 ... The Fundamentals of SAP HANA ... 39
2.2 ... Big Data Solutions ... 44
2.3 ... SAP HANA for Non-SAP Use Cases ... 56
2.4 ... SAP BW on SAP HANA ... 71
2.5 ... SAP Business Suite Powered by SAP HANA ... 86
2.6 ... SAP S/4HANA ... 89
2.7 ... Other SAP HANA Capabilities ... 90
2.8 ... Summary ... 96
3 ... SAP HANA as an Application Platform ... 97
3.1 ... SAP HANA XS Classic ... 98
3.2 ... SAP HANA XSA ... 109
3.3 ... Developing SAP HANA XSA Applications with SAP Web IDE ... 130
3.4 ... Summary ... 139
4 ... SAP HANA Cloud Platform ... 141
4.1 ... Overview ... 142
4.2 ... Features ... 144
4.3 ... SAP HANA Cloud Platform Cockpit ... 148
4.4 ... SAP HANA Cloud Portal ... 151
4.5 ... Getting Started ... 153
4.6 ... Summary ... 155
5 ... SAP S/4HANA ... 157
5.1 ... Overview ... 157
5.2 ... SAP S/4HANA Finance ... 162
5.3 ... SAP S/4HANA Materials Management and Operations ... 167
5.4 ... Business Case for SAP S/4HANA ... 170
5.5 ... Migration from SAP ERP to SAP S/4HANA ... 172
5.6 ... SAP Activate ... 174
5.7 ... Summary ... 175
6 ... Planning an SAP HANA Implementation ... 177
6.1 ... Technical Basics ... 177
6.2 ... Hardware Specifications and Options ... 189
6.3 ... SAP HANA as a Standalone Data Warehouse ... 194
6.4 ... SAP Business Suite on SAP HANA ... 200
6.5 ... SAP S/4HANA ... 213
6.6 ... SAP Business Warehouse on SAP HANA ... 218
6.7 ... Summary ... 249
7 ... Reporting with SAP HANA ... 251
7.1 ... Overview of Tools ... 251
7.2 ... Connecting SAP BusinessObjects BI Tools to SAP HANA ... 267
7.3 ... SAP HANA Live ... 282
7.4 ... Summary ... 295
8 ... Data Modeling with SAP HANA ... 297
8.1 ... Data Modeling with SAP HANA Studio ... 298
8.2 ... Calculation Views: Dimensional Views ... 318
8.3 ... Calculation Views: Cube Views ... 345
8.4 ... SAP BW Modeling Tool for SAP HANA Studio ... 362
8.5 ... SAP HANA Web-Based Development Workbench ... 370
8.6 ... Summary ... 383
9 ... Data Provisioning ... 385
9.1 ... Choosing a Data Provisioning Method ... 385
9.2 ... Trigger-Based Replication: SAP Landscape Transformation ... 399
9.3 ... ETL-Based Replication: SAP Data Services ... 423
9.4 ... Log-Based Replication: SAP (Sybase) Replication Server (RS) and SAP HANA Load Controller (LC) ... 448
9.5 ... SAP HANA Smart Data Access for Data Federation and Virtualization ... 451
9.6 ... Summary ... 456
10 ... SAP HANA Administration ... 459
10.1 ... Using the SAP HANA Administration Console ... 460
10.2 ... SAP HANA Cockpit ... 470
10.3 ... System Monitoring ... 477
10.4 ... Updates ... 490
10.5 ... Security ... 494
10.6 ... License Keys ... 502
10.7 ... Backup and High Availability ... 505
10.8 ... Virtualization ... 508
10.9 ... Multiple Databases and Components on the Same Hardware ... 512
10.10 ... Multitenancy and Multitenant Database Containers ... 514
10.11 ... Multi-tier Data Management ... 519
10.12 ... SAP Solution Manager and SAP HANA ... 532
10.13 ... DBA Cockpit for SAP HANA ... 533
10.14 ... Summary ... 536
... Appendices ... 537
... The Authors ... 537
... Index ... 539
... Introduction ... 17
1 ... In-Memory Computing, Big Data, and SAP HANA ... 19
1.1 ... Introduction to In-Memory Computing and Big Data ... 20
1.2 ... Column-Based versus Row-Based Storage ... 31
1.3 ... Summary ... 38
2 ... SAP HANA as a Database ... 39
2.1 ... The Fundamentals of SAP HANA ... 39
2.2 ... Big Data Solutions ... 44
2.3 ... SAP HANA for Non-SAP Use Cases ... 56
2.4 ... SAP BW on SAP HANA ... 71
2.5 ... SAP Business Suite Powered by SAP HANA ... 86
2.6 ... SAP S/4HANA ... 89
2.7 ... Other SAP HANA Capabilities ... 90
2.8 ... Summary ... 96
3 ... SAP HANA as an Application Platform ... 97
3.1 ... SAP HANA XS Classic ... 98
3.2 ... SAP HANA XSA ... 109
3.3 ... Developing SAP HANA XSA Applications with SAP Web IDE ... 130
3.4 ... Summary ... 139
4 ... SAP HANA Cloud Platform ... 141
4.1 ... Overview ... 142
4.2 ... Features ... 144
4.3 ... SAP HANA Cloud Platform Cockpit ... 148
4.4 ... SAP HANA Cloud Portal ... 151
4.5 ... Getting Started ... 153
4.6 ... Summary ... 155
5 ... SAP S/4HANA ... 157
5.1 ... Overview ... 157
5.2 ... SAP S/4HANA Finance ... 162
5.3 ... SAP S/4HANA Materials Management and Operations ... 167
5.4 ... Business Case for SAP S/4HANA ... 170
5.5 ... Migration from SAP ERP to SAP S/4HANA ... 172
5.6 ... SAP Activate ... 174
5.7 ... Summary ... 175
6 ... Planning an SAP HANA Implementation ... 177
6.1 ... Technical Basics ... 177
6.2 ... Hardware Specifications and Options ... 189
6.3 ... SAP HANA as a Standalone Data Warehouse ... 194
6.4 ... SAP Business Suite on SAP HANA ... 200
6.5 ... SAP S/4HANA ... 213
6.6 ... SAP Business Warehouse on SAP HANA ... 218
6.7 ... Summary ... 249
7 ... Reporting with SAP HANA ... 251
7.1 ... Overview of Tools ... 251
7.2 ... Connecting SAP BusinessObjects BI Tools to SAP HANA ... 267
7.3 ... SAP HANA Live ... 282
7.4 ... Summary ... 295
8 ... Data Modeling with SAP HANA ... 297
8.1 ... Data Modeling with SAP HANA Studio ... 298
8.2 ... Calculation Views: Dimensional Views ... 318
8.3 ... Calculation Views: Cube Views ... 345
8.4 ... SAP BW Modeling Tool for SAP HANA Studio ... 362
8.5 ... SAP HANA Web-Based Development Workbench ... 370
8.6 ... Summary ... 383
9 ... Data Provisioning ... 385
9.1 ... Choosing a Data Provisioning Method ... 385
9.2 ... Trigger-Based Replication: SAP Landscape Transformation ... 399
9.3 ... ETL-Based Replication: SAP Data Services ... 423
9.4 ... Log-Based Replication: SAP (Sybase) Replication Server (RS) and SAP HANA Load Controller (LC) ... 448
9.5 ... SAP HANA Smart Data Access for Data Federation and Virtualization ... 451
9.6 ... Summary ... 456
10 ... SAP HANA Administration ... 459
10.1 ... Using the SAP HANA Administration Console ... 460
10.2 ... SAP HANA Cockpit ... 470
10.3 ... System Monitoring ... 477
10.4 ... Updates ... 490
10.5 ... Security ... 494
10.6 ... License Keys ... 502
10.7 ... Backup and High Availability ... 505
10.8 ... Virtualization ... 508
10.9 ... Multiple Databases and Components on the Same Hardware ... 512
10.10 ... Multitenancy and Multitenant Database Containers ... 514
10.11 ... Multi-tier Data Management ... 519
10.12 ... SAP Solution Manager and SAP HANA ... 532
10.13 ... DBA Cockpit for SAP HANA ... 533
10.14 ... Summary ... 536
... Appendices ... 537
... The Authors ... 537
... Index ... 539