Real Time Analytics with SAP HANA

图书信息

作者	Vinay Singh
出版社	Packt Publishing
ISBN	9781782174127
出版时间	2015-10-30
字数	27.9万
分类	进口书,外文原版书,电脑,网络

读书简介

Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analyticsAbout This BookThis book will help you to process analytical and transactional data in real time with the help of SAP HANA.Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio.Packed with rich examples and use cases that are closely focused on developing real-time applications. Who This Book Is For If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, then this book is for you.What You Will LearnGet to grips with the basic building blocks of Analytics/Data models in the SAP HANA environment.Discover various schemas, modeling principles, Joins, and the architecture of the SAP HANA engine.Build data models and artifacts in Sap HANA Studio.Design decision tables and understand the concept of transport management in the SAP HANA landscape.Work with the different views in SAP HANA Studio.Explore full-text search and fuzzy search in SAP HANA.Create your own scenarios and use cases using sample data and code. In Detail SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources. Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you’ll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We’ll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts—Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier.Style and approach This is an easy-to-follow, step-by-step, rapid guide to help you learn analytics in SAP HANA through ample hands-on exercises and use case scenarios.

目录

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