31,19 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Fachliteratur
- Sprache: Englisch
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.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Seitenzahl: 154
Veröffentlichungsjahr: 2015
Ähnliche
Table of Contents
Real Time Analytics with SAP HANA
Real Time Analytics with SAP HANA
Copyright © 2015 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: October 2015
Production reference: 1261015
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78217-411-0
www.packtpub.com
Credits
Author
Vinay Singh
Reviewers
Yatindra Mehta
Joselyn Quintero Veliz
Commissioning Editor
Kunal Parikh
Acquisition Editor
Reshma Raman
Content Development Editor
Anand Singh
Technical Editor
Utkarsha S. Kadam
Copy Editors
Kausambhi Majumdar
Merilyn Pereira
Alpha Singh
Project Coordinator
Paushali Desai
Proofreader
Safis Editing
Indexer
Rekha Nair
Graphics
Jason Monteiro
Production Coordinator
Melwyn Dsa
Cover Work
Melwyn Dsa
About the Author
Vinay Singh has MBA and BE (CS) degrees and is a SAP HANA/BI architect at Freudenberg Sealing Technology, Germany, working in the SAP Analytics area. He has nearly 10 years of SAP experience in the field of SAP product development and consulting. Before joining Freudenberg, he worked with companies such as SAP Labs, Adobe, and T-systems, which gave him a good mix of product development and consulting experience.
He has been an author and coauthor on numerous articles in various journals and has officially reviewed a couple of books on SAP Analytics topics. He is also a visiting faculty at Hochschule Furtwangen University, BW, where he teaches SAP HANA under the SAP UCC program.
It is a pleasure to acknowledge the help that I had with the preparation of this text.
The first mention goes to my wife, Minal, for her understating of the time I was spending on the book and her time-to-time feedback.
Many individuals have provided comments at various stages on portions of this book. Thanks to my parents, Naveen Rai, Soraya Dastager, Taha Mahmoud, and Shehab Hindam for their continuous support and encouragement and Bhavesh Ratnam, George Varghese, Munmun Singhania, and Kamalbasha Shafi for their direct / indirect contribution to the various chapters of the book. Special thanks to Joselyn Quintero and Yatindra Mehta for finding time to review the book and help make it better. I would like to appreciate and thank my publishing team and graphics team for their splendid work.
Finally, I sincerely thank my editors who worked closely with me: Anand Singh, Utkarsha S. Kadam, and Reshma Raman, without whom the book would not have been possible.
About the Reviewers
Yatindra Mehta is a SAP HANA architect and expert employed with SAP labs. He has been working in the SAP domain for around 10 years. He has executed various projects for manufacturing, retail, automotive, and telecommunications customers. He has served various prestigious customers in his career such as Siemens(SHC), T-COM, and Toyota to name a few. Currenlty, he works on the SAP HANA technology and helps customer leverage the SAP HANA technology, SLT, and so on.
I would like to thank Vinay, who gave me this opportunity to review his book. This is a really wondeful book, written precisely for learners in a simple and arcticulated way. Also, I would like to thank the publishers for publishing this amazing book.
Joselyn Quintero Veliz is a Venezuelan financial expert and SAP Financials senior consultant, with professional experience in the technology, oil, construction, manufacturing, and banking industries. Managing both business and technology environments, she is able to transform financial requirements into successful IT solutions. She possesses a certification of In-Memory Technology Databases for SAP HANA, issued by the Hasso Plattner Institute in Postdam, Germany.
Currently, Joselyn works as a freelance SAP process excellence senior consultant, helping companies take advantage of the latest SAP technologies to reach ambitious business goals.
In her free time, Joselyn spreads her personal financial knowledge across Latin America, through her website http://www.joselynquintero.com/. Joselyn also works in philanthropic initiatives as a Spanish translator at Animal Foundation Platform, promoting the ethical treatment of, and reducing the violence against, stray animals.
I want to first thank the author of the book for sharing valuable knowledge in these pages, providing useful information for people around the world. Secondly, I'd like to thank Packt Publishing for promoting high-level knowledge, and for inviting me to be part of this project. Last, but not least, I appreciate my family and friends for their support and patience and for not being there during the hours this book required my focus. We worked as a team, and we got it!
www.PacktPub.com
Support files, eBooks, discount offers, and more
For support files and downloads related to your book, please visit www.PacktPub.com.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at <[email protected]> for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
https://www2.packtpub.com/books/subscription/packtlib
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can search, access, and read Packt's entire library of books.
Why subscribe?
Free access for Packt account holders
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view 9 entirely free books. Simply use your login credentials for immediate access.
Instant updates on new Packt books
Get notified! Find out when new books are published by following @PacktEnterprise on Twitter or the Packt Enterprise Facebook page.
Preface
Real-time analytics is revolutionizing the way we interact with customers, partners and system in totality. The continuous evolution of technology is changing the way we do business. Uncertainty and change in the global marketplace is driving new ideas and innovation. Competing in this new hyper-connected and digitized world requires a new business platform that meets the demand for speed and innovation with reduced complexity. The demand for real-time data and analytics is so pervasive that every customer, big or small, wants to have it.
Real-time analytics is basically the use of (or to have an option to use) all the available data and resources within the enterprise as and when they are needed. The term real-time analytics implies practically instant access and use of analytical data.
As it turns out, to answer this need and the changes in the business, SAP came up with a complete out-of-the-box solution, transforming the database industry by combining database, data processing, and application platform capabilities into a single in-memory platform called SAP HANA. SAP HANA makes it possible for applications and analytics to run without information processing latency. It also allows to build sense and response solutions on a large volume of real-time data without thinking of pre-aggregates.
To answer why you should choose SAP HANA for real-time analytics, we would have a look at the key capabilities of SAP HANA, such as Massive speed—the scan speed of the SAP HANA database is 3.19 billion symbol per second per core (in lab conditions). High efficiencies—if you port the data from a classical database to SAP HANA, eliminating unnecessary indexes and aggregate tables and allowing operational reporting directly on SAP HANA, the data footprint could be reduced by a factor of as high as 37. The data compression rate is approximately 4 to 1. Lower cost providing a dual OLTP—the OLAP architecture reduces the data footprint, which saves on storage costs.
Eliminating the need for data extraction and transfer from OLAP to OLTP saves time and resources. Flexibility—SAP HANA is an ideal big data analytics platform, capable of efficiently loading and rapidly analyzing multiple data types in both structured and unstructured forms.
While there are many tools in the market for real-time analytics, this book discusses how we can use all the preceding mentioned features of SAP HANA and design our data models for real-time analytics. We will be working on SAP HANA as a sidecar / standalone scenario to create our data models. This book is organized into four parts, discussing various concepts related to data modeling.
This book has a particular structure, as follows:
Chapters 1, 2, and 3, describe how we can setup the platform for SAP HANA
Creating data models:Chapters 4 and 5 explain how to create data models in SAP HANA
Supporting concepts of data modeling:Chapters 6 and 7 elaborate the supporting concepts to create data models in SAP HANA
Reporting on data models:Chapters 8 and 9 deal with the creation of reports
What this book covers
Chapter 1, Kickoff – Before We Start, sets the basic concepts and building blocks for the book. It talks about the prerequisite development skill that you must have before we plunge into data modeling.
Chapter 2, SAP HANA Data Modeling Approach, covers the approach to SAP HANA data modeling and the do's and dont's while creating data models.
Chapter 3, Different Ways of SAP HANA Data Load, teaches you how to load data into SAP HANA, explore various options of data load as per the data source and need, understand real-time replication via SLT, and use SAP HANA Studio for the Data Load.
Chapter 4, Creating SAP HANA Artifacts Attribute Views and Analytical Views, teaches you how to create HANA artifacts—Attribute view and Analytical view. You will learn the various other components involved during the creation of these Artifacts.
Chapter 5, Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views, teaches you how to create HANA artifacts—Analytical privileges and Calculation views. You will learn the various other components involved in the creation of these Artifacts.
Chapter 6, Understanding Text Search and Hierarchies in SAP HANA, talks about hierarchies and Text Search in SAP HANA, how to create and use them in our data models for real time analytics, how to create and use Full Text Search, how to create hierarchies as per usage, and understanding the concept of parent-child hierarchies and level hierarchies.
Chapter 7, Using Decision Tables and Transporting SAP HANA Content, teaches you how to work with additional capabilities of SAP HANA such as decision tables and currency conversion. You will also learn how our SAP HANA Artifacts can be transported across the landscape.
Chapter 8, Consuming SAP HANA Data Models, teaches you reporting with SAP HANA data models by using your own data models created in previous chapters for reporting. It also talks of a general overview of all the tools available in SAP HANA.
Chapter 9, An Introduction to Application Function Library, explores the AFL library. You will learn how the deliver prepackaged functionality can be used in building information models faster and in an easier way. It will also discuss the AFL deliver prepackaged functionality, which will help us to know what the inbuilt functions are that can be used without reworking/redeveloping.
What you need for this book
We will consider only the software requirement for the end user perspective. You will need to have SAP HANA Studio installed on your client machines and should have access to the SAP HANA server instance. We discuss the steps to add an instance to SAP HANA Studio in Chapter 2, SAP HANA Data Modeling Approach.
The software requirements are as follows:
Who this book is for
If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, this book is for you.
Conventions
In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.
Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "We can include other contexts through the use of the include directive."
A block of code is set as follows:
Any command-line input or output is written as follows:
New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "You can see the created procedure below our schema under the Procedures... folder."
Note
Warnings or important notes appear in a box like this.
Tip
Tips and tricks appear like this.
Reader feedback
Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or disliked. Reader feedback is important for us as it helps us develop titles that you will really get the most out of.
To send us general feedback, simply e-mail <[email protected]>, and mention the book's title in the subject of your message.
If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide at www.packtpub.com/authors.
Customer support
Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.
Downloading the example code
You can download the example code files from your account at http://www.packtpub.com for all the Packt Publishing books you have purchased. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files e-mailed directly to you.
Downloading the color images of this book
We also provide you with a PDF file that has color images of the screenshots/diagrams used in this book. The color images will help you better understand the changes in the output. You can download this file from https://www.packtpub.com/sites/default/files/downloads/4110EN.pdf.
