Data Modelling for SAP HANA 2.0 - Anil Bavaraju

. .

Résumé :
... 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


...

Biographie:
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...

Sommaire:

Find meaning in your business data. Build, manage, and secure calculation views and table functions with the SAP Web IDE for SAP HANA. See how SAP Web IDE, SAP HANA Live, and SAP S/4HANA embedded analytics all interact to create effective data models. Explore advanced modeling concepts compatible with SAP HANA 2.0, like predictive modeling and geospatial analysis. Begin designing the perfect model today!

a. Getting Started
Understand the general modeling concepts you need to build effective data models. Get comfortable with the SAP Web IDE, model components, and dimensional schemas. b. Build, Manage, Secure Get step-by-step instructions to create table functions and calculation views, and learn how to manage models in the SAP Web IDE.. Then, tackle the SAP HANA security concepts you need to lock down your data models. c. Advanced Topics See how SAP HANA Live and SAP S/4HANA embedded analytics factor in to your models, through virtual data models and core data service views. Then explore advanced features, including predictive models, spatial analysis, and more. 1) SAP HANA 2.0 2) Data Modeling 3) SAP Web IDE 4) Information views 5) Calculation views 6) Table functions 7) Model management 8) Model migration 9) SAP HANA Live 10) SAP S/4HANA embedded analytics 11) Security and authorizations