Implementing SAP HANA
2nd Edition
Published on 10. February 2015
Book
Hardback
860 pages
978-1-4932-1176-0 (ISBN)
Description
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 include:- 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
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
More details
Other editions
Previous edition
Jonathan Haun | Chris Hickman | Don Loden
Implementing SAP HANA
Book
10/2013
1st Edition
SAP Press
€69.95
Article exhausted; check for reprint
Persons
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 don.loden@decisionfirst.com.
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 roy.wells@decisionfirst.com.
Content
Acknowledgments . 17
Preface .19
PART I Introduction
1 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 .76
2 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 .152
3 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 . 194
PART II Getting Data Into SAP HANA
4 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 . 222
5 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 . 308
6 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 . 395
PART III Multidimensional Modeling in SAP HANA
7 Introduction to Multidimensional Modeling . 399
7.1 Understanding Multidimensional Models . 400
7.2 Benefits of SAP HANA Multidimensional Modeling . 404
7.3 Summary . 411
8 Tools and Components of Multidimensional Modeling . 413
8.1 SAP HANA Studio . 413
8.2 Schemas . 420
8.3 Packages . 423
8.4 Summary . 426
9 Creating SAP HANA Information Views . 427
9.1 Attribute Views . 427
9.2 Analytic Views . 444
9.3 Calculation Views . 460
9.4 Summary . 478
10 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 . 533
11 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 . 581
PART IV Integrating SAP HANA with SAP Business Intelligence Tools
12 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 . 689
13 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 . 750
14 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 . 769
15 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 . 796
16 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 . 814
17 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 . 836
Appendices . 837
A 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 . 848
B The Authors . 849
Index. 851