Real Time Analytics with SAP HANA

Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics
Preview in Mapt
Code Files

Real Time Analytics with SAP HANA

Vinay Singh

Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $31.99
Save 68%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$39.99
$29.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Real Time Analytics with SAP HANA Book Cover
Real Time Analytics with SAP HANA
$ 31.99
$ 10.00
Full Stack Development with JHipster Book Cover
Full Stack Development with JHipster
$ 35.99
$ 10.00
Buy 2 for $20.00
Save $47.98
Add to Cart

Book Details

ISBN 139781782174110
Paperback226 pages

Book Description

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.

Table of Contents

Chapter 1: Kickoff – Before We Start
Introducing SAP HANA SQL
The SAP HANA SQLscript
When should we use SQLscript?
Procedures
JOINS in SAP HANA
Unions versus JOINS
Self-study questions
Summary
Chapter 2: SAP HANA Data Modeling Approach
Row and column storage in SAP HANA
Basic architecture of the SAP HANA engine
Different modeling artifacts in SAP HANA
SAP HANA Studio
Different schemas in SAP HANA
Creating package and delivery unit
Self-study questions
Summary
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
Self-study questions
Summary
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
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
Creating input parameters and variables
Creating calculation views
Analytical privileges
Self-study questions
Summary
Chapter 6: Understanding Text Search and Hierarchies in SAP HANA
Creating and using Full Text Search
Creating hierarchies
Self-study questions
Summary
Chapter 7: Using Decision Tables and Transporting SAP HANA Content
What is a decision table?
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
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
Summary
Chapter 9: An Introduction to Application Function Library
Application Function Library
Predictive Analysis Library
Calling PAL functions
Business Function Library
Self-study questions
Summary

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.

Authors

Table of Contents

Chapter 1: Kickoff – Before We Start
Introducing SAP HANA SQL
The SAP HANA SQLscript
When should we use SQLscript?
Procedures
JOINS in SAP HANA
Unions versus JOINS
Self-study questions
Summary
Chapter 2: SAP HANA Data Modeling Approach
Row and column storage in SAP HANA
Basic architecture of the SAP HANA engine
Different modeling artifacts in SAP HANA
SAP HANA Studio
Different schemas in SAP HANA
Creating package and delivery unit
Self-study questions
Summary
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
Self-study questions
Summary
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
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
Creating input parameters and variables
Creating calculation views
Analytical privileges
Self-study questions
Summary
Chapter 6: Understanding Text Search and Hierarchies in SAP HANA
Creating and using Full Text Search
Creating hierarchies
Self-study questions
Summary
Chapter 7: Using Decision Tables and Transporting SAP HANA Content
What is a decision table?
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
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
Summary
Chapter 9: An Introduction to Application Function Library
Application Function Library
Predictive Analysis Library
Calling PAL functions
Business Function Library
Self-study questions
Summary

Book Details

ISBN 139781782174110
Paperback226 pages
Read More

Read More Reviews

Recommended for You

Software Development on the SAP HANA Platform Book Cover
Software Development on the SAP HANA Platform
$ 35.99
$ 10.00
SAP HANA Cookbook Book Cover
SAP HANA Cookbook
$ 29.99
$ 10.00
SAP Data Services 4.x Cookbook Book Cover
SAP Data Services 4.x Cookbook
$ 47.99
$ 10.00
SAP HANA Starter Book Cover
SAP HANA Starter
$ 19.99
$ 10.00
SAP Lumira Essentials Book Cover
SAP Lumira Essentials
$ 35.99
$ 10.00
SAP BusinessObjects Dashboards 4.1 Cookbook Book Cover
SAP BusinessObjects Dashboards 4.1 Cookbook
$ 39.99
$ 10.00