Real Time Analytics with SAP HANA
eBook - ePub

Real Time Analytics with SAP HANA

  1. 226 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Real Time Analytics with SAP HANA

Book details
Book preview
Table of contents
Citations

About This Book

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

About This Book

  • This book will help you to process analytical and transactional data in real time with the help of SAP HANA.
  • Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio.
  • Packed with rich examples and use cases that are closely focused on developing real-time applications.

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, then this book is for you.

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.

In Detail

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.

Style and approach

This is an easy-to-follow, step-by-step, rapid guide to help you learn analytics in SAP HANA through ample hands-on exercises and use case scenarios.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Real Time Analytics with SAP HANA by Vinay Singh in PDF and/or ePUB format, as well as other popular books in Informatica & Applicazioni per aziende. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Packt Publishing
Year
2015
ISBN
9781782174110
Edition
1
Topic
Informatica
Subtopic
Applicazioni per aziende

Real Time Analytics with SAP HANA

Table of Contents

Real Time Analytics with SAP HANA
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Kickoff – Before We Start
Introducing SAP HANA SQL
Classical SQL
The SAP HANA SQLscript
Why SQLscript?
How different is an SQLscript in SAP HANA from classical SQL queries?
When should we use SQLscript?
Procedures
Creating with the SQL editor (in SAP HANA Studio)
Procedure creation using the wizard
JOINS in SAP HANA
Unions versus JOINS
Self-study questions
Summary
2. SAP HANA Data Modeling Approach
Row and column storage in SAP HANA
Choosing the right table
Basic architecture of the SAP HANA engine
Different modeling artifacts in SAP HANA
Modeling principles
SAP HANA Studio
Perspectives in SAP HANA Studio
Adding our system to SAP HANA Studio
The system view
Different schemas in SAP HANA
Creating package and delivery unit
Deleting packages
Delivery units
Self-study questions
Summary
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
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
Calculated attribute
Calculated measures
Calculated columns
Creating variables
Self-study questions
Summary
5. Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views
Creating a restricted measure and a calculated measure
Creating filters
Steps for creating a filter
Creating input parameters and variables
Creating calculation views
Analytical privileges
Self-study questions
Summary
6. Understanding Text Search and Hierarchies in SAP HANA
Creating and using Full Text Search
Enabling the search option
Creating hierarchies
Creating a level hierarchy
Creating a parent-child hierarchy
Self-study questions
Summary
7. Using Decision Tables and Transporting SAP HANA Content
What is a decision table?
Why use decision tables?
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
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
9. An Introduction to Application Function Library
Application Function Library
Predictive Analysis Library
Calling PAL functions
Business Function Library
Self-study questions
Summary
Index

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 rev...

Table of contents

  1. Real Time Analytics with SAP HANA