Implementing SAP HANA

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 SAPHANA. 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.

Acknowledgments
Preface
PART I Introduction
1 SAP HANA, SAP BusinessObjects BI, and SAP Data Services
1.1 What Is SAP HANA?
1.2 Business Intelligence Solutions with SAP HANA
1.3 SAP Business Suite on SAP HANA
1.4 Traditional EIM with SAP Data Services
1.5 Traditional Business Intelligence with SAP BusinessObjects BI
1.6 Solution Architectural Overview
1.7 Summary
2 Securing the SAP HANA Environment
2.1 Configuring the SAP HANA Environment for Development
2.2 SAP HANA Authorizations
2.3 User and Role Provisioning
2.4 SAP HANA Authentication
2.5 Case Study: An End-to-End Security Configuration
2.6 Summary
3 Data Storage in SAP HANA
3.1 OLAP and OLTP Data Storage
3.2 Data Storage Components
3.3 Modeling Tables and Data Marts
3.4 Case Study: Creating Data Marts and Tables for an SAP HANA Project
3.5 Summary
PART II Getting Data Into SAP HANA 4 Preprovisioning Data with SAP Data Services
4.1 Making the Case for Source System Analysis
4.2 SSA Techniques in SAP Data Services
4.3 SSA: Beyond Tools and Profiling
4.4 Summary
5 Provisioning Data with SAP Data Services
5.1 Provisioning Data Using SAP Data Services Designer
5.2 Introduction to SAP Data Services Workbench
5.3 Data Provisioning via Real-Time Replication
5.4 Summary
6 Loading Data with SAP Data Services
6.1 Loading Data in a Batch
6.2 Loading Data in Real Time
6.3 Case Study: Loading Data in a Batch
6.4 Case Study: Loading Data in Real Time
6.5 Summary
PART III Multidimensional Modeling in SAP HANA 7 Introduction to Multidimensional Modeling
7.1 Understanding Multidimensional Models
7.2 Benefits of SAP HANA Multidimensional Modeling
7.3 Summary
8 Tools and Components of Multidimensional Modeling
8.1 SAP HANA Studio
8.2 Schemas
8.3 Packages
8.4 Summary
9 Creating SAP HANA Information Views
9.1 Attribute Views
9.2 Analytic Views
9.3 Calculation Views
9.4 Summary
10 Multidimensional Modeling in Practice
10.1 Data Processing in SAP HANA
10.2 Case Study 1: Modeling Sales Data to Produce Robust Analytics
10.3 Case Study 2: Building Complex Calculations for Executive-Level Analysis
10.4 Summary
11 Securing Data in SAP HANA
11.1 Introduction to Analytic Privileges
11.2 Creating Analytic Privileges
11.3 Applying Analytic Privileges
11.4 Case Study: Securing Sales Data with Analytic Privileges
11.5 Summary
PART IV Integrating SAP HANA with SAP Business Intelligence Tools 12 Building Universes for SAP HANA
12.1 SAP HANA and the Universe
12.2 Manually Building UNX Universes for SAP HANA
12.3 Automatically Generating UNX Universes for SAP HANA
12.4 The SAP HANA Engines in Universe Design
12.5 Case Study: Designing a Universe to Support Internet Sales Data
12.6 Summary
13 Predictive Analytics with SAP HANA
13.1 Predictive Analysis and SAP HANA: The Basics
13.2 Integrating with SAP HANA
13.3 Integrating with SAP BusinessObjects BI
13.4 Case Study 1: Clustering Analysis
13.5 Case Study 2: Product Recommendation Rules
13.6 Summary
14 Professionally Authored Dashboards with SAP HANA
14.1 SAP HANA as a Data Source for SAP BusinessObjects Dashboards
14.2 SAP HANA as a Data Source for SAP BusinessObjects Design Studio
14.3 Case Study: Exploring Data with SAP BusinessObjects Design Studio on Top of SAP HANA
14.4 Summary
15 Data Exploration and Self-Service Analytics with SAP HANA
15.1 SAP HANA as a Data Source for SAP BusinessObjects Explorer
15.2 SAP HANA as a Data Source for SAP Lumira
15.3 Case Study: Exploring Sales Data with SAP Lumira on Top of SAP HANA
15.4 Summary
16 SAP BusinessObjects Web Intelligence with SAP HANA
16.1 Connecting SAP BusinessObjects Web Intelligence to SAP HANA
16.2 Report Optimization Features with SAP HANA
16.3 Case Study: Exploring Sales Data with SAP BusinessObjects Web Intelligence on Top of SAP HANA
16.4 Summary
17 SAP Crystal Reports with SAP HANA
17.1 SAP HANA as a Data Source for SAP Crystal Reports
17.2 Case Study: Exploring Data with SAP Crystal Reports on Top of SAP HANA
17.3 Summary
Appendices
Source System Analysis with SAP Information Steward Data Insight
Column Profiling
Address Profiling
Dependency Profiling
Redundancy Profiling
Uniqueness Profiling
Summary
The Authors
Index