Real Time Analytics with SAP HANA电子书

Real Time Analytics with SAP HANA

Table of Contents

Real Time Analytics with SAP HANA

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Questions

1. Kickoff – Before We Start

Introducing SAP HANA SQL

Classical SQL

The SAP HANA SQLscript

Why SQLscript?

How different is an SQLscript in SAP HANA from classical SQL queries?

When should we use SQLscript?

Procedures

Creating with the SQL editor (in SAP HANA Studio)

Procedure creation using the wizard

JOINS in SAP HANA

Unions versus JOINS

Self-study questions

Summary

2. SAP HANA Data Modeling Approach

Row and column storage in SAP HANA

Choosing the right table

Basic architecture of the SAP HANA engine

Different modeling artifacts in SAP HANA

Modeling principles

SAP HANA Studio

Perspectives in SAP HANA Studio

Adding our system to SAP HANA Studio

The system view

Different schemas in SAP HANA

Creating package and delivery unit

Deleting packages

Delivery units

Self-study questions

Summary

3. Different Ways of SAP HANA Data Load

Loading data from Flat file in SAP HANA

Real-time replication via SAP SLT (System Landscape Transformation) Replication Server

Loading data with SAP Direct Extractor

Application server configuration

Creating a DXC schema and user in SAP HANA

Loading data in SAP HANA with Data Services Workbench

SAP Replication Server

Smart Data Access

Self-study questions

Summary

4. Creating SAP HANA Artifacts Attribute Views and Analytical Views

Steps to adjust preferences

Creating attribute views

Defining attribute and key attribute

Creating time attribute views

Creating analytical views

Creating other elements

Calculated attribute

Calculated measures

Calculated columns

Creating variables

Self-study questions

Summary

5. Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views

Creating a restricted measure and a calculated measure

Creating filters

Steps for creating a filter

Creating input parameters and variables

Creating calculation views

Analytical privileges

Self-study questions

Summary

6. Understanding Text Search and Hierarchies in SAP HANA

Creating and using Full Text Search

Enabling the search option

Creating hierarchies

Creating a level hierarchy

Creating a parent-child hierarchy

Self-study questions

Summary

7. Using Decision Tables and Transporting SAP HANA Content

What is a decision table?

Why use decision tables?

Transport management in SAP HANA

SAP HANA application lifecycle manager

Transporting a delivery unit with HALM

Export and import – moving SAP HANA content manually

Currency conversion in SAP HANA

Self-study questions

Summary

8. Consuming SAP HANA Data Models

Connecting to the SAP HANA database

Reporting tools for SAP HANA

Analysis for Office

SAP Business Objects Analysis for OLAP

Using Microsoft Excel as a reporting tool

Summary

9. An Introduction to Application Function Library

Application Function Library

Predictive Analysis Library

Calling PAL functions

Business Function Library

Self-study questions

Summary

Index