You are previewing SAP HANA Cookbook.
O'Reilly logo
SAP HANA Cookbook

Book Description

Your all-inclusive guide to understanding SAP HANA with over 50 recipes

  • Understand the architecture of SAP HANA, effectively transforming your business with the modeler and in-memory computing engine

  • Learn about Business Intelligence, Analytics, and Predictive analytics on top of SAP HANA Models

  • Gain knowledge on the process of transforming your data to insightful information using the Modeler

  • In Detail

    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.

    Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. 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.

    Table of Contents

    1. SAP HANA Cookbook
      1. Table of Contents
      2. SAP HANA Cookbook
      3. Credits
      4. About the Authors
      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. Errata
          2. Piracy
          3. Questions
      8. 1. SAP HANA Studio – Look and Feel
        1. Introduction
        2. Understanding SAP HANA Studio
          1. How it works…
          2. There's more…
            1. Platforms supported
            2. System requirements
            3. Installation paths
          3. See also
        3. Switching between different views – perspectives
          1. Getting ready
          2. How it works…
          3. How to do it…
          4. There's more…
          5. See also
        4. Navigating SAP HANA Studio – the Navigator Pane
          1. Getting ready
          2. How it works…
            1. System Monitor
            2. Administration
            3. SQL Console
            4. Find Table
            5. Find System
            6. Link with Editor
          3. There's more…
          4. See also
        5. Administering SAP HANA – the Administration Console perspective
          1. Getting ready
          2. How to do it…
            1. Adding a system
          3. There's more…
            1. Overview
            2. Landscape
            3. Services
            4. Configuration
            5. Redistribution Operations
            6. Alerts
            7. Performance
            8. Volumes
            9. Configuration
            10. System Information
            11. Diagnosis Files
            12. Trace Configuration
          4. See also
        6. Modeling SAP HANA Studio – the Modeler perspective
          1. Getting ready
          2. How it works…
          3. There's more…
            1. Information views
            2. SQLScript
          4. See also
      9. 2. Data Provisioning
        1. Introduction
        2. Loading data into SAP HANA – data provisioning methods
          1. Getting ready
          2. How to do it…
          3. How it works…
            1. SAP Landscape Transformation
            2. SAP Data Services
            3. Sybase replication
          4. There's more…
            1. Strategic considerations
            2. Technical considerations
          5. See also
        3. Uploading data from flat files
          1. Getting ready
          2. How to do it…
            1. Step 1 – creating a table in the SAP HANA system
            2. Step 2 – selecting the source file and target table in SAP HANA
            3. Step 3 – field mapping and loading data
          3. How it works…
          4. There's more…
          5. See also
        4. Using SLT to load data into SAP HANA
          1. Getting ready
          2. How to do it…
            1. SLT configuration – creating a connection
          3. How it works…
            1. Logging tables
            2. Read module
            3. Control module
            4. Write module
          4. There's more…
          5. See also
        5. Using SAP Data Services as an ETL tool to load data into SAP HANA
          1. Getting ready
          2. How to do it…
            1. Creating table in SAP HANA using the import of metadata option
              1. Step 1 – Creating a datastore for the source system in SAP Data Services
              2. Step 2 – Importing tables in SAP DS for the datastore created
              3. Step 3 – Configuring Import Server from the Quick Launch screen of SAP HANA Studio
              4. Step 4 – Importing metadata from SAP HANA Studio
            2. Creating a datastore for a target system – SAP HANA in SAP Data Services
              1. Creating a project
              2. Creating a job
              3. Creating a workflow
              4. Creating a data flow
              5. Designing the data flow
              6. Validating the data flow and saving the project
              7. Executing the job
          3. How it works…
          4. There's more…
          5. See also
        6. Loading data into SAP HANA using DXC
          1. Getting ready
          2. How to do it…
            1. Configuring DXC
            2. Loading data to SAP HANA
          3. How it works…
            1. An SAP source system on SAP NetWeaver Version 7.0 or higher, using the embedded SAP NetWeaver BW system
            2. An SAP source system on a version below SAP NetWeaver 7.0, using a side-by-side SAP NetWeaver BW system
          4. There's more…
            1. The Sidecar approach
          5. See also
        7. Loading data using SAP Sybase Replication Server
          1. Getting ready
          2. How to do it…
            1. Oracle to SAP HANA Replication setup
              1. Prerequisites
              2. Configuring Replication Server to SAP HANA
              3. Creating a Replication Server connection to the primary database
              4. Testing the replication
          3. How it works…
          4. There's more…
          5. See also
      10. 3. Modeling
        1. Introduction
        2. Approaching SAP HANA modeling
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        3. Creating attribute views
          1. Getting ready
          2. How to do it…
            1. Creating a package
            2. Creating an attribute view
          3. How it works…
          4. There's more…
          5. See also
        4. Creating analytic views
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Creating calculation views
          1. Getting ready
          2. How to do it…
            1. Creation of a calculation view using GUI
            2. Creation of a calculation view using SQLScript (native SQL or CE functions)
          3. How it works…
          4. See also
        6. Preparing documents – Auto Documentation
          1. How to do it…
            1. Model Details
            2. Model List
          2. How it works…
        7. Modeling with Information Composer
          1. Getting ready
          2. How to do it…
            1. Uploading data
              1. Selecting a data source and loading data into Information Composer
              2. Data cleansing
                1. Merging values
                2. Changing values
              3. Classification of data columns into attributes and measures
              4. Saving data into SAP HANA
            2. Composing information views
              1. Selecting data sources – Source A and Source B
              2. Combining data
              3. Refining the data
              4. Saving the view to SAP HANA and publishing
          3. How it works…
          4. There's more…
            1. My Data
            2. My Information Views
          5. See also
      11. 4. Reporting
        1. Introduction
        2. The reporting layer on top of SAP HANA
          1. How to do it…
          2. How it works…
          3. There's more…
          4. See also
        3. Connecting reporting tools to SAP HANA
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Creating reports using SAP BusinessObjects Web Intelligence
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Creating reports using SAP BusinessObjects Explorer
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        6. Creating reports using SAP BusinessObjects Dashboards/Xcelsius
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        7. Creating reports using SAP BusinessObjects Analysis for OLAP
          1. How to do it…
          2. How it works…
          3. There's more…
          4. See also
        8. Creating reports using Microsoft Excel
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        9. Creating reports in SAP Lumira
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      12. 5. Advanced Features in SAP HANA
        1. Introduction
        2. Converting different currencies
          1. How to do it…
          2. How it works…
          3. See also
        3. Creating hierarchies
          1. How to do it…
            1. Level hierarchy
            2. The parent-child hierarchy
          2. How it works…
          3. See also
        4. Creating variables
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        5. Creating input parameters
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        6. Creating filters
          1. How to do it…
          2. How it works…
          3. There's more…
        7. Creating procedures using SQLScript
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        8. Creating decision tables
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      13. 6. User Management
        1. Introduction
        2. Creating users
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Creating roles
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Assigning roles to users
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Restricting access to data – creating analytic privileges
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        6. Securing logging in to SAP HANA – authentication methods
          1. How to do it…
          2. How it works…
          3. See also
        7. Securing logging in to SAP HANA – privileges
          1. Getting ready
          2. How to do it…
          3. How it works…
      14. A. Introduction to SAP HANA
        1. Introduction
        2. Explaining traditional databases and bottlenecks
          1. How it works…
            1. Traditional databases
          2. There's more…
            1. Bottlenecks
              1. Latency
              2. Cost
              3. Architecture
          3. See also
        3. Introducing technology and hardware innovations
          1. How it works…
            1. Depth of data
            2. Broadness
            3. Real time
            4. Simplicity
            5. Retrieval speed
          2. There's more…
            1. Multicore CPUs
            2. Parallel processing
            3. Data compression
          3. See also
        4. Looking into versions and technical requirements
          1. How it works…
            1. Enterprise HANA
              1. Technical requirements
            2. SAP NetWeaver BW powered by SAP HANA
              1. Technical requirements
          2. There's more…
            1. Server
            2. RAM
            3. Log storage
            4. Data storage
          3. See also
        5. Describing why you should use SAP HANA
          1. Getting ready
          2. How it works…
            1. Traditional versus in-memory
          3. There's more…
          4. See also
        6. Looking into SAP HANA features
          1. Getting ready
          2. How to do it…
            1. Alignment of business and IT
            2. More efficient data processing
            3. Business analytic applications powered by technology
            4. Powerful analytic appliance – real-time insight
          3. How it works…
            1. A multi-engine query processing environment
            2. Representation of application-specific business objects
            3. Development of current hardware innovations
            4. Direct access to ERP
            5. Direct access to other (non-SAP) systems
          4. There's more…
            1. Leveraging BI capabilities
        7. Comparing BWA and SAP HANA
          1. Evolution of SAP BWA and SAP HANA
          2. How it works…
            1. Comparison
          3. See also
      15. B. Architecture
        1. Understanding the SAP HANA architecture
        2. Explaining IMCE and its components
          1. Further reading
            1. Session management
            2. Transaction manager
            3. Metadata manager
            4. Persistence layer
            5. Authorization manager
        3. Storing data – row storage
        4. Storing data – column storage
          1. The delta merge process
          2. Consistent view manager and transaction manager
        5. Understanding the persistence layer
          1. Further reading
        6. Understanding backup and recovery
          1. Further reading
      16. C. Applications Powered by SAP HANA
        1. Introduction
        2. Introducing flavors on top of SAP HANA
          1. How it works…
          2. See also
        3. Introducing SAP NetWeaver BW powered by SAP HANA
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        4. Introducing SAP Business Suite on SAP HANA
          1. How it works…
          2. See also
      17. Index