---

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

---

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: Explori

---