SAP HANA Cookbook

Your all-inclusive guide to understanding SAP HANA with practical recipes with over 50 recipes

SAP HANA Cookbook

Cookbook
Chandrasekhar Mankala, Ganesh Mahadevan V.

Your all-inclusive guide to understanding SAP HANA with practical recipes with over 50 recipes
$29.99
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection

Book Details

ISBN 139781782177623
Paperback284 pages

About This Book

  • Understand the architecture of SAP HANA, effectively transforming your business with the modeler and in-memory computing engine
  • Learn about Business Intelligence, Analytics, and Predictive analytics on top of SAP HANA Models
  • Gain knowledge on the process of transforming your data to insightful information using the Modeler

Who This Book Is For

If you are a solution architect, developer, modeler, sales leader, business transformation managers, directors, COO, or CIO; this book is perfect for you.

If you are interested in other technologies and want to jump-start into SAP, this book gives you the chance to learn SAP HANA. Basic knowledge of RDBMS concepts enough is to get you started.

Table of Contents

Chapter 1: SAP HANA Studio – Look and Feel
Introduction
Understanding SAP HANA Studio
Switching between different views – perspectives
Navigating SAP HANA Studio – the Navigator Pane
Administering SAP HANA – the Administration Console perspective
Modeling SAP HANA Studio – the Modeler perspective
Chapter 2: Data Provisioning
Introduction
Loading data into SAP HANA – data provisioning methods
Uploading data from flat files
Using SLT to load data into SAP HANA
Using SAP Data Services as an ETL tool to load data into SAP HANA
Loading data into SAP HANA using DXC
Loading data using SAP Sybase Replication Server
Chapter 3: Modeling
Introduction
Approaching SAP HANA modeling
Creating attribute views
Creating analytic views
Creating calculation views
Preparing documents – Auto Documentation
Modeling with Information Composer
Chapter 4: Reporting
Introduction
The reporting layer on top of SAP HANA
Connecting reporting tools to SAP HANA
Creating reports using SAP BusinessObjects Web Intelligence
Creating reports using SAP BusinessObjects Explorer
Creating reports using SAP BusinessObjects Dashboards/Xcelsius
Creating reports using SAP BusinessObjects Analysis for OLAP
Creating reports using Microsoft Excel
Creating reports in SAP Lumira
Chapter 5: Advanced Features in SAP HANA
Introduction
Converting different currencies
Creating hierarchies
Creating variables
Creating input parameters
Creating filters
Creating procedures using SQLScript
Creating decision tables
Chapter 6: User Management
Introduction
Creating users
Creating roles
Assigning roles to users
Restricting access to data – creating analytic privileges
Securing logging in to SAP HANA – authentication methods
Securing logging in to SAP HANA – privileges

What You Will Learn

  • Discover simple and powerful techniques to master SAP HANA DB technology, features, tools, and components.
  • Understand the technology and architecture of the SAP HANA database
  • Load data from different types of source systems into SAP HANA
  • Develop models – attribute/analytical/calculation views
  • Get to know the SAP HANA SQL Script language
  • Know about users and role maintenance, Solution Management, Monitoring, High Availability & Failover Management, Disaster Recovery and Management, Cloud Options
  • Create filters, variables, and hierarchies and stored procedures using SQL scripting
  • Make reports from SAP HANA's data
  • Develop user management skills by creating users and roles

In Detail

SAP HANA is a real-time applications platform that provides a multi-purpose, in-memory appliance. Decision makers in the organization can gain instant insight into business operations. Thus all the data available can be analysed and you can react to the changing business conditions rapidly to make decisions. The real-time platform not only empowers business users and top management to make decisions but also provides the capability to make decisions in real-time.

A practical and comprehensive guide that helps you understand the power of SAP HANA’s real-time and in-memory capabilities. It also provides step-by-step instructions to exploit all the possible features of the SAP HANA database, enabling users to harness the full potential of this technology and its features.

You will gain an understanding of real-time replications, effective data loading from various sources, how to load data, and how to create re-usable objects such as models and reports.

Use this practical guide to enable or transform your business landscape by implementing SAP HANA to meet your business requirements. The book shows you how to load data from different types of systems, create models in SAP HANA, and consume data for decision-making. The book covers various tools at different stages creating models using SAP HANA Studio, and consuming data using reporting tools such as SAP BusinessObjects, SAP Lumira, and so on . This book also explains the in-depth architecture of SAP HANA to help you understand SAP HANA as an appliance, that is, a combination of hardware and software.

The book covers the best practices to leverage SAP HANA’s in-memory technology to transform data into insightful information. It also covers technology landscaping, solution architecture, connectivity, data loading, and setting up the environment for modeling purpose (including setup of SAP HANA Studio).

If you have an intention to start your career as SAP HANA Modeler, this book is the perfect start.

 

Authors

Table of Contents

Chapter 1: SAP HANA Studio – Look and Feel
Introduction
Understanding SAP HANA Studio
Switching between different views – perspectives
Navigating SAP HANA Studio – the Navigator Pane
Administering SAP HANA – the Administration Console perspective
Modeling SAP HANA Studio – the Modeler perspective
Chapter 2: Data Provisioning
Introduction
Loading data into SAP HANA – data provisioning methods
Uploading data from flat files
Using SLT to load data into SAP HANA
Using SAP Data Services as an ETL tool to load data into SAP HANA
Loading data into SAP HANA using DXC
Loading data using SAP Sybase Replication Server
Chapter 3: Modeling
Introduction
Approaching SAP HANA modeling
Creating attribute views
Creating analytic views
Creating calculation views
Preparing documents – Auto Documentation
Modeling with Information Composer
Chapter 4: Reporting
Introduction
The reporting layer on top of SAP HANA
Connecting reporting tools to SAP HANA
Creating reports using SAP BusinessObjects Web Intelligence
Creating reports using SAP BusinessObjects Explorer
Creating reports using SAP BusinessObjects Dashboards/Xcelsius
Creating reports using SAP BusinessObjects Analysis for OLAP
Creating reports using Microsoft Excel
Creating reports in SAP Lumira
Chapter 5: Advanced Features in SAP HANA
Introduction
Converting different currencies
Creating hierarchies
Creating variables
Creating input parameters
Creating filters
Creating procedures using SQLScript
Creating decision tables
Chapter 6: User Management
Introduction
Creating users
Creating roles
Assigning roles to users
Restricting access to data – creating analytic privileges
Securing logging in to SAP HANA – authentication methods
Securing logging in to SAP HANA – privileges

Book Details

ISBN 139781782177623
Paperback284 pages
Read More