Real Time Analytics with SAP HANA

Real Time Analytics with SAP HANA

by Vinay Singh
Released October 2015
Publisher(s): Packt Publishing
ISBN: 9781782174110

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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.

Table of contents

  1. Real Time Analytics with SAP HANA
    1. Table of Contents
    2. Real Time Analytics with SAP HANA
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers, and more
        1. Why subscribe?
        2. Free access for Packt account holders
        3. Instant updates on new Packt books
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Downloading the color images of this book
        3. Errata
        4. Piracy
        5. Questions
    8. 1. Kickoff – Before We Start
      1. Introducing SAP HANA SQL
        1. Classical SQL
      2. The SAP HANA SQLscript
        1. Why SQLscript?
        2. How different is an SQLscript in SAP HANA from classical SQL queries?
      3. When should we use SQLscript?
      4. Procedures
        1. Creating with the SQL editor (in SAP HANA Studio)
        2. Procedure creation using the wizard
      5. JOINS in SAP HANA
      6. Unions versus JOINS
      7. Self-study questions
      8. Summary
    9. 2. SAP HANA Data Modeling Approach
      1. Row and column storage in SAP HANA
        1. Choosing the right table
      2. Basic architecture of the SAP HANA engine
      3. Different modeling artifacts in SAP HANA
        1. Modeling principles
      4. SAP HANA Studio
        1. Perspectives in SAP HANA Studio
        2. Adding our system to SAP HANA Studio
          1. The system view
      5. Different schemas in SAP HANA
      6. Creating package and delivery unit
        1. Deleting packages
        2. Delivery units
      7. Self-study questions
      8. Summary
    10. 3. Different Ways of SAP HANA Data Load
      1. Loading data from Flat file in SAP HANA
      2. Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
      3. Loading data with SAP Direct Extractor
      4. Application server configuration
      5. Creating a DXC schema and user in SAP HANA
      6. Loading data in SAP HANA with Data Services Workbench
      7. SAP Replication Server
      8. Smart Data Access
      9. Self-study questions
      10. Summary
    11. 4. Creating SAP HANA Artifacts Attribute Views and Analytical Views
      1. Steps to adjust preferences
      2. Creating attribute views
      3. Defining attribute and key attribute
      4. Creating time attribute views
      5. Creating analytical views
      6. Creating other elements
        1. Calculated attribute
        2. Calculated measures
        3. Calculated columns
        4. Creating variables
      7. Self-study questions
      8. Summary
    12. 5. Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views
      1. Creating a restricted measure and a calculated measure
      2. Creating filters
        1. Steps for creating a filter
      3. Creating input parameters and variables
      4. Creating calculation views
      5. Analytical privileges
      6. Self-study questions
      7. Summary
    13. 6. Understanding Text Search and Hierarchies in SAP HANA
      1. Creating and using Full Text Search
        1. Enabling the search option
      2. Creating hierarchies
        1. Creating a level hierarchy
        2. Creating a parent-child hierarchy
      3. Self-study questions
      4. Summary
    14. 7. Using Decision Tables and Transporting SAP HANA Content
      1. What is a decision table?
        1. Why use decision tables?
      2. Transport management in SAP HANA
      3. SAP HANA application lifecycle manager
      4. Transporting a delivery unit with HALM
      5. Export and import – moving SAP HANA content manually
      6. Currency conversion in SAP HANA
      7. Self-study questions
      8. Summary
    15. 8. Consuming SAP HANA Data Models
      1. Connecting to the SAP HANA database
      2. Reporting tools for SAP HANA
      3. Analysis for Office
      4. SAP Business Objects Analysis for OLAP
      5. Using Microsoft Excel as a reporting tool
      6. Summary
    16. 9. An Introduction to Application Function Library
      1. Application Function Library
      2. Predictive Analysis Library
      3. Calling PAL functions
      4. Business Function Library
      5. Self-study questions
      6. Summary
    17. Index

Product information

  • Title: Real Time Analytics with SAP HANA
  • Author(s): Vinay Singh
  • Release date: October 2015
  • Publisher(s): Packt Publishing
  • ISBN: 9781782174110