Book Image

SAP HANA Cookbook

Book Image

SAP HANA Cookbook

Overview of this book

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.  

Related Content you might be interested in

Current Title:

Small book image
SAP HANA Cookbook
Dec, 2013 | 284 pages
No titles found
Table of Contents (16 chapters)
SAP HANA Cookbook
SAP HANA Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
SAP HANA Studio – Look and Feel
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
2
Data Provisioning
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
3
Modeling
Modeling
Introduction
Approaching SAP HANA modeling
Creating attribute views
Creating analytic views
Creating calculation views
Preparing documents – Auto Documentation
Modeling with Information Composer
4
Reporting
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
5
Advanced Features in SAP HANA
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
6
User Management
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
Introduction to SAP HANA
Introduction to SAP HANA
Introduction
Explaining traditional databases and bottlenecks
Introducing technology and hardware innovations
Looking into versions and technical requirements
Describing why you should use SAP HANA
Looking into SAP HANA features
Comparing BWA and SAP HANA
Architecture
Architecture
Understanding the SAP HANA architecture
Explaining IMCE and its components
Storing data – row storage
Storing data – column storage
Understanding the persistence layer
Understanding backup and recovery
Applications Powered by SAP HANA
Applications Powered by SAP HANA
Introduction
Introducing flavors on top of SAP HANA
Introducing SAP NetWeaver BW powered by SAP HANA
Introducing SAP Business Suite on SAP HANA
Index
Index

About the Reviewers

Isaias Barroso is a software architect who currently lives in Brazil. He is a specialist in high-performance and resilient software development, and he is responsible for Big Data technologies (SAP HANA, Hadoop, Pig, Hive, and so on) at the company he works for. He uses Java, Scala, and Groovy as the base programming languages for the development of projects, and he is always open to learning new programming languages that could help improve the readability and performance of code. He has architected and developed systems for many industries using different technologies over his career.

He is interested in machine learning and statistics applied on data analysis. SAP HANA is being used by him for the development of products to improve efficiency and predictive analysis for SAP HANA customers.

Mahesh Kumar CV has spent 10 years in SAP consultancy with extensive experience in the field of SAP Analytics (BW/HANA). He is a solution architect with progressive experience in design/development and consulting in SAP, specializing in SAP HANA 1.0 SP06, SAP NetWeaver Business Warehouse and BusinessObjects Reporting Tools, and especially in SAP BW/BOBJ, with subject-matter expertise in the Business Intelligence domain integrating to SAP HANA.

His experience includes end-to-end implementations, support, upgrades, and roll-up projects, as well as solution architecture and PreSales.

He is currently working as a Senior Manager in Big Data CoE at Rolta India Pvt Ltd. In the past, he has worked with CSC India Pvt Ltd, IBM India Pvt Ltd, and MindTree. His key recognitions include being a SAP mentor, SAP Topic Leader 2013 in SAP HANA Developer Center, and SAP Topic Leader 2013 in SAP HANA and In-Memory Business Data Management.

Kapil Ratnani is a software developer at SAP Labs, Bangalore, India. He holds a Master's degree in Information Technology from IIIT Bangalore. At SAP, he mainly focuses on mobile-application development and SAP HANA for backend processing. Apart from working at SAP, he has contributed to open source projects such as Notepad++, and has also launched his own open source projects such as Django_HANA and HANA SQLScript Formatter. When he is not coding, he can be found cycling around Bangalore.

Previous Section
Next Chapter