Learn HANA in 24 Hours (eBook)

SAP Hana is popular due to its large main memories and massive parallel job processing capabilities. It makes SAP Hana real fast. The motive of this book is to develop a good understanding of how SAP Hana is used. The book doesn't need any experience with SAP HANA or software development. It's a self-learning guide that even beginners can use. Everything about SAP HANA is explained like architecture, modeling, reporting, SQL script, and so on.

This book is full of information, hands-on and real life project experience learning. In this edition, you will identify various components of SAP HANA and its working process. Though the book size is small, it tried to justify almost all important topics of SAP HANA with examples and images. These includes SLT, the connection between SAP system and HANA, Data services, etc. You will also learn how to use SQL script in HANA.

By the end of this book, you will be able to integrate SAP HANA pretty much with any platform. Over a time you can use this edition as a handbook and harness your SAP Hana skills. So all and above this edition will save a lot of your expenses spend behind other courses and learning resources.

Table Content

Chapter 1: Introduction

Introduction SAP HANA

Why to choose SAP HANA?

SAP HANA In-Memory Strategy

SAP HANA Advantages

SAP HANA Compare to BWA (Business Warehouse Accelerator)

Chapter 2: Hana Architecture

SAP HANA Architecture

SAP HANA Landscape

SAP HANA Sizing

Chapter 3: SAP HANA Studio

Pre-Requisite for SAP HANA Studio

Supported Platform

Download & Install SAP HANA Studio

Add System in SAP HANA Studio

Work With SAP HANA Studio

Chapter 4: SQL Script, Data Type, Trigger, Sequence, Operator, Function, Expression, Identifiers

What is SAP HANA SQL

SAP HANA Identifiers

SAP HANA Data Type

SAP HANA Operator

SAP HANA SQL FUNCTIONS

SAP HANA SQL EXPRESSIONS

SAP HANA SQL Stored Procedure

SAP HANA Create Sequence

SAP HANA Create Trigger

Chapter 5: Data Provisioning

Overview of Replication Technology

SLT (SAP Landscape Transformation Replication Server)

SAP DS (SAP DATA Services)

SAP HANA Direct Extractor Connection (DXC)

Flat file Upload to SAP HANA

Chapter 6: Modeling

SAP HANA Modelling Overview

Join Method in SAP HANA

SAP HANA Best Practices for Creating Information Models

SAP HANA Attribute View

SAP HANA Analytic View

SAP HANA Calculation View

SAP HANA Analytic Privileges

SAP HANA Information Composer

SAP HANA Import and Export

SAP HANA Performance Optimization Technique

Chapter 7: Security

SAP HANA Security Overview

SAP HANA Authentication

SAP HANA Authorization

SAP HANA User and Role Administration

SAP HANA License Management

SAP HANA Auditing

Chapter 8: Reporting

Reporting In SAP BI (Business Intelligence) Overview

Reporting In Webi of SAP Business Objects (BO) on HANA

Reporting In Crystal Report

Reporting In SAP Lumira

Reporting In Microsoft Excel