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