Implementing SAP HANA

by Jonathan Haun, Chris Hickman, Don Loden, Roy Wells

Overview

If you're ready to move past the basics and see what SAP HANA can really do, you'll want this book along for the ride. Explore the steps in a complete SAP HANA implementation, and then play with downloadable sample data that you can use to test your skills. Thanks to a detailed case study that moves beyond theory and into practice, you'll soon be an expert in data provisioning, data modeling, and connecting to the SAP BusinessObjects BI platform. Take your SAP HANA knowledge to the next level!Highlights:

• Columnar database technology
• Source system analysis
• Data provisioning
• SAP Data Services
• SAP Information Steward
• SAP HANA Studio
• Data modeling
• Attribute, analytic, and calculation views
• SAP BusinessObjects BI platform
• SAP Predictive Analysis
• SAP Lumira

Product Details

ISBN-13:	9781493211760
Publisher:	Rheinwerk Publishing, Inc.
Publication date:	04/28/2015
Series:	Standard
Edition description:	Updated
Pages:	860
Product dimensions:	7.20(w) x 9.30(h) x 2.20(d)

About the Author

Jonathan Haun currently serves as the lead SAP HANA consultant and consulting manager with Decision First Technologies. Over the past two years, he has had the opportunity to help several clients implement solutions using SAP HANA. In addition to being certified in multiple
SAP BusinessObjects tools, he is also a SAP Certified Application Associate and SAP Certified Technology Associate for SAP HANA 1.0. Jonathan has worked in the field of business intelligence for more than 10 years. During this time, he has gained invaluable experience while helping customers implement solutions using the tools from the SAP BusinessObjects product line. Before working as a full-time business intelligence consultant, he worked in a variety of information technology management and administrative roles. His combination of experience and wealth of technical knowledge make him an ideal source of information pertaining to business intelligence solutions powered by SAP
HANA. You can follow Jonathan on Twitter at @jdh2n or visit his blog at http://bobj.sapbiblog.com.

Chris Hickman is a certified SAP BusinessObjects consultant and principal consultant at Decision First Technologies. His specific areas of expertise include reporting, analysis, dashboard development, and visualization techniques. Chris’ software development background has enabled him to achieve proven effectiveness in architecting, developing, testing, and supporting both desktop-based and web-based applications for many customer engagements representing various industries. Chris also speaks globally at SAP and ASUG events.

Don Loden is a principal consultant at Decision First Technologies with full lifecycle data warehouse and information governance experience in multiple verticals. He is an SAP Certified Application Associate on SAP BusinessObjects Data Integrator, and he is very active in the SAP
community, speaking globally at numerous SAP and ASUG conferences and events. He has more than 14 years of information technology experience in the following areas: ETL architecture, development, and tuning; logical and physical data modeling; and mentoring on data warehouse, data quality, information governance, and ETL concepts. You can follow Don on Twitter at @donloden. You can contact Don by email at [e-mail].

Roy Wells is a principal consultant at Decision First Technologies, where he uses his 15 years of experience in system and application architecture to lead clients in the successful implementation of end to end BI solutions. He is particularly interested in delivering innovative visualization solutions and developing customized end user experiences that enable business transformation. He also enjoys mentoring and speaking publicly about BI, software development, and system integration solutions at conferences and venues worldwide. You can follow Roy on Twitter at @rgwbobj or contact him by email at [e-mail].

Table of Contents

Acknowledgments … 17Preface …19PART I Introduction1 SAP HANA, SAP BusinessObjects BI, and SAP Data Services …27
1.1 What Is SAP HANA? …28
1.2 Business Intelligence Solutions with SAP HANA …38
1.3 SAP Business Suite on SAP HANA …57
1.4 Traditional EIM with SAP Data Services …60
1.5 Traditional Business Intelligence with SAP BusinessObjects BI …62
1.6 Solution Architectural Overview …66
1.7 Summary …762 Securing the SAP HANA Environment …77
2.1 Configuring the SAP HANA Environment for Development …78
2.2 SAP HANA Authorizations …100
2.3 User and Role Provisioning …108
2.4 SAP HANA Authentication …131
2.5 Case Study: An End-to-End Security Configuration …139
2.6 Summary …1523 Data Storage in SAP HANA …155
3.1 OLAP and OLTP Data Storage …155
3.2 Data Storage Components …165
3.3 Modeling Tables and Data Marts …175
3.4 Case Study: Creating Data Marts and Tables for an SAP HANA Project … 186
3.5 Summary … 194PART II Getting Data Into SAP HANA4 Preprovisioning Data with SAP Data Services … 197
4.1 Making the Case for Source System Analysis … 197
4.2 SSA Techniques in SAP Data Services … 202
4.3 SSA: Beyond Tools and Profiling … 215
4.4 Summary … 2225 Provisioning Data with SAP Data Services … 223
5.1 Provisioning Data Using SAP Data Services Designer … 223
5.2 Introduction to SAP Data Services Workbench … 290
5.3 Data Provisioning via Real-Time Replication … 305
5.4 Summary … 3086 Loading Data with SAP Data Services … 309
6.1 Loading Data in a Batch … 309
6.2 Loading Data in Real Time … 335
6.3 Case Study: Loading Data in a Batch … 340
6.4 Case Study: Loading Data in Real Time … 389
6.5 Summary … 395PART III Multidimensional Modeling in SAP HANA7 Introduction to Multidimensional Modeling … 399
7.1 Understanding Multidimensional Models … 400
7.2 Benefits of SAP HANA Multidimensional Modeling … 404
7.3 Summary … 4118 Tools and Components of Multidimensional Modeling … 413
8.1 SAP HANA Studio … 413
8.2 Schemas … 420
8.3 Packages … 423
8.4 Summary … 4269 Creating SAP HANA Information Views … 427
9.1 Attribute Views … 427
9.2 Analytic Views … 444
9.3 Calculation Views … 460
9.4 Summary … 47810 Multidimensional Modeling in Practice … 479
10.1 Data Processing in SAP HANA … 479
10.2 Case Study 1: Modeling Sales Data to Produce Robust Analytics … 490
10.3 Case Study 2: Building Complex Calculations for Executive-Level Analysis … 515
10.4 Summary … 53311 Securing Data in SAP HANA … 535
11.1 Introduction to Analytic Privileges … 536
11.2 Creating Analytic Privileges … 540
11.3 Applying Analytic Privileges … 561
11.4 Case Study: Securing Sales Data with Analytic Privileges … 567
11.5 Summary … 581PART IV Integrating SAP HANA with SAP Business Intelligence Tools12 Building Universes for SAP HANA … 585
12.1 SAP HANA and the Universe … 587
12.2 Manually Building UNX Universes for SAP HANA … 600
12.3 Automatically Generating UNX Universes for SAP HANA … 642
12.4 The SAP HANA Engines in Universe Design … 656
12.5 Case Study: Designing a Universe to Support Internet Sales Data ... 662
12.6 Summary … 68913 Predictive Analytics with SAP HANA … 691
13.1 Predictive Analysis and SAP HANA: The Basics … 692
13.2 Integrating with SAP HANA … 712
13.3 Integrating with SAP BusinessObjects BI … 716
13.4 Case Study 1: Clustering Analysis … 719
13.5 Case Study 2: Product Recommendation Rules … 738
13.6 Summary … 75014 Professionally Authored Dashboards with SAP HANA … 751
14.1 SAP HANA as a Data Source for SAP BusinessObjects Dashboards … 754
14.2 SAP HANA as a Data Source for SAP BusinessObjects Design Studio … 759
14.3 Case Study: Exploring Data with SAP BusinessObjects Design Studio on Top of SAP HANA … 764
14.4 Summary … 76915 Data Exploration and Self-Service Analytics with SAP HANA … 771
15.1 SAP HANA as a Data Source for SAP BusinessObjects Explorer … 772
15.2 SAP HANA as a Data Source for SAP Lumira … 780
15.3 Case Study: Exploring Sales Data with SAP Lumira on Top of SAP HANA … 789
15.4 Summary … 79616 SAP BusinessObjects Web Intelligence with SAP HANA … 797
16.1 Connecting SAP BusinessObjects Web Intelligence to SAP HANA … 797
16.2 Report Optimization Features with SAP HANA … 800
16.3 Case Study: Exploring Sales Data with SAP BusinessObjects Web Intelligence on Top of SAP HANA … 808
16.4 Summary … 81417 SAP Crystal Reports with SAP HANA … 815
17.1 SAP HANA as a Data Source for SAP Crystal Reports … 817
17.2 Case Study: Exploring Data with SAP Crystal Reports on Top of SAP HANA … 831
17.3 Summary … 836Appendices … 837A Source System Analysis with SAP Information Steward Data Insight … 837
A.1 Column Profiling … 841
A.2 Address Profiling … 843
A.3 Dependency Profiling … 845
A.4 Redundancy Profiling … 846
A.5 Uniqueness Profiling … 847
A.6 Summary … 848B The Authors … 849Index… 851