Anil Bavaraju is an SAP professional with over 11 years of experience, primarily on SAP BW and SAP BusinessObjects BI products. He is an SAP Certified Solution Consultant for SAP Business Intelligence, and an SAP Certified Application Associate for SAP HANA. His current focus is on SAP HANA and SAP Fiori; at his consulting company, he has delivered proof of concepts on SAP Fiori, installed and configured the SAP Fiori landscape on an SAP HANA database, and extended SAP Fiori apps.

Explore advanced concepts like predictive modeling and SAP HANA spatial analysis

... Preface ... 15

... Target Audience ... 15

... Objective ... 16

... Structure of the Book ... 16

... Acknowledgments ... 18

1 ... Introduction to SAP HANA ... 19

1.1 ... Evolution of SAP HANA ... 21

1.2 ... Architecture ... 23

1.3 ... Comparing SAP HANA 1.0 and SAP HANA 2.0 ... 34

1.4 ... Summary ... 37

2 ... General Data Modeling Concepts ... 39

2.1 ... What Is a Data Model? ... 39

2.2 ... Why Do We Need Data Models? ... 40

2.3 ... Components ... 44

2.4 ... Dimensional Schemas ... 50

2.5 ... Joining Tables in a Data Model ... 53

2.6 ... Summary ... 54

3 ... Data Modeling Tools ... 55

3.1 ... Data Modeling with SAP HANA Studio versus SAP Web IDE ... 55

3.2 ... Getting Started with SAP Web IDE ... 56

3.3 ... Projects and Database Models in SAP Web IDE ... 70

3.4 ... Summary ... 80

4 ... Information Views ... 81

4.1 ... Getting Started with Information Views ... 81

4.2 ... Types of Information Views ... 83

4.3 ... Summary ... 101

5 ... Dimensions and Measures in Calculation Views ... 103

5.1 ... Dimension Calculation View ... 104

5.2 ... Using Filters in Dimension Calculation Views ... 139

5.3 ... Measures in Calculation Views ... 142

5.4 ... Semantic Attributes and Semantic Measures ... 155

5.5 ... View Nodes ... 158

5.6 ... Implementing Currency Conversions ... 187

5.7 ... Summary ... 199

6 ... Cube Calculation Views ... 201

6.1 ... Working with Star Join Calculation Views ... 202

6.2 ... Variables and Input Parameters ... 219

6.3 ... Working with Hierarchies ... 233

6.4 ... Restricted and Calculated Columns ... 250

6.5 ... Optimizing Calculation Views ... 258

6.6 ... Summary ... 266

7 ... Table Functions and Procedures ... 267

7.1 ... What Is a Table Function? ... 267

7.2 ... Introduction to SQL Scripts ... 268

7.3 ... Using Table Functions as a Data Source ... 274

7.4 ... Procedures ... 283

7.5 ... Summary ... 288

8 ... Model Management ... 289

8.1 ... Analyzing an SAP HANA Model ... 289

8.2 ... SAP HANA Model Migration ... 301

8.3 ... Summary ... 309

9 ... SAP HANA Live and SAP S/4HANA Embedded Analytics ... 311

9.1 ... SAP HANA Live Architecture ... 311

9.2 ... Types of Virtual Data Model Views ... 313

9.3 ... SAP HANA Live Views in the SAP HANA Live Browser ... 314

9.4 ... SAP S/4HANA Embedded Analytics Architecture ... 326

9.5 ... Core Data Service Views ... 328

9.6 ... Summary ... 341

10 ... Authorizations in SAP Web IDE for SAP HANA ... 343

10.1 ... Object Ownership ... 343

10.2 ... Privileges and Roles ... 347

10.3 ... Setting Up Access between SAP HANA Deployment Infrastructure and Classic Database ... 348

10.4 ... Defining Analytic Privileges ... 367

10.5 ... Defining Roles ... 373

10.6 ... Summary ... 379

11 ... Advanced Topics ... 381

11.1 ... Working with Predictive Models ... 382

11.2 ... SAP HANA Spatial Analysis ... 400

11.3 ... Graph Processing with SAP HANA ... 417

11.4 ... Summary ... 424

... The Author ... 425

... Index ... 427