Data Modeling for SAP HANA 2.0

Contents
Preface
	Target Audience
	Objective
	Structure of the Book
	Acknowledgments
1  Introduction to SAP HANA
	1.1 Evolution of SAP HANA
	1.2 Architecture
		1.2.1 Index Server
		1.2.2 SAP HANA Multitenant Database Architecture
		1.2.3 SAP HANA XS Advanced Architecture
	1.3 Comparing SAP HANA 1.0 and SAP HANA 2.0
	1.4 Summary
2  General Data Modeling Concepts
	2.1 What Is a Data Model?
	2.2 Why Do We Need Data Models?
		2.2.1 Conceptual Data Model
		2.2.2 Logical Data Model
		2.2.3 Physical Data Model
	2.3 Components
		2.3.1 What Are Dimensions, Measures, and Attributes?
		2.3.2 Fact Tables and Entities
		2.3.3 Primary Key and Foreign Key
		2.3.4 Hierarchies
	2.4 Dimensional Schemas
		2.4.1 Star Schemas
		2.4.2 Snowflake Schemas
	2.5 Joining Tables in a Data Model
	2.6 Summary
3  Data Modeling Tools
	3.1 Data Modeling with SAP HANA Studio versus SAP Web IDE
	3.2 Getting Started with SAP Web IDE
		3.2.1 Setting Up Access in SAP HANA XSA
		3.2.2 Organization and Spaces
		3.2.3 Create Organizations and Spaces in SAP HANA XSA
		3.2.4 Enabling Spaces
		3.2.5 Launch SAP Web IDE for SAP HANA
	3.3 Projects and Database Models in SAP Web IDE
		3.3.1 Connecting SAP Web IDE to the SAP HANA Database
		3.3.2 Creating a Project in SAP Web IDE Using a Template
	3.4 Summary
4  Information Views
	4.1 Getting Started with Information Views
	4.2 Types of Information Views
		4.2.1 Converting All SAP HANA Views to Calculation Views
		4.2.2 Graphical Calculation Views
		4.2.3 Table Functions
	4.3 Summary
5  Dimensions and Measures in Calculation Views
	5.1 Dimension Calculation View
		5.1.1 Create CDS Artifacts
		5.1.2 Create a Dimension Calculation View
		5.1.3 Cardinality
		5.1.4 Create a Calculated Attribute in a Calculation View
		5.1.5 Time-Based Dimension Calculation View
	5.2 Using Filters in Dimension Calculation Views
	5.3 Measures in Calculation Views
		5.3.1 Working with Cube Calculation Views
		5.3.2 Create a Cube Calculation View
		5.3.3 Deploy a Cube Calculation View
	5.4 Semantic Attributes and Semantic Measures
	5.5 View Nodes
		5.5.1 Joins
		5.5.2 Non Equi Join
		5.5.3 Unions
		5.5.4 Intersect
		5.5.5 Minus
		5.5.6 Aggregations
		5.5.7 Ranks
	5.6 Implementing Currency Conversions
	5.7 Summary
6  Cube Calculation Views
	6.1 Working with Star Join Calculation Views
		6.1.1 Create a Products Dimension Calculation View
		6.1.2 Create a Customer Dimension Calculation View
		6.1.3 Create a Supplier Dimension Calculation View
		6.1.4 Create a Cube Calculation View
		6.1.5 Preview Cube Calculation View
	6.2 Variables and Input Parameters
		6.2.1 Create a Cube Calculation View with Variables
		6.2.2 Create an Input Parameter
	6.3 Working with Hierarchies
		6.3.1 Level Hierarchy
		6.3.2 Parent-Child Hierarchy
		6.3.3 Time-Based Hierarchy
	6.4 Restricted and Calculated Columns
		6.4.1 Create Calculated Columns
		6.4.2 Create Restricted Columns
	6.5 Optimizing Calculation Views
		6.5.1 Performance Analysis Mode
		6.5.2 Table Partitioning
		6.5.3 Create a Hash Partition
		6.5.4 Debug Query Mode
	6.6 Summary
7  Table Functions and Procedures
	7.1 What Is a Table Function?
	7.2 Introduction to SQL Scripts
		7.2.1 SQL Identifiers
		7.2.2 SQL Data Types
		7.2.3 SQL Scripts in SAP Web IDE
	7.3 Using Table Functions as a Data Source
		7.3.1 Create a Table Function Using SQL Scripts
		7.3.2 Create a Dimension Calculation View Using Table Functions as a Data Source
	7.4 Procedures
		7.4.1 Create a Procedure Using SQL Scripts
		7.4.2 Calling a Procedure in SAP Web IDE for SAP HANA
	7.5 Summary
8  Model Management
	8.1 Analyzing an SAP HANA Model
		8.1.1 Data Lineage and Impact Analysis
		8.1.2 Checking the Source of a Field Using Data Lineage
		8.1.3 Tracing Dependent Objects Using Data Lineage
		8.1.4 Tracing Dependent Objects Using Impact Analysis
		8.1.5 Managing SAP HANA Models in SAP Web IDE
	8.2 SAP HANA Model Migration
		8.2.1 Convert Attribute Views and Analytic Views to Graphical Calculation Views
		8.2.2 Migrate Calculation Views Using SAP HANA XSA Migration Assistant
		8.2.3 Import Migrated Content to SAP Web IDE
	8.3 Summary
9  SAP HANA Live and SAP S/4HANA Embedded Analytics
	9.1 SAP HANA Live Architecture
	9.2 Types of Virtual Data Model Views
	9.3 SAP HANA Live Views in the SAP HANA Live Browser
		9.3.1 SAP HANA Live Viewer Configuration
		9.3.2 SAP HANA Live Viewer Features
		9.3.3 Consuming SAP HANA Live Views in SAP Analysis for Microsoft Office
	9.4 SAP S/4HANA Embedded Analytics Architecture
	9.5 Core Data Service Views
		9.5.1 Create a CDS View
		9.5.2 Consume CDS Views in SAP Lumira, Designer Edition
	9.6 Summary
10  Authorizations in SAP Web IDE for SAP HANA
	10.1 Object Ownership
		10.1.1 Ownership Concepts
		10.1.2 Object Ownership Scenario
	10.2 Privileges and Roles
	10.3 Setting Up Access between SAP HANA Deployment Infrastructure and Classic Database
		10.3.1 Configure SAP HANA Database Role in SAP HANA XSA
		10.3.2 Accessing SAP HANA Objects from External SAP HANA Deployment Infrastructure Container
		10.3.3 Create Synonyms in SAP HANA Deployment Infrastructure Container
	10.4 Defining Analytic Privileges
		10.4.1 Create Analytic Privileges
	10.5 Defining Roles
		10.5.1 Create a Role
		10.5.2 Assign the Role to a User
		10.5.3 Test Analytic Privileges
	10.6 Summary
11  Advanced Topics
	11.1 Working with Predictive Models
		11.1.1 Introduction to the Predictive Analysis Library
		11.1.2 Algorithms Supported by the Predictive Analysis Library
		11.1.3 Create a Predictive Model Using SAP HANA Predictive Analysis Library Functions
	11.2 SAP HANA Spatial Analysis
		11.2.1 SAP HANA Spatial Processing Architecture
		11.2.2 Working with Spatial Data in SAP HANA
		11.2.3 Create a Calculation View on Spatial Data
		11.2.4 Create a New Input Parameter
	11.3 Graph Processing with SAP HANA
		11.3.1 Working with Graph Models in SAP HANA Graph Viewer
		11.3.2 Create a Graph Workspace
		11.3.3 Execute Graph Workspace
	11.4 Summary
The Author
Index