Real time analytics with SAP HANA / Vinay Singh.

Format:

Book

Author/Creator:

Singh, Vinay, author.

Series:

Professional expertise distilled.

Professional Expertise Distilled

Language:

English

Subjects (All):

SAP HANA (Electronic resource).

Real-time data processing.

Database management.

Physical Description:

1 online resource (192 p.)

Edition:

1st edition

Place of Publication:

Birmingham, England ; Mumbai : Packt Publishing, [2015]

System Details:

text file

Biography/History:

Singh Vinay: Vinay Singh is a data science manager at BASF, Germany. He has over 12 years' experience in data warehousing and BI. Before joining BASF, he worked with multiple companies/customers, including SAP, Adobe Systems, Freudenberg, and T-Systems, which provided him with a good mix of product development and consulting experience. His other publications include Real-Time Analytics with SAP HANA, published by Packt, Manage Your SAP Projects with SAP Activate, also published by Packt, and Creating and Using Advanced DSOs in SAP BW on SAP HANA, by SAP PRESS. He is a visiting research scholar at the National Central University of Taiwan, and a distinguished speaker at various forums.

Summary:

Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics About This Book This 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 Learn Get 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.

Contents:

Cover

Copyright

Credits

About the Author

About the Reviewers

www.PacktPub.com

Table of Contents

Preface

Chapter 1: Kickoff - Before SQLscript 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

Chapter 2: The SAP HANA Data Modeling Approach

Row and column storage in SAP HANA

Choosing the right table

A basic architecture of the SAP HANA engine

Different modeling artifacts in SAP HANA

Modeling principles

The 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

Chapter 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

Chapter 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

Chapter 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

Chapter 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

Chapter 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

Chapter 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

Chapter 9: An Introduction to Application Function Library

Application Function Library

Predictive Analysis Library

Calling PAL functions

Business Function Library

Index.

Notes:

Description based upon print version of record.

Description based on print version record.

ISBN:

9781782174127

1782174125

OCLC:

935250048