Data Modelling for SAP HANA 2.0

1. Auflage 2019
ISBN: 978-1-4932-1751-9
Verlag: SAP Press

Buch, Englisch, 432 Seiten, Format (B × H): 187 mm x 238 mm, Gewicht: 928 g

Reihe: SAP PRESS: englisch

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

Autoren/Hrsg.

Bavaraju, Anil

Fachgebiete

• Mathematik | Informatik EDV | Informatik Angewandte Informatik Wirtschaftsinformatik
• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP
• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management

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

Über Autor(innen)

Bavaraju, Anil
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.