Zum Hauptinhalt springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
Data Modeling for SAP HANA 2.0
Learn how to model data in SAP HANA 2.0 with the SAP Web IDE. Build calculations views and table functions, manage...
Buch von Anil Bavaraju
Sprache: Englisch

152,95 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 1-2 Wochen

Kategorien:
Beschreibung
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
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
Inhaltsverzeichnis
... 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
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Buch
Titelzusatz: Learn how to model data in SAP HANA 2.0 with the SAP Web IDE. Build calculations views and table functions, manage models, and more. Explore advanced concepts like predictive modeling and SAP HANA spatial Analysis
Inhalt: 432 S.
ISBN-13: 9781493217519
ISBN-10: 1493217518
Sprache: Englisch
Herstellernummer: 459/21751
Autor: Bavaraju, Anil
Hersteller: Rheinwerk Verlag
Maße: 235 x 193 x 30 mm
Von/Mit: Anil Bavaraju
Erscheinungsdatum: 11.09.2019
Gewicht: 0,926 kg
Artikel-ID: 115194489
Inhaltsverzeichnis
... 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
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Buch
Titelzusatz: Learn how to model data in SAP HANA 2.0 with the SAP Web IDE. Build calculations views and table functions, manage models, and more. Explore advanced concepts like predictive modeling and SAP HANA spatial Analysis
Inhalt: 432 S.
ISBN-13: 9781493217519
ISBN-10: 1493217518
Sprache: Englisch
Herstellernummer: 459/21751
Autor: Bavaraju, Anil
Hersteller: Rheinwerk Verlag
Maße: 235 x 193 x 30 mm
Von/Mit: Anil Bavaraju
Erscheinungsdatum: 11.09.2019
Gewicht: 0,926 kg
Artikel-ID: 115194489
Warnhinweis