- 226 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Real Time Analytics with SAP HANA
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.
Tools to learn more effectively
Saving Books
Keyword Search
Annotating Text
Listen to it instead
Information
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
- Real Time Analytics with SAP HANA
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
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 990+ topics, we’ve got you covered! Learn about our mission
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 about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
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 Computer Science & Entreprise Applications. We have over one million books available in our catalogue for you to explore.